SQLServerCentral.com Articles tagged xp_cmdshell

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

Fri, 06 May 2011 06:00:00 UT

Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.

Easy Error Trapping When Using xp_cmdshell

Tue, 02 Feb 2010 07:00:00 UT

Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.

Moving Databases with the ALTER Command

Wed, 26 Aug 2009 06:00:00 UT

A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.

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

Fri, 06 May 2011 06:00:00 UT

Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.

Simple way to export SQL Server data to Text Files

Fri, 05 Dec 2008 07:00:00 UT

With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.