Who Still Uses SP_ for Naming?
Voice of the DBA
English - December 13, 2023 00:00 - 2 minutes - 3.33 MB - ★★★★★ - 8 ratingsTechnology News Tech News databases sqlserver Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
An interesting post recently from Chad Callihan on the reasons why someone shouldn't use sp_ to prefix their stored procedures. This is advice that I've seen for years, but I haven't run into this lately with many customers. It seems I do see some usp_, but not sp_. I think that's good, and if you're not sure why, read Chad's post.
I think my main reason for not doing this is that I sometimes create procs in master. Not because it's a good idea (it isn't) or I want to, but because I'll make mistakes. I'll accidentally connect to master and deploy a script, because I'm not paying enough attention. Usually, I'll catch this right away, but if not, soon after I've told a client things are working, they'll let me know they aren't. Then I connect to the right database.
Read the rest of Who Still Uses SP_ for Naming?