yeah exactly...but i think single quotes doesnt work here again.

yeah i have both files in the same shared folder.

No..its real file not hardcoded.

ANY HELP.............

I shared the folder, but still the same.

is there anything else i can try

The problem here is it is not executing IF statement , directly jumping to ELSE though the return value is 1

yeah THe file exists there.

when I am able to bulk insert out of SP then it says that I have rights to that file.

Every time I execute EXEC Master..xp_fileexist , It is giving the error mesg file not found, either success or failure.

sorry that was my mistake..I edited the table name.

but still am unable to get that error mesg when failed and also executing the bulkinsert command though it didnt meet the...

I tried it, it says file not found but when run bulkinsert out of SP it loads the file

could you pls tell me how to use global variable to select a file dynamically for my load.

I searched the link but still not sure how to proceed.

wowwwww. thanks for pointing out.

thanks a lot.

its not CASE SENSITIVE

one thing to mention, the server where am trying to restore already has that Db but I am trying to resotore DB on diffrent name.

I used the following query

restore filelistonly

from disk = 'E:\DOTbackup6-7-06\dot_db_200606072012.BAK'

restore database TESTdot

from disk = 'E:\DOTbackup6-7-06\dot_db_200606072012.BAK'

with

move 'dotData' to 'E:\Data\testdot.mdf',

move 'dot_ext_data' to 'E:\Data\testdot_ext_data.ndf',

move 'hs_data_ext'...

xp_fileexist, I did nto find this SP.

What am trying to do is ..

End user will be passing a file name to load to a SP where the file name is...

I read the article but didnt find any clue to accomplish my task.

Tha thing is user will be passing a file name to my load process as a parameter so...