I experienced a similar problem a few times: some lines in a Stored Procedure didn't work. I dropped those lines and wrote it anew from scratch (in Enterprise Manager), and it...

The if update() checks only if a column is updated and does not check whether data really changed.

To check for data changes I use statements like this:

Declare @bIsUpd_OrderID bit

IF Exists (Select *...