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
Semper ubi sub ubi.