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
573 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
438 reads
Blogs
Behavior of numeric data types with ”
As we all know, there are various numeric data types, such as TINYINT, INT,...
Daily Coping 5 Mar 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Microsoft Ignite Announcements 2021
By James-Serra
Microsoft Ignite has always announced many new products and new product features, and this year...
Forums
Golden Goose Outlet too
Black women are constantly being policed in this way: from what we wear and...
shared datasets and cache refresh option
hi guys! Problem: 1) Every time I overwrite an existing shared dataset (with a...
Question on report server database
Hi, We just installed SQL Server 2019 on a new server and moved...
Ask SSC