Execute a batch file from a trigger or a SP?

Hello,

I am trying to execute a batch file (containing a rundll32 command line) using a trigger or a stored procedure.
Here is a trigger with which I retreive a variable (@nDocID) that I want to use in my SP (sp_batch).

Declare @nDocID Integer
Declare @doctypeID Integer
Select @nDocID = doc_id
From Updated
IF @doctypeID <> @nDocID
Begin
 exec sp_batch @nDocID
End

and my sp looks like this:
rundll32 c:\app\file.dll,Function

In SQL we can use EXEC master..xp_cmdshell sp_batch @nDocID Would there be an equivalent?

I hope someone will be able to bring light to my darkness

thanks Received on Mon Apr 26 2004 - 03:13:55 CDT