It is fairly common knowledge that you should have
SET NOCOUNT ON
by default when creating new stored procedures.
Microsoft has changed the default template to include this in 2012. I thought this should be the same for triggers, yet it is not included in the template.
Is this intentional or just an oversight?