>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.
It's certainly not a big one, but there is a sequence of events that SQL Server will go through involving the master database....and definitely avoidable