ScriptSqlConfig
ScriptSqlConfig copied to clipboard
billgraziano
Script SQL Server configuration information in a format suitable for DR purposes or checking into a source control system
When all jobs are scripted to one file they aren't separated by a GO statement.
Such as ``` grant view server state to User1; grant view database state to User1; grant select on sys.dm_db_index_usage_stats to User1; ```
Need a way to script the database owner. This is for DR use.
Assuming we are building a new server and restoring .. script out the Trustworthy flag and set it.
Metadata
Owner
Metadata
Script SQL Server configuration information in a format suitable for DR purposes or checking into a source control system