Tag Archives: SQL

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

SQL Server Scheduled Job fails to execute

SQL Server Scheduled Job ‘MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb’ (0x9550CE8A82FC08489D1CCDE01A38C057) – Status: Failed – Invoked on: 2016-01-25 15:16:00 – Message: The job failed.  Unable to determine if the owner (DOMAIN\ACCOUNT) of job MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb has server access (reason: Could not obtain information about Windows NT … Continue reading

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