Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Articles with tag SQLCMD Rss

Search for any content tagged sqlcmd

   Items 1 to 11 of 11   

SQLCMD Mode; Run all SQL files in a directory

SQLCMD Mode gives you the ability to access command line executables via SSMS. Using creative approach, you can automate the execution of all files within a specified directory.  Read more...
By Jason Selburg 2015/09/14 | Source: | Category: sqlcmd mode
Rating: |  Discuss |   Briefcase | 5,137 reads

Mail Fails with SQLCMD Error

I had a SQL Server job that kept failing with sqlcmd error and this describes how I resolved it.  Read more...
By Ramya Makam 2015/03/19 | Source: | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 2,703 reads

SQL Server SQLCMD Basics

Sqlcmd makes many SQL Server tasks, such as automating test runs and maintenance tasks, easier and quicker. The sqlcmd command-line utility is valuable to any database developer or DBA as the prime means of executing batches of SQL Statements to SQL servers, and saving results to file. Rob Sheldon gives you the basic facts about this great utility.  Read more...
By Additional Articles 2013/11/08 | Source: SimpleTalk | Category: cmd
Rating:  Rate this |   Briefcase | 6,215 reads

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

Using SQLCMD Mode in SSMS is easy. This short piece will show you how to get started.  Read more...
By Wayne Sheffield 2013/05/06 | Source: | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 7,977 reads

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

Sometimes we need to create backups using code. Sometimes we need to do it manually or automatically, programmatically using C#, VB, Powershell.   Read more...
By Daniel Calbimonte 2012/08/14 | Source: | Category: backup
Rating: |  Discuss |   Briefcase | 6,137 reads

Run SQL Server Scripts using C#

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.  Read more...
By Daniel Calbimonte 2012/04/27 | Source: | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 9,132 reads

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

One thing I have gotten wrong before, or not elaborated on before in presentations on mirroring, although Roman Rehak mentioned...  Read more...
By Hugo Shebbeare 2010/12/16 | Source: | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,552 reads

Duplicate Records using SQLCMD

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.  Read more...
By Renato Buda 2009/04/06 | Source: | Category: duplicates
Rating: |  Discuss |   Briefcase | 9,293 reads

Deploying Scripts with SQLCMD

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.  Read more...
By David Poole 2009/03/24 | Source: | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 11,762 reads

The sqlcmd utility in SQL Server

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.  Read more...
By Additional Articles 2009/01/07 | Source: SearchSQLServer | Category: sqlcmd
Rating:  Rate this |   Briefcase | 5,241 reads

A Little DOS for a Poor DBA

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.  Read more...
By Yakov Shlafman 2008/11/06 | Source: | Category: scripting
Rating: |  Discuss |   Briefcase | 12,452 reads
   Items 1 to 11 of 11