Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag SQLCMD Rss

   Items 1 to 20 of 20   
 

SQLCMD and Batch File magic

Execute scripts in a folder with a single click using SQLCMD and a batch file.  Read more...
By Manu Mohanan 2015/11/19 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 6,628 reads

SQLCMD connection switching

By Paul Kelly 2015/10/27 | Category: sqlcmd
Rating: (not yet rated) |  Discuss |   Briefcase | 1,271 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 2015/10/16 (first published: 2013/05/06) | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 13,543 reads

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: SQLServerCentral.com | Category: sqlcmd mode
Rating: |  Discuss |   Briefcase | 5,838 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: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 2,762 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,434 reads

SQLCMD

By Steve Jones 2013/11/05 | Category: sqlcmd
Rating: (not yet rated) |  Discuss |   Briefcase | 2,070 reads

Using Run As to Make Your Life Simple

Using 'Run As' when working against different domains.  Read more...
By Gaby Abed 2013/06/06 | Source: SQLServerCentral.com | Category: run as
Rating: |  Discuss |   Briefcase | 2,576 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 2015/10/16 (first published: 2013/05/06) | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 13,543 reads

Port check for SQL Server connectivity

Generates a script to check connectivity between a list of SQL Server instances on a specified port.  Read more...
By Michael Lascuola 2012/10/17 | Source: SQLServerCentral.com | Category: port
Rating: |  Discuss |   Briefcase | 1,174 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: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 6,171 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: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 9,148 reads

Export Data in Text File Using SQLCMD in SQL SERVER 2005

This script export the data in text file using sqlcmd command.  Read more...
By Manish Mathur 2011/04/22 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 4,700 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: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,705 reads

Using Run As to Make Your Life Simple

Using 'Run As' when working against different domains.  Read more...
By Gaby Abed 2013/06/06 | Source: SQLServerCentral.com | Category: run as
Rating: |  Discuss |   Briefcase | 2,576 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: SQLServerCentral.com | Category: duplicates
Rating: |  Discuss |   Briefcase | 9,307 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: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 11,796 reads

Export Data in Text File Using SQLCMD in SQL SERVER 2005

This script export the data in text file using sqlcmd command.  Read more...
By Manish Mathur 2011/04/22 | Source: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 4,700 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,394 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: SQLServerCentral.com | Category: scripting
Rating: |  Discuss |   Briefcase | 12,454 reads
   Items 1 to 20 of 20   
 
Tags
:connect (1)    
backup (1)    
blogs (1)    
c# (1)    
cmd (1)    
command line (1)    
database mirroring (1)    
dos integration (1)    
dtc (1)    
duplicates (1)    
management studio (ssms) (1)    
port (1)    
portqry (1)    
powershell (1)    
row_number() (1)    
run as (1)    
scripting (1)    
scripts (1)    
smo (1)    
sp_addsrvrolemember (1)    
sp_grantlogin (1)    
sqlcmd mode (1)    
ssms (1)    
studio (1)    
system development life cycle (1)    
visual (1)