Viewing 3 posts - 1 through 3 (of 3 total)
There are no entries in Windows Event Viewer or SQL Logs associated with the event.
November 8, 2011 at 10:44 am
#1404718
GilaMonster (12/6/2007)That's not a very nice trigger.Frank Lain (12/6/2007)select @key = cashlist_key from INSERTEDWhat happens if more than one row is inserted in a batch?
GilaMonster (12/6/2007)
Frank Lain (12/6/2007)select @key = cashlist_key from INSERTED
Frank Lain (12/6/2007)
select @key = cashlist_key from INSERTED
What happens if more than one row is inserted in a batch?
There will never be...
December 7, 2007 at 8:54 am
#758130
JDixon (12/6/2007)
It is most likely trying to update a the row that was inserted with in the same transaction as the insert. Which will not work. The...
December 7, 2007 at 8:35 am
#758115