DBA Must Haves (IMHO)
First, a little about myself. I have been working with databases since SQL Server 6, and a little back when it was Sybase. Here are two procs I use so much, I have to link them here.
First, there's Narayana Vyas Kondreddi's sp_generete_inserts. It's a great utility/sproc for extracting data from existing tables. I have used it from everything from migrating data to making impromptu backups to text files, all the way to bailing out some hapless developers who run against production and wipe out data they should not be touching. Here's where you can get it:
http://vyaskn.tripod.com/code/generate_inserts.txt
Next, there's sp_findsp. Not the prettiest thing, but if I want to find out where a string (such as a table or proc) is used, I can run this baby and it will return to me a list where I can start looking. It's also very useful to me when I start a new project to do some “mining“ to see what's going on. Here's where this one can be found:
http://databasejournal.com/features/mssql/article.php/1458871
These two follow me everywhere I go!