I habe the same problem with this bcp hang up.

My Stored Procedure contains a bcp command, that create a file with data. I can execute this Stored Procedure without problems manually in SQL Server Management Studio Query Analyzer.

But from a insert-Trigger, that contains this Stored Procedure, the bcp.exe hang up, shown in Task Manager.

Why is it so? What is the reason the bcp.exe hang up?

Many Thanks

Thom