<div>
I assumed it was running as the Administrator account, but I don't know, how do you find out?
</div>


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I am trying to delete a set of files from a file share using an overnight stored procedure in SQL 2000. &nbsp;I can delete the files manually from the server using Windows Explorer and the command prompt, but I'm getting 'Access Denied' from the Query Analyser. &nbsp;Any ideas?<br />
<br />
DECLARE @KillString varchar(255)<br />
SET @KillString = 'DEL &quot;F:\Shared Documents\Attachments\1.ic<wbr />o&quot;'<br />
EXEC Master..xp_cmdShell @KillString<br />

</div>
</div>


Hello Experts,

I am trying to delete a set of files from a file share using an overnight stored procedure in SQL 2000.  I can delete the files manually from the server using Windows Explorer and the command prompt, but I'm getting 'Access Denied' from the Query Analyser.  Any ideas?

DECLARE @KillString varchar(255)
SET @KillString = 'DEL "F:\Shared Documents\Attachments\1.ico"'
EXEC Master..xp_cmdShell @KillString


I assumed it was running as the Administrator account, but I don&#39;t know, how do you find out?

Deleting files from a server file share using an overnight stored procedure

Hello Experts,

I am trying to delete a set of files from a file share using an overnight stored procedure in SQL 2000.  I can delete the files manually from the server using Windows Explorer and the command prompt, but I&#39;m getting &#39;Access Denied&#39; from the Query Analyser.  Any ideas?

DECLARE @KillString varchar(255)
SET @KillString = &#39;DEL &quot;F:\Shared Documents\Attachments\1.ico&quot;&#39;
EXEC Master..xp_cmdShell @KillString


Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

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.