Erik Darling, of Erik Darling Data (blog | Twitter) recently posted a very interesting video (my YouTube playlist is all Erik Darling Data videos and Honest Trailers). In this video he demonstrates an easily repeatable issue about naming weirdness and the
CREATE OR ALTER PROCEDUREsyntax, with stored procedures starting with
sp_. The video is 141 seconds long, so go watch it. I’ll wait.
Cool. As many of my readers know — because you’re intelligent and attractive in equal measure — Microsoft does not want us using
sp_for stored procedure prefixes for general use, because it’s kind of reserved:
Read on for some fun with system-like objects.