>>Is there a negative side-effect of using the following 3 characters
sp_ in the beginning of my custom SP name? (as long as I am 99.9% sure that the server doesn't have a built-in SP with the same name)
>
>What happens some day in the future in the next version of SQL Server when they make a new stored procedure with the same name as yours? I'd definitely go for something else like usp_Name, spName, etc.
I am 99.9% sure that M$ will not create a system SP with the same name as me :) I understand you point, but I am a little more interested in eventual performance issues resulting from choosing the same naming schema as M$.
I decided to use spALS_Name instead of sp_ALS_Name so I should be good to go. Thanks for the reply.
Einar
Semper ubi sub ubi.