Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Scripting all SQL configuration options Expand / Collapse
Author
Message
Posted Monday, January 25, 2010 12:34 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Yesterday @ 3:21 PM
Points: 207, Visits: 369
I have to set up some new servers and copy some systems down however I have a load of settings on the server for each DB I want to copy such as

sp_fulltext_service 'verify_signature', 0;

ALTER DATABASE XXXXX SET TRUSTWORTHY ON

etc etc

I have had a look through the standard SSIS export options but they don't script out these options.
I have had a quick look at the system views as well thinking I could generate a script from there but haven't found a view with the relevant info.

Does anyone have a script that will output all the necessary SQL for extended config options such as those mentioned and more?

Thanks in advance for any help received.
Post #853237
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse