Backup a database
This procedure when executed with the correct parameters, backs up a database in the specified directory pathUsage :exec USP_BACKUPDATABASE databasename, directory_path
2002-03-12
574 reads
Script to export Stored Procedures
This procedure when executed with the correct parameters, exports all stored procedures from a database into different .SQL files in the path specified.Usage :exec USP_PRINT_PROCS username, password, servername, databasename, directory path
2002-03-12
444 reads
Blogs
Daily Coping 19 Oct 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Commenting a branching IF-THEN-ELSE.
I’m a big fan of comments (MSSQL, Powershell), so along those lines here’s an...
External Temp Tables Preventing Plan Reuse in Stored Procedures
Here’s an interesting issue that recently came up. We were seeing very high compilations...
Forums
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Grouping , time difference in minutes
Hi, I'm trying to query the amount of minutes a column value stays below...
Reset of a single column in sys.dm_exec_query_stats
Dear friends, I have a custom performance monitor based on snapshotting sys.dm_exec_query_stats, and now...
Ask SSC