Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

can not access master stored proc Expand / Collapse
Author
Message
Posted Monday, December 24, 2012 2:00 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Today @ 2:12 AM
Points: 12, Visits: 58
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

Post #1399842
Posted Monday, February 4, 2013 3:52 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 3:56 AM
Points: 90, Visits: 421
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
Post #1415212
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse