>I am sure this question has been asked a million times. And yet I am asking it again. I see everywhere online stored procedures named with prefix sp (e.g. sp_custom_account). Is there a technical or a logical reason for that? Since stored procedures are in SQL DB Programmability -> Stored Procedures, why need to tag them as SP still?
As my father used to say to me...."Son, you could do it, but it would be wrong" :)
Craig gave a sufficient response. In addition, when you execute something with an sp_ prefix, SQL Server will start looking through system stored procs in the master database. So there's a slight performance hit.
Bottom line, don't use sp_ :)