SQL Server Performance Forum – Threads Archive
After rebuilding server sp_helpdb doesn’t work
I restored master,msdb,user dbseverything works fine but sp_helpdb gives me error message : Cannot insert the value NULL into column ‘owner’, table ‘tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________0001000023CF’; column does not allow nulls. INSERT fails.
The statement has been terminated. Did i had to restore tempdb as well?
I find the following: http://archive.dbforums.com/71/2002/11/554105 I hope will help. Luis Martin
Fixed. After rebuilding server a few dbs had mismuch in sid in sysusers and syslogins
As Argyle suggested i used sp_dbowner twice 1.sp_dbowner ‘somelogin’,’sa’
2.sp_dbowner ‘sa’,’sa’ it fixed sid
]]>