<div>
<a href="http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx" rel="ugc">http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx</a>
</div>


http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx [http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx]

<div>
following command will delte x.txt from c:\<br />
exec xp_cmdshell &quot;del c:\x.txt&quot;;<br />

</div>


following command will delte x.txt from c:\
exec xp_cmdshell "del c:\x.txt";


<div>
Note that you will have to get xp_cmdshell enabled through services configuration.
</div>


Note that you will have to get xp_cmdshell enabled through services configuration.

<div>
<div class="content wysiwyg-content">
we will send folder path as a parameter, need to delete all the files in the specific folder<br />
NOTE : not the folder<br />
<br />
here is my code below. thanks in advance for spending your precious time in it.<br />
<br />
EXEC @HR = SP_OACREATE 'SCRIPTING.FILESYSTEMOBJEC<wbr />T',@OLE_FI<wbr />LESYSTEM OUT<br />
EXEC @HR = SP_OAMETHOD @OLE_FILESYSTEM, 'DELETEFILE',NULL, @FILE_PATH<br />
EXEC @HR = SP_OADESTROY @OLE_FILESYSTEM<br />
<br />
Line 2 returns -2147352570<br />
thanks<br />
amal
</div>
</div>


we will send folder path as a parameter, need to delete all the files in the specific folder
NOTE : not the folder

here is my code below. thanks in advance for spending your precious time in it.

EXEC @HR = SP_OACREATE 'SCRIPTING.FILESYSTEMOBJECT',@OLE_FILESYSTEM OUT
EXEC @HR = SP_OAMETHOD @OLE_FILESYSTEM, 'DELETEFILE',NULL, @FILE_PATH
EXEC @HR = SP_OADESTROY @OLE_FILESYSTEM

Line 2 returns -2147352570
thanks
amal

how to delete physical files in a folder through sql server 2005 (procedure)

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

Microsoft server applications are those applications developed specifically, but not necessarily exclusively, on the Windows Server platform. In addition to well-known products like SQL Server, Exchange, Internet Information Services (IIS), Microsoft Dynamics, Forefront, Lync and Sharepoint, they include applications like Skype, BizTalk, Hyper-V, Groove and Commerce Server. Server applications are managed with the Microsoft System Center.