>>Not directly related, but generally using sp_ as a prefix on your stored procedures is discouraged. SQL Server uses that for it's own stored procs and will search its list of SP if it sees "sp_" first. If it can't find it, it will then look in the user defined listed of stored procs. That means you'll pay a performance hit on every call (since it has to check to see if it's an internal SP first).
>
>Paul,
>
>Good point. I was also thinking about it. What is the recommended prefix for users' SP?
>
>Thanks in advance.

Yeah, I've seen usp_ and sp. I don't use any prefix on mine. I generally use the system/component name as a prefix so the stored procs for a specific component are grouped together.

Like most code "standards" there are 5000 variations on all of this.