Home Forums SQL Server 7,2000 T-SQL Trigger returns error BUT NOT on Query Analyser RE: Trigger returns error BUT NOT on Query Analyser

  • Ok Steve, this is my code in the table trigger, and it takes the parameters to the dll.  I didn't write the dll it was writen by the vendor, but if there is anyway you can help with more info, I will inform the vendor to correct whatever is wrong

    DECLARE @cmd sysname, @var sysname, @con sysname

    SET @var = (select max(id) from Inserted)

    SET @con = (Select principal from ISLPrimeBrokersEquitiesOutput where id in (Select max(id) from Inserted))

    SET @cmd = 'C:\ClientBroking.exe ' + @var + ' ,'+ 'ISLPrimeBrokersEquitiesOutput'+','+ @con+''

    EXEC master..xp_cmdshell @cmd