Sql : Database Unknown Owner

·

·

SELECT Name AS DBName,suser_sname(sid) AS Owner FROM master.dbo.sysdatabases WHERE suser_sname(sid) IS NULL

If you get any results, you can set an owner for those databases using:

USE <THE DATABASE NAME>EXEC sp_changedbowner ‘sa’



Leave a Reply

Your email address will not be published. Required fields are marked *