Hello all!
No so long ago sp_helpdb on MS SQL 2000 began to fail with error:
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100000872'; column does not allow nulls. INSERT fails.
The statement has been terminated.
I execute script from one of older posts and found that db model have no owner.
But I can't change owner of db model through sp_changedbowner.
Is there any another ways to fix it?
No so long ago sp_helpdb on MS SQL 2000 began to fail with error:
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________000100000872'; column does not allow nulls. INSERT fails.
The statement has been terminated.
I execute script from one of older posts and found that db model have no owner.
But I can't change owner of db model through sp_changedbowner.
Is there any another ways to fix it?