Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

deleting a file with SQL xp_cmdshell

Posted on 2014-09-24
3
Medium Priority
?
176 Views
Last Modified: 2014-09-24
Hello experts,

I am running this one line code on SQL Management Console and it gets hung at 'Executing Query':

exec master..xp_cmdshell 'C:\Test1\Test2\test3.txt'

What is the issue? I login to the SQL Server as the local administrator of that (same) server. Is there something I am missing? Should the folder be shared instead and I use the share name?

Thank you in advance
0
Comment
Question by:bozer
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 40340987
>exec master..xp_cmdshell 'C:\Test1\Test2\test3.txt'
this would only "open" the file (on the server, in the sql server login session, so unvisible except in the task manager)

to DELETE the file:


exec master..xp_cmdshell 'del C:\Test1\Test2\test3.txt'
0
 

Author Comment

by:bozer
ID: 40340990
I've requested that this question be deleted for the following reason:

Typo
0
 

Author Closing Comment

by:bozer
ID: 40340991
I just realized that after posting but you were even faster to reply Guy, thanks :)
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …

963 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question