I have become responsible for setting up new accounts for our SQL databases.
Is there a (easy) way to copy logins and users ?
The best way so far I've found is to set up the login normally and then "sp_addrolemember" in the query analyser , after copying the info from a sp_helpy=user results into excel.
This seems as much hassle as going through 'manually'.
the 'trained' staff here say a 'copy' can't be done.
There must be an easier way to do it ? Paul C.
s-)
Is there a (easy) way to copy logins and users ?
The best way so far I've found is to set up the login normally and then "sp_addrolemember" in the query analyser , after copying the info from a sp_helpy=user results into excel.
This seems as much hassle as going through 'manually'.
the 'trained' staff here say a 'copy' can't be done.
There must be an easier way to do it ? Paul C.
s-)
