After rebuild server some dbs do not have dbo | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

After rebuild server some dbs do not have dbo

When i run this :<br />select SID, name, user=suser_sname(sid), convert(nvarchar(11), crdate),<br />dbid, cmptlevel from master.dbo.sysdatabases<br />where suser_sname(sid) is null<br />some dbs have nulls in user field.<br />When i check db users manually the are there.<br />I mean sa is dbo.<br />Looks like sa sid do not much<br />What shoud i do sp_change_users_login doesn’t work sp_changedbo either<img src=’/community/emoticons/emotion-2.gif’ alt=’:d’ />bo actually exist
Run sp_changedbowner to change to another login than sa, then run it again to switch back to sa. /Argyle
thank you very much:it worked!
]]>