ALI AL-MOSAWI Blog
Pages
My Blog
Conferences, Events, Labs & Camps Attended
My Projects
About Me
Tuesday, July 18, 2006
Enable digrames in sql 2005 after importing from older sql versions
Email This
BlogThis!
Share to Twitter
Share to Facebook
Share to Pinterest
Posted by
Ali Al-Mosawi
--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
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)