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
556 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
429 reads
Blogs
Kubernetes Pipelines
By Steve Jones
This post continues looking at some of the Kubernetes concepts I’ve been learning with...
Top Modern Data Warehouse questions
By James-Serra
Below are the top 15 questions I am seeing from customers looking to build...
Importance of Testing
I’ve always said if you’re running a script for the first time in a...
Forums
empty table is large
I have a table used for staging during ETL. It is empty most of...
XP_CMDSHELL Error
Hello, I have set up and configured xp_cmdshell using a proxy account and I...
Ask SSC