Hi SQLBill,

Thanks for your message. It is set to Mixed Mode so if you have any ideas please let me know.

Brian

Hi, no you did not misunderstand my question - sorry for the confusion. What I meant was that I did the next step you mentioned and used the stored procedure sp_changedbowner to...

I didn't answer your other question - yes, I did specifically try to set the owner to sa.

Yes, it is wierd. I used the stored procedure to change the db owner and that was OK. I just wish I knew why when I attach a database that...