Hi,

Anyone has made somthing like this, on a INSERT trigger:

IF UPDATE(myfield)
BEGIN
EXECUTE myStoredProc 1, (SELECT mySecondField FROM INSERTED)
END


SQL Server return error at the "(".

Any ideas?

Thanks,

Ricardo