Thanks for the insights, John. I do realize now why that's a bad idea.

Intention behind my question was to learn why it's a bad idea. SQL Server is not my expertise yet. I am an amateur SQL developer. I have begun learning things...

Is there a compelling reason as to why we should not be writing procedures with "sp_" prefix?

Hi Cheryl Hanlon,

It's quite terrific point that you have pointed out. It literally saved me from a disaster today. I was facing the same issue and by replacing parameters with...