can not access master stored proc

• shobha.aradhya

  SSC Veteran

  Points: 256

  More actions

  December 24, 2012 at 2:00 am

  #267939

  Hi,

  I have the below code

  declare @ret int

  DECLARE @XMLFile varchar(255)

  SET @XMLFile = 'C:\myfile.xml'

  exec @ret = master..xp_FileExists @XMLFile

  When I execute this its throwing error

  Could not find stored procedure 'master..xp_FileExists'.

  When I checked master database the stored proc xp_FileExists is existing.

  Any Idea where am I going wrong?

  Thanks in advance,

  Aradhya

• SQL Dev-938873

  Ten Centuries

  Points: 1280

  More actions

  February 4, 2013 at 3:52 am

  #1583875

  shobha.aradhya (12/24/2012)

  ---

  Hi,

  I have the below code

  declare @ret int

  DECLARE @XMLFile varchar(255)

  SET @XMLFile = 'C:\myfile.xml'

  exec @ret = master..xp_FileExists @XMLFile

  When I execute this its throwing error

  Could not find stored procedure 'master..xp_FileExists'.

  When I checked master database the stored proc xp_FileExists is existing.

  Any Idea where am I going wrong?

  Thanks in advance,

  Aradhya

  Hi,

  That extended store proc is not exists..

  Use the below code...

  declare @ret int

  DECLARE @XMLFile varchar(255)

  SET @XMLFile = 'C:\myfile.xml'

  exec @ret = master.sys.xp_FileExist @XMLFile

  GaNeSH