Tag Archives: Database

SQL error “Property Owner is not available for Database

Run the following command to set a new owner, in this example DBO. The database name in this example is newtraders. use NEWTRADERS go sp_changedbowner @loginame = ‘dbo’ go

Posted in Microsoft General | Tagged , , | Leave a comment

Creating a SQL Linked Server to an Oracle database server

Within SQL it is possible to create a Linked Server to connect to an Oracle database server. In previous versions of SQL, this was done by using the OLE DB Provider for Oracle. But this is this component is currently … Continue reading

Posted in Microsoft General | Tagged , , | Leave a comment