I say exactly what I said earlier.

As it stands, it's not going to prevent anything. It just notes that updates aren't permitted and then finishes, thus completing the update.

In SQL Server, triggers fire whether there's been a single change or multiple changes. There are no row triggers (that's Oracle iirc)