Quick Scan Report – No Database Owner

A database exists with no owner, likely caused by the owners user account being deleted.

 

You can use the following TSQL to set a database owner to sa. This replaces the deprecated function sp_changedbowner.


use [databasename];

GO

ALTER AUTHORIZATION ON DATABASE::databasename to sa;

 

Need help?

If you need help configuring alerts or anything else with your SQL Server, you can contact me (Steve Stedman) through my SQL Server consulting business Stedman Solutions, LLC.

http://StedmanSolutions.com


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!