January 23, 2008 at 9:49 am
I've found that the model db on one of our SQL2000 shows as owned by [unknown] and this causes failure of the sp_helpdb (no argument), as well as who knows what other problems. Unfortunately I can't fix the ownership with sp_changedbowner, because that does not permit changing the model, master, or msdb databases.
What is the safest way to fix this?
...
-- FORTRAN manual for Xerox Computers --
January 23, 2008 at 10:55 am
I assume you already came accross an ugly solution that updates the system table...otherwise, you may need to call MS support.
_____________
Donn Policarpio
January 23, 2008 at 11:25 am
First select * from sysdatabases where name = 'model'
If this returns a NULL for the SID then try
sp_configure 'allow updates', 1
reconfigure with override
update sysdatabases
set sid = 0x01
where name = 'model'
sp_configure 'allow updates', 0
reconfigure with override
If you don't feel confortable with altering system tables directly you may need to rebuild the master database (exec rebuildm.exe) which will take care of model as well. This means downtime though.
Francis
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply