SQL SERVER 2005 INSTED OF Trigger
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi. I set an INSTED OF INSERT trigger on a table, that deny the addition of rows in some conditions. My question is: When I run the insert command, I get the (X row(s) affected) message, even if that isn't the real number of added rows. I tried to set the @@ROWCOUNT function, but it turns out this isn't the way. Is there any way to change the affected rows count of a trigger / sp? Thanks, Yaakov