You can use either query analyzer or enterprise manager to do it but you have to drop the user from the database, and then issue the sp_changedbowner.

Good luck

Tom

Thanks Steve,

That's what I thought just wanted to make sure.

Tom

We've had a similar problem trying to see who is actually connecting to the database. It seems that Access stores the original creator of the database somewhere and any...

I think that this has to do more with how much administration you want to handle. On our test system, we have linked servers to production. We often...