Help Calling Stored Procedure From Trigger

I am trying to execute a stored procedure from a trigger. Every time the trigger executes it locks up the table with the trigger (other tables are fine). I cannot select or insert or do anything to the table until I stop and restart the database. The trigger is being triggered as desired.

Strangely, the stored procedure works when executed from Query Analyzer. But when the stored procedure is called from the trigger I have problems.

All trigger examples I have seen have GO at the end. But when I try to use the GO I get "Error 170: Incorrect Syntax near 'GO'", so I have it commented out.

The stored procedure calls a query on the table that was just modified; I think that may be the problem and don’t know how to resolve it. The trigger passes 2 variables; a table name and field name. If someone can provide any help I would appreciate it.

-------------------------------------------------

CREATE TRIGGER TR_CPUMFR
ON [dbo].[CPUmfr]
AFTER INSERT, UPDATE, DELETE
AS

EXEC sp_createPulldownWriteFile 'cpumfr' , 'cpumfr'

--GO



-------------------------------------------------

CREATE PROCEDURE [dbo].[SP_CreatePulldownWriteFile]
(
@F as varchar(255), --Field
@T as varchar(255) --Table
)
AS

DECLARE @FileName varchar(50),
@bcpCommand varchar(2000)

Set @FileName = '"\\Tech-web\c$\' + @T + '.htm"'
SET @bcpCommand = 'bcp "EXEC InventoryManager.dbo.SP_CreatePulldown ' + "'" + @F + "' , '" + @T + "'" + '"' +" queryout "
SET @bcpCommand = @bcpCommand + @FileName + ' -T -c'

EXEC master..xp_cmdshell @bcpCommand
GO