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

Articles with tag xp_cmdshell Rss

Search for any content tagged xp_cmdshell

   Items 1 to 5 of 5   
 

Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files

Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.  Read more...
By Jonathan Kehayias 2011/05/06 (first published: 2009/03/03) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 16,826 reads

Easy Error Trapping When Using xp_cmdshell

Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.  Read more...
By Sylvia Moestl Vasilik 2010/02/02 | Source: SQLServerCentral.com | Category: error handling
Rating: |  Discuss |   Briefcase | 7,224 reads

Moving Databases with the ALTER Command

A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.  Read more...
Rating: |  Discuss |   Briefcase | 8,357 reads

Trading in xp_cmdshell for SQLCLR (Part 2) - Export Data to Flat Files

Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.  Read more...
By Jonathan Kehayias 2011/05/06 (first published: 2009/03/03) | Source: SQLServerCentral.com | Category: sqlclr
Rating: |  Discuss |   Briefcase | 16,826 reads

Simple way to export SQL Server data to Text Files

With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.  Read more...
By Additional Articles 2008/12/05 | Source: MSSQLTips.com | Category: export
Rating:  Rate this |   Briefcase | 8,827 reads
   Items 1 to 5 of 5