thanx JM

i solved the problem by changing the user under which the services (SQL Server and SQL Server Agent) are running, and gave that user read access...

thankx jmaurais

both the webserver and database server are internet servers. i think both the machines are independent ones and not under a domain. is there any way to authenticate the...

i tried drive mapping (full control to everyone) on my local network. but that too failed with the same error message.

thanks for the reply

actually the bulk insert statement is part of a stored procedure (called from an asp.net application), which takes both the format filename and delimited filename as input...

both the format file and delimited files are in BISMILLAH

database is on another machine (BISMILLAHSERVER)

bulk directory is shared and full control for everyone

i can access (using windows explorer or start->run)the...

Best solution for these kind of situations is to cache the result of all the queries on that table. Subsequent requests for the same query should be satisfied from the...