Tuesday, 12 May 2015

The database owner SID recorded in the master database differs from the database owner SID recorded in database by serverku

Before week one, day I received a lot of error in the SQL Server error log which causing log file full add I checked and found the following error continuously occurred for various service broker queues.

The activated proc '<SP name>' running on queue '<Queue Name>' output the following:  'The database owner SID recorded in the master database differs from the database owner SID recorded in database '<DB Name>'. You should correct this situation by resetting the owner of database '<DB Name>' using the ALTER AUTHORIZATION statement.'

As per error, it is needed for resetting the owner of the database. So first found the owner of the database and apply following command with using 'sa' in my case.
ALTER AUTHORIZATION ON DATABASE::[DB Name] to SA
GO
Finally, it resolved and came from errors in SQL server error log. I would like to invite to share such errors and solutions here, which may be a help to all readers.

No comments:

Post a Comment

Please Use Good Leanguage