can not access master stored proc

  • shobha.aradhya

    SSC Enthusiast

    Points: 176

    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

    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

Viewing 2 posts - 1 through 2 (of 2 total)

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