Technical Article

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: )

682 reads


Microsoft industry clouds


In talking with Microsoft customers, I have found that most are not aware that...

Two Clustered Indexes?


Everyone knows that you only get a single clustered index, right? Wouldn’t it be...

Daily Coping 18 Jan 2022


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs


Setting a variable from a multi-table Select

By JaybeeSQL

Hi all, I have a variable to declare, and this works: Declare @CopyFromUser Varchar(10)...

Deploying Dacpacs?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deploying Dacpacs?

How to practice OOP in C++ effectively?

By TembaBavuma

I am currently writing a desktop application with Qt and C++. While I have...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers