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.