October 29, 2009 at 9:36 am
We have to data bases say 1 and 2 and we have restored the data base 1 and 2 from live to our test environment.
Now we are trying to re-register the scripts for clr procs and its giving us the following errors:-
SQL Server Database Error: The database owner SID recorded in the master database differs from the database owner SID recorded in database 'Test'. You should correct this situation by resetting the owner of database 'Test' using the ALTER AUTHORIZATION statement.
Why this is coming? Is that because DB ID's on live and Test environment are different?
cheers
Siddarth
October 29, 2009 at 11:12 am
Its sorted by changing data base owner. when data base x was restored from live to test, both env had different data base ids. we changed the owner and it worked.
cheers
siddarth
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply