January 1, 2012 at 10:42 am
Happy New Year!:-)
If you right click on a Database in SSMS you get an error about the owner of the Database.
What is the risk of changing the Database Owner to SA or another Account.
Could this potentially cause a SQL Server Agent Job to Fail?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 1, 2012 at 12:00 pm
You get that error because the previous owner is now an invalid login. That being the case the login was obviously not essential to the operation of the database, so it is safe to change the owner to 'sa' or any other existing login you have assigned for database ownership.
---------------------------------------------------------------------
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply