Post reply

when i run exec xp_cmdshell 'del "c:\windows\temp\*.*"', got promt for [Y/N]...

  • November 13, 2008 at 12:37 am

    #897915

    Add the /Q switch to the del command. It puts delete into silent mode so it won't prompt.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • November 13, 2008 at 12:40 am

    #897916

    Yes, i can able to delete , Thanks for ur reply..

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • November 13, 2008 at 10:02 pm

    #898398

    I am able to delete all files but not able to delete subfolders,

    is there any option?

    _____________________________________________________________________________________________________________
    Paresh Prajapati
    ➡ +919924626601
    http://paresh-sqldba.blogspot.com/[/url]
    LinkedIn | Tweet Me | FaceBook | Brijj

  • November 14, 2008 at 5:30 am

    #898493

    Add /S to the command line as well. Just be careful to run it in the intended directory! I once wiped almost my entire harddrive because I inadvertently ran it from C:

    Regards,

    Jan

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply