Hi All,
I have a problen in my SQL script,
declare @Path varchar(128) ,
@FileName varchar(128)
select @Path = '\\10.1.0.192\' ,
@FileName = 'foldername\126894.pdf'
declare @i int
declare @File varchar(1000)
select @File = @Path + @FileName
print @File
exec master..xp_fileexist @File, @i out
if @i = 1
print 'exists'
else
print 'not exists'
but it says "not exists".
The file exists in different server. I have given full rights for this folder.
But still getting the same. Please help to resolve this.
Thanks in advance,
Selva
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2855
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
