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’
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