Check if xp_cmdshell is turned on and flip the bit
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
353 reads
The code works well for an automation process that needs to have xp_cmdhsell turned on.
2017-02-22 (first published: 2017-02-13)
353 reads
2016-10-24
1,055 reads
How to monitor drive space in T-SQL and calculate when your drives will run out of space.
2016-01-19
8,309 reads
2013-12-06 (first published: 2011-01-31)
4,651 reads
Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.
2010-02-02
10,298 reads
A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.
2009-08-26
8,469 reads
Learn how SQLCLR can be used to replace BCP and xp_cmdshell to export data to comma separated and tab delimited flat files.
2011-05-06 (first published: 2009-03-03)
19,397 reads
A hopefully useful script to delete old files, not just backups, and make use of the archive bit.
2009-01-02 (first published: 2008-12-09)
2,112 reads
With the combination of a few T-SQL commands this tip shows you a simple way to export data to text files.
2008-12-05
9,878 reads
2008-07-23 (first published: 2008-06-05)
1,205 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers