Tuesday, July 18, 2006

Enable digrames in sql 2005 after importing from older sql versions

--enable SQL 2005 digrame

EXEC sp_dbcmptlevel 'YourDBName', '90';
go
ALTER AUTHORIZATION ON DATABASE::YourDBName TO "YourLoginName"
go
use [YourDBName]
go
EXECUTE AS USER = N'dbo' REVERT
go