I'd never heard about the perf hit. Good info. Thanks.
>Craig gave a sufficient response. In addition, when you execute something with an sp_ prefix, SQL Server will start looking through system stored procs in the master database. So there's a slight performance hit.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer