What's up!

Pyaarey Allah!

Sunday, December 26, 2010

Sql Server DB Diagram Permissions Workaround

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

0 comments: (+add yours?)

Post a Comment