Right Click the database, All Tasks, Generate SQL Script, then go to the
Options tab and choose the options you want. You can create one file or
separate.
-----Original Message-----
From: Dylan Jones
[mailto:mssqldba-ezmlmshield-x66582522.[Email address protected]
Sent: Tuesday, June 28, 2005 7:40 AM
To: LazyDBA Discussion
Subject: Scripting Database Users
Hi All,
What are the TSQL statements I can run that will
1) script all database users and roles - save to file
2) script all object level permissions - save to file
3) Script all SQL Logins - save to file
save the results to file
then
recreate
1) all database users and roles
2) all object level permissions
3) all SQL Logins
by referencing the the files created above?
Dylan Jones
Senior Business Analyst
SurfControl
Direct: 831-440-2568
Cell: 831-566-3089
Fax: 831-440-2615
Dylan.[Email address protected]
www.surfcontrol.com
Get the latest news on SurfControl and our products,
subscribe to our monthly e-newsletter, SurfAdvisory at:
http://www.surfcontrol.com/resources/surfadvisory/surfadvisory_signup.as
px
*********************************************************************
The information in this email is confidential and may be legally
privileged. It is intended solely for the addressee. Access to this
email by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution or any action taken
or omitted to be taken in reliance on it, is prohibited and may be
unlawful. If you believe that you have received this email in error,
please contact the sender.
*********************************************************************
SurfControl Inc.
5550 Scotts Valley Drive
Scotts Valley, California 95066
831-440-2500
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website :
http://www.LazyDBA.com To unsubscribe:
http://www.lazydba.com/unsubscribe.html
MS Sql Server LazyDBA home page