It's all personal preference. I like to use usp_.

-Mike

>Is there a naming convention for local stored procedures? I think the system stored procedures beging with sp_, and if I remember correctly, MS strongly advises against using that in the BOL. That makes sense, but is there a standard for local sprocs?