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 |
| Published |
: Wednesday, 19 July, 2006 |
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.