OK, I can create login in SS,
But how to add users to databases and roles?
"sp_grantdbaccess cannot be executed from within a user-defined transaction",
also sp_addrolemember.
Stored proc is user-defined transaction.

I have central server and local server(s).
Accounts are managed from special maintainance app which runs in central location. I need to "replicate" creation, deletion and resseting of psswd to local location.

Vytautas

>Are you asking for a way to manage users using stored procedures? If so, yes. Take a look at sp_addlogin and sp_grantlogin. You might also want to Administering SQL Server | Managing Security | Creating Security Accounts.
>
>-Mike