Jeff Moden (4/3/2012)
By default, the Throw statement always has the severity of 16.
Microsoft deprecates yet another incredibly useful tool and replaces it with a piece of garbage with much fewer capabilities.
The "advantages" you have for THROW are actually disadvantages for me especially when it comes to THROW having fewer parameters. I really hope this is April Fools joke. I'm totally disgusted with what Microsoft thinks "improvements" actually are.
Recommending it in SQL 2012 means we have it for at least 3 more releases... I don't know about you, but SQL 2020 sounds like a long time from now. 😛 😛 😛
And of course, if there is enough complaining, Microsoft will fix THROW's short comings.