Lowell (1/28/2014)
crazy_new (1/28/2014)
The stored procedure works, because if I execute it outside the trigger, it works.Maybe my syntax is wrong for the trigger or something
apparently, the stored procedure finds the data it's supposed to touch all by itself, since it has no parameters.
most likely, whatever code is inside that procedure should exist inside the trigger INSTEAD, and it should reference the INSERTED and DELETED virtual tables inside the trigger, as Gail suggested.
unless you post the actual code for your proc, we cannot help you.
+1
apparently, the stored procedure finds the data it's supposed to touch all by itself, since it has no parameters.
that is an interesting reaction related to new data.
You inserted a record, do something.
Insert a Date Time Stamp in the other table?