I was reading one poor DBA's postings on another site and I think she had a complete melt-down.

Caution re-naming stored procedures avoid sp_ (I know the book didn't do this but it ALMOST did ;) ) sp_ causes SQL server to execute the proc differently and it runs a bit more slowly unless it is one of the built in procs.

I tried to get programmers to use just sp at one work place but that kept becoming sp_ so I gave up and used pr for all procedures.

Just a thought.

Sandy Murdock MCP

__________________
Sandy Murdock MCP

This is why I make a point to use sp rather than sp_. The industry lacks a solid best practice for SP names. In the past, I've typically used Get_, Ins_, Upd_ & Del_.

Paul Turley, MCSD, MCDBA, MCT, MSF Practitioner

Paul: Where can I get a list of the Errdata and the fix of this book? Thanks.