Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
copy users
- Thread starter jvande
- Start date
tlbroadbent
MIS
This works in SQL 2000. I believe it works in SQL 7 but cannot test it at the moment.
In Enterprise Manager, right-click the database that contains the users. Select All Tasks | Generate SQL Script. Click on the Options tab and check Script database users and database roles. Either generate a script file or click Preview on the General tab.
Open Query Analyzer. Change the QA context to the 2nd database. If you generated a script file, open it from QA. If you generated a preview in EM, copy the script to the clipboard and paste into the query window of QA. Run the script to add the users in the 2nd database. Terry L. Broadbent
Programming and Computing Resources
In Enterprise Manager, right-click the database that contains the users. Select All Tasks | Generate SQL Script. Click on the Options tab and check Script database users and database roles. Either generate a script file or click Preview on the General tab.
Open Query Analyzer. Change the QA context to the 2nd database. If you generated a script file, open it from QA. If you generated a preview in EM, copy the script to the clipboard and paste into the query window of QA. Run the script to add the users in the 2nd database. Terry L. Broadbent
Programming and Computing Resources
- Status
Similar threads
- Locked
- Question
- Locked
- Question
