Need stored proc to make aliases to users...

I need a stored proc to make all aliases to users, then assign these newly created users to the same db's (which the aliases were assigned to).

Are there any other ways, or just to write a stored proc?

ANY suggestions accepted, just pls help, i need this for yesterday, and have not much experience in this :(Have a look at SP_ADDALIAS under BOL.

HTH|||Originally posted by Satya
Have a look at SP_ADDALIAS under BOL.

HTH

I mean I want to change the aliases to users, not to add an alias to a user.
(eg. you have a db, and there are 50 users and 10 aliases. You don't want to use aliases. So you have to make users from them.)

I need help in this, sorry is anybody misunderstood :)

So I have to drop all aliases, and create users with the same names, and assign them to the correct db-s.

But this have to work automatically...any scripts? commands?...etc