I had a client GO OUT OF BUSINESS because all of their triggers were built with the variable problem. And I TOLD them it was going to happen before it did and they didn't listen. 🙁
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service