|
|
|
Grasshopper
      
Group: General Forum Members
Last Login: Tuesday, May 21, 2013 2:18 AM
Points: 11,
Visits: 33
|
|
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
|
|
|
|
|
SSC Journeyman
      
Group: General Forum Members
Last Login: Tuesday, March 26, 2013 7:03 AM
Points: 90,
Visits: 417
|
|
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
|
|
|
|