December 24, 2012 at 2:00 am
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
February 4, 2013 at 3:52 am
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 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy