Einar,

I think the not using SP_ admonition is one primarily of performance. Which is probably going to be important in your system if you have 5 SPs per table. We use usp_X here.

>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