GeekZilla
Change Database Owner Following Restore
I upgraded a SQL 2000 database to SQL 2005 by backing up and restoring.
However when this was done, the database does not have a valid owner and you will not be able to add diagrams etc.
To resolve this you will need to run the following SQL
EXEC sp_dbcmptlevel 'DBName', '90'; go ALTER AUTHORIZATION ON DATABASE::[DBName] TO "Valid Login" go use [DBName] go EXECUTE AS USER = N'dbo' REVERT go
Author Greg Duffield
Greg has too many years experience in developement from VB for DOS all the way through to Windows Workflow and LINQ while covering pretty much every technology in between. A complete MS evangelist he is now Director of the only MS Gold Partner IT services company in Norfolk. Wehere they are producing Web 2 Applications for various sectors, and are currently entering the Haulage industry with their latest product.
