Beautiful! Thank you very much!

Thank you everyone!

I have put together an osql command (and am looking at the eisql) but when I try to run "Exec sp_detach_db...", it says that it cannot detach the...

OK, just found out that the user is not in database B. When I go to EM, Security, Logins, and look at the user's database access, the user has...

Thank you everyone. I'll let you know what I find out about this problem.

Thank you for the definition!

What is the definition of an orphaned user?

Actually, I had another query that showed the top 10 tables in a database (thanks to a poster on this board!). I changed that and now I am getting...

Thank you!

Actually, I have a sort of a different question.

If we want to back up and restore the databases on a server onto a new server, will the users be also...

Thank you guys.

Hi Allen, how is that done? When I go to EM and try to Generate SQL Scripts, I don't see users listed. Thanks.

Thank you rock, I was hoping to get the whole statement.  But this will do half the job

Thank you RD, definitely keep us posted. Thank you.

RD, did you find out what was wrong?

Hi Peter, sorry for the late response.

I am trying to remove it from EM.

I tried running sp_dropserver and got the same error message.

Thanks.