InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 16:52:10 GMT20http://www.sqlservercentral.com/Forums/Topic1399842-454-1.aspx[quote][b]shobha.aradhya (12/24/2012)[/b][hr]Hi, I have the below codedeclare @ret intDECLARE @XMLFile varchar(255)SET @XMLFile = 'C:\myfile.xml'exec @ret = master..xp_FileExists @XMLFileWhen I execute this its throwing errorCould 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[/quote]Hi,That extended store proc is not exists..Use the below code...declare @ret intDECLARE @XMLFile varchar(255)SET @XMLFile = 'C:\myfile.xml'exec @ret = master.sys.xp_FileExist @XMLFileMon, 04 Feb 2013 03:52:58 GMTSQL Dev-938873http://www.sqlservercentral.com/Forums/Topic1399842-454-1.aspxHi, I have the below codedeclare @ret intDECLARE @XMLFile varchar(255)SET @XMLFile = 'C:\myfile.xml'exec @ret = master..xp_FileExists @XMLFileWhen I execute this its throwing errorCould 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,AradhyaMon, 24 Dec 2012 02:00:27 GMTshobha.aradhya