I think it is a decent article at least for newbies. I had no naming convention and haven't had time to develop one as i work on this project. Having SOME IDEAS verses NONE is better than none at all.  And this has been a worry on my part but i had no where to begin.

This discussion has also cleared up some things that are found in the books i've read taht do suggest using another prefix other than sp_.

Since i'm programming i do feel i need to be able to tell the difference between an SP in code an other variables or constants. Knowing for sure it is an SP can be valuable.

I will give more thought to my naming convention now even if i haven't decided how to implement it.