I ran into an interesting problem while writing an update trigger in SQL Server 2008. I right-clicked on the triggers folder for a table and selected "New trigger". Now the new trigger template adds "SET NOCOUNT ON;" at the beginning. Normally it is a good practice so that the rows affected message ...
[More]
1892bffa-51ea-4459-a5ab-f58a7aab59ef|0|.0
BlogEngine.NET
sql server triggers