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