Hugo Kornelis (8/9/2012)
Ken Hiatt (8/8/2012)
Still not believing it was that simple, I clicked Execute and got an error message stating that it couldn't find the stored procedure ISNULL. WTF There is a catch, but what is it!
My guess: you had just the ISNULL part of the command selected
That was it. Any other partial selection generates a Syntax error, but just ISNULL selected gives
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'isnull'.
Something I'll be more careful of in the future.