>>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_ :)
This is very useful. Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham