<div>
If you have xp_cmdshell enabled (most likely not), you can use <br />
<br />
exec xp_cmdshell 'del C:\path\to\filename.ext'<br />
<br />
If not you can try COM and Scripting.FileSystemObject<wbr /><br />
<br />
<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><br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Hi, <br />
<br />
I am using sql server and with bcp i created a file how can i delete that file from sql server with script <br />
please help <br />
<br />
Thanks, <br />
<br />
R8VI<br />

</div>
</div>


Hi, 

I am using sql server and with bcp i created a file how can i delete that file from sql server with script 
please help 

Thanks, 

R8VI


If you have xp_cmdshell enabled (most likely not), you can use 

exec xp_cmdshell &#39;del C:\path\to\filename.ext&#39;

If not you can try COM and Scripting.FileSystemObject

http://www.kodyaz.com/articles/delete-file-from-sql-server-xp-cmdshell-ole-automation-procedures.aspx



sql server delete file with script

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.