In em right click the DB go to all tasks. The forth option is generate
scripts. When the wizard appears click the options tab and select which
options you want. Go back to the general page and preview it the copy and
paste to a txt file or into QA.
-----Original Message-----
From: Dylan Jones
[mailto:mssqldba-ezmlmshield-x66582522.[Email address protected]
Sent: Tuesday, June 28, 2005 10: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.aspx
*********************************************************************
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