BCP OUT all table data in your Database

Data Recovery is vital. This script will cursor through your database and BCP OUT the table data to a directory specifically for each day of the week (in numbers - where 1 = Sunday and 7 = Saturday) in order to have table recoverability up to 7 days. The first step is to create the […]

2006-05-11 (first published: )

679 reads

Blogs

Event Notifications Example

By

Event notifications are kinda like a trigger in the sense that they respond to...

Did you know we have another SQL Server book coming out?

By

SQL Server 2017 Administration Inside Out was the first technical book I contributed to,...

Batch Scripting SQLCMD–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Read the latest Blogs

Forums

Using sftp in Visual Studio for SSIS packages

By Isabelle2378

Hi, I've inherited the maintenance of SSIS packages that were created by our former...

Merge vs other options

By astrid 69000

Hi, I need to load a table that has 5,000,000 records, I usually use...

Password changes

By Admingod

I would like my SQL users to be able to change their SQL password.Using...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers