Hi,
I have used bulk insert in stored procedure to load data from csv file to temporary tables.
Now, i have nested procedures (one calls another...). When the bulk insert part is executed sql server hangs. Process can not be executed further more. I am logged in with "sa" user.
so what can be the possible reasons for this?

Thanks in advance.
Please reply.

Are you seeing any errors during then? What is the volume of data you are trying to load? Can you try executing that part separately and see if works.

_________________________
- Vijay G
Strive for Perfection

Hi,

Thanks for your reply.
Now it works perfectly.

Can we all here know what was missing and how it was fixed?

_________________________
- Vijay G
Strive for Perfection

Actually we feel problem is in bulk insert code. But with debugging we came to know that we have used xp_cmdshell extended stored procedure to execute os commands.
We are using file shredder tool to permanently delete files using xp_cmdshell command. Now this command works perfectly at our end.
but it hangs up client's pc when that command is executed.
Still we are not able to solve this issue. If anybody can help please reply.

can you post the code that is in suspect, so as to help better?

_________________________
- Vijay G
Strive for Perfection