Saturday, November 15, 2008

Msg 33009 IN SQL CLR

Msg 33009, Level 16, State 2, Line 1

The database owner SID recorded in the master database differs from the database owner SID recorded in database 'AdventureWorks'. You should correct this situation by resetting the owner of database 'AdventureWorks' using the ALTER AUTHORIZATION statement.

SOL:

USE

GO

EXEC dbo.sp_changedbowner

@loginame = N'sa',

@map = false

GO

No comments: