XP_CMDSHELL

• vijay.singh 97987

  SSC-Addicted

  Points: 495

  More actions

  December 14, 2010 at 12:45 am

  #100336

  Hi All,

  Please help me in this.

  I am trying to read file names in my local drive using XP_CMDSHELL.

  Below is the query i am using to read the file name.

  SELECT @ServerName = 'MyServer'

  SELECT @SourceFolder = 'L:\SQL2008_Backup\Full Backup

  SELECT @Cmd = 'master..xp_cmdshell ''DIR ' + @SourceFolder + ' /B'''

  By executing this i m getting the below error.

  -----------------

  File Not Found

  -----------------

  I feels its because of space in the folder name [Full Backup].

  please provide me the solution to reslove this issue.

  Thanks in advance.

  Regards,

  Vijay

• vijay.singh 97987

  SSC-Addicted

  Points: 495

  More actions

  December 14, 2010 at 1:06 am

  #1262065

  Got it..

  Below query works.:-)

  SELECT @SourceFolder = '"L:\SQL2008_Backup\Full Backup"'

• Jules Bonnot

  SSCertifiable

  Points: 5488

  More actions

  April 26, 2011 at 3:32 pm

  #1316269

  using CLR procedure, much more secure,robust free and extensible solution here

  http://sql-library.com/?p=186

  www.sql-library.com[/url]