Trigger should not impact SCOPE_IDENTITY, did the record get inserted into C?
http://databaseandstorage.blogspot.com http://gotodba.weebly.com
Forum Rules