How to check a PAth existing uysing T SQL

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  April 29, 2015 at 2:34 pm

  #317187

  HI,

  whenever I use the below script, it throws the below error. Any suggestion, what's going on wrong?

  declare @DbFilePath VARCHAR(max)

  set @DbFilePath = ' c:\mdndnd\mmnsn\'

  if object_id('tempdb.dbo.#fileExist') is not null

  drop table #fileExist

  create table #fileExist (

  fileExists int,

  fileIsDir int,

  parentDirExists int

  )

  insert into #fileExist

  exec xp_fileexist @DbFilePath

  declare @directory_check INT

  select @directory_check = [parentDirExists]

  from #fileExist

  IF @directory_check = 1

  BEGIN

  END

  Msg 0, Level 11, State 0, Line 0

  A severe error occurred on the current command. The results, if any, should be discarded.

  Thanks.

• g.britton

  SSChampion

  Points: 13863

  More actions

  April 29, 2015 at 2:43 pm

  #1794496

  This works:

  declare @sql nvarchar(4000)

  set @sql= 'exec xp_fileexist ''' + @DbFilePath + ''''

  insert into #fileExist

  exec sp_executesql @sql

  Gerald Britton, Pluralsight courses

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  April 29, 2015 at 4:16 pm

  #1794532

  HI Britton,

  It works.,

  Thanks.