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

Content with tag xp_cmdshell Rss

   Items 1 to 9 of 9   
 

Disk Capacities

Provides information on the total and used space for all drives on an instance.  Read more...
By Nicholas Williams 2013/12/06 | Source: SQLServerCentral.com | Category: disk
Rating: |  Discuss |   Briefcase | 4,473 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,802 reads

Disk Capacities

Provides information on the total and used space for all drives on an instance.  Read more...
By Nicholas Williams 2013/12/06 | Source: SQLServerCentral.com | Category: disk
Rating: |  Discuss |   Briefcase | 4,473 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,207 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,356 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,802 reads

Deleting old files (with/without archive bit)

A hopefully useful script to delete old files, not just backups, and make use of the archive bit.  Read more...
By Gaby Abed 2009/01/01 | Source: SQLServerCentral.com | Category: archive
Rating: |  Discuss |   Briefcase | 1,825 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,811 reads

Find Large Files on OS - Results of DIR to Table

Put results of DIR command into a table.  Read more...
By Congruent Influence 2008/07/23 | Source: SQLServerCentral.com | Category: directory
Rating: |  Discuss |   Briefcase | 1,161 reads
   Items 1 to 9 of 9   
 
Tags
bcp (2)    
alter database modify file (1)    
archive (1)    
attach (1)    
backup / restore (1)    
capacity (1)    
delete (1)    
detach (1)    
directory (1)    
disk (1)    
drive (1)    
error handling (1)    
export (1)    
extract, transform, load (etl) (1)    
file size (1)    
free space (1)    
maintenance (1)    
maintenance and management (1)    
percentage (1)    
show advanced options (1)    
size (1)    
sql server 2005 (1)    
sqlclr (1)    
volume (1)