Thanks for the reply Craig.
>I don't think one performs any faster than another. But, it is considered Best Practice to not name your Stored Procs as sp_*.
>
>>Performance was exactly what I was worried about. If I understand it correctly it should be slightly faster for the server to execute a SP named usp_X compared to a SP named sp_X since the server doesn't first have to check if it is a system SP. (now slightly faster might only be a fraction of a fraction of a ms faster but still).
>>Do you think I will gain performance (in the same way) if I name my SPs spals_X (notice it starts with sp but it doesn't start with sp_)?
>>
>>Just trying to squeeze out some performance :)
>>
>>Einar
>>
Semper ubi sub ubi.