March 9, 2011 at 8:03 am
ok, will give it a try.
The main problem I had was delete, and that one worked like a charm.
(atleast the result was perfect)
March 10, 2011 at 10:39 am
I know of a company that ceased to exist because they lost information due to mis-coded triggers like you have. It is a scarily common problem with trigger code!! I just came across another client recently that has a very significant part of their application logic in triggers that are variable driven. They ported the app from Oracle and were about to roll out the system when they brought me in for a review. They would have also ceased to exist had they switched to the new system. Of course they are now looking at several hundred manhours of refactoring and testing to fix the app . . . but that is better than the alternative!
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply