Originally posted by Satya
Have a look at SP_ADDALIAS under BOL.
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