After rebuilding server sp_helpdb doesn't work | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

After rebuilding server sp_helpdb doesn’t work

I restored master,msdb,user dbs
everything 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: 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