Jonathan Marshall (7/8/2011)
exec sp_changedbowner 'sa'
as you're not using a USE statement, what database focus did you have set for the query window?
also did the user account exist on the mirror server, you need to ensure accounts are synchronised between the 2 instances?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉