What SQL Server version do I have?
Here is a great script to see the version of the SQL server you are working on: This is how it looked on my home server that of cause is running Express Edition:
Searching for a word in all Stored procedures
Every so often I need to find a particular stored procedure, maybe because it uses a table that will be renamed, or I need to find out who’s updating a table that I work with.