SQLServerCentral.com Articles tagged SQLCMD

An Introduction to the SQLCMD Mode in SSMS (SQL Spackle)

Mon, 06 May 2013 06:00:00 UT

Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.

11 Tips to Backup databases with SMO, VB, C# Powershell, Command lines

Tue, 14 Aug 2012 06:00:00 UT

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.

Run SQL Server Scripts using C#

Fri, 27 Apr 2012 06:00:00 UT

In this article I will run a SQL Server script to backup a database using C# in visual studio. For this purpose, I am going to use the sqlcmd.

Notes from Mirroring Deep Dive Session with Mohammed Sharaf: Microsoft Premier Engineer (I can never learn enough about Mirroring :)

Thu, 16 Dec 2010 07:00:00 UT

One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...

Duplicate Records using SQLCMD

Mon, 06 Apr 2009 06:00:00 UT

We have an article here from Renato Buda that shows how to delete duplicate records from your tables. SQLCMD is used with variables that make it easy to write a general purpose script for any table.

Deploying Scripts with SQLCMD

Tue, 24 Mar 2009 06:00:00 UT

Deploying changes to your SQL Servers can be a challenge. Longtime SQL Server expert David Poole brings us a new article looking at a solution using SQLCMD.

The sqlcmd utility in SQL Server

Wed, 07 Jan 2009 07:00:00 UT

The sqlcmd utility in SQL Server is a handy tool for running ad hoc queries or creating script files to perform routine tasks or automate procedures.

A Little DOS for a Poor DBA

Thu, 06 Nov 2008 07:00:00 UT

Yakov Shlafman brings back the world of the command prompt to make life easier for a DBA that must deploy a series of scripts to their servers.