How can I tell if a user exists on a given db, via SQL?
I'm new to db management, but the job I'm at right now requires me to
learn it yesterday. Please go easy on this poor boy. :)
msSQl server 7 --- i have 40 databases and I've added a 41st. All of
these database are copies of each other, except for differnt datebase
names. Only a select group of people access these data bases, about
60 or so. I need to add this group of people to the new 41st database
so they can access this new bank. The only way I can think of doing
this is to manualy add each user in Enterprise Manager(ugh).
Is there a way I can create a group of users and add that group to the
Is this where I need to look into Roles?
What query should I be reading up on that I can just replay, with
modifications, the next time I need to add the same users to a new
Any thoughts or links would be wonderful.
Thanks waaaay in advance.