It's confusing becaue system SPs start with SP. I would recomend to use something else, usp_ for example.

>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)
>
>I currently use the following naming convention for my SPs: sp_als_[tablename]_[U|I|UI|S|D]
>
>I came accross a website that recomended not starting my custom SPs with sp_ (and it referenced BOL, but I couldn't find it in BOL). The website stated that if the SP name started with sp_ the server would always look through the built in SPs before looking through DBO SPs. I guess this could be prevented by always calling the SP using the full name i.e. dbo.sp_als_TblName_S
>
>Einar