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
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment