Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL 7 SP2 upgrade
- Thread starter nfawcett
- Start date
ChrisSharratt
Technical User
Suggest you open Query Analyzer & execute:
sp_helpdb
on the master database.
This will tell you the current state of all databases in the system, and should point you in the direction of the one that is failing.
Once isolated, the database properties can be changed through Enterprise Mgr... Just right-click the database, and select "Properties"...
sp_helpdb
on the master database.
This will tell you the current state of all databases in the system, and should point you in the direction of the one that is failing.
Once isolated, the database properties can be changed through Enterprise Mgr... Just right-click the database, and select "Properties"...
- Thread starter
- #3
ChrisSharratt
Technical User
Sorry for the delay in writing back.
It shouldn't be - SA is a member of Sysadmins, which means it can do pretty much whatever it likes.
If you want to try it out, change the dbowner back to SA (sp_changedbowner - look in Books on-line for more info.) perform the upgrade & then switch it back again.
Failing that, I suggest you do some checking using the database consistency checker:
DBCC CHECKDB <Database>
Again see BOL for more details.
It shouldn't be - SA is a member of Sysadmins, which means it can do pretty much whatever it likes.
If you want to try it out, change the dbowner back to SA (sp_changedbowner - look in Books on-line for more info.) perform the upgrade & then switch it back again.
Failing that, I suggest you do some checking using the database consistency checker:
DBCC CHECKDB <Database>
Again see BOL for more details.
- Status
Similar threads
- Locked
- Question
