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

Content with tag SQLCMD Rss

   Items 1 to 15 of 15   
 

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 | 5,966 reads

SQLCMD

By Steve Jones 2013/11/05 | Category: sqlcmd
Rating: (not yet rated) |  Discuss |   Briefcase | 2,013 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,554 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: SQLServerCentral.com | Category: sqlcmd
Rating: |  Discuss |   Briefcase | 7,706 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,069 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,036 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,028 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,546 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,298 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,554 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,265 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,665 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,546 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,120 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,444 reads
   Items 1 to 15 of 15   
 
Tags
backup (1)    
blogs (1)    
c# (1)    
cmd (1)    
database mirroring (1)    
dtc (1)    
duplicates (1)    
management studio (ssms) (1)    
port (1)    
portqry (1)    
powershell (1)    
row_number() (1)    
run as (1)    
scripting (1)    
smo (1)    
sp_addsrvrolemember (1)    
sp_grantlogin (1)    
studio (1)    
system development life cycle (1)    
visual (1)