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 X
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