Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Wilfred van Dijk,
Procedure accepts 4 parameters, @databasename is mandatory.
In case you have multiple instances, change the 2nd parameter.
If you change @debug to 1, generated commands are displayed, not executed
if you change @verbose = 0, no output is generated
Snapshot is located on default datapath.
Make sure this procedure works correctly, use it in a test environment first. Also, use the @debug=1 parameter to test the generated SQL code.
Change Size of Parameter Field
Generate stored procedure parameter list based on table, useful when creating new SPs on tables with...
ReportViewer (web control) - parameter change refresh
Can't change the start up parameter - "-m;"
How to change the boolean parameter value