--Run this Code in sql qurry window
EXEC sp_dbcmptlevel 'your Database Name', '90';
go
ALTER AUTHORIZATION ON DATABASE::[DatabaseName] TO "YourLoginName"
go
use [DatabaseName]
go
EXECUTE AS USER = N'dbo' REVERT
go
Subscribe to:
Post Comments (Atom)
3 comments:
Can u please explain whats describe by '90'
EXEC sp_dbcmptlevel 'your Database Name', '90';
go
why 90?
90 is the version of SQL Server with which the database is to be made compatible. The value must be one of the following:
80 = SQL Server 2000
90 = SQL Server 2005
100 = SQL Server 2008
Post a Comment