SQL error “Property Owner is not available for Database
Posted onRun 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
Tag: SQL
SQL Server Scheduled Job fails to execute
Posted onSQL 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 group/user DOMAIN\SAACCOUNT, error code 0x5. [SQLSTATE 42000] (Error 15404)). This is due to the fact […]
Creating a SQL Linked Server to an Oracle database server
Posted onWithin 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 in maintenance mode. No new updates are planned for future releases of these components including […]