SQL Search

SQL Search - Search for SQL in your databases

SQL Search - quickly find SQL in SSMS

• Find fragments of SQL text within stored procedures, functions, views and more
• Quickly navigate to objects wherever they happen to be on a server
• Find all references to an object

SQL Search is an add-in for SQL Server Management Studio that lets you quickly search for SQL across your databases.

SQL Search will eventually become part of SQL Prompt. When this happens, the free version of SQL Search will continue to work without issue.

Until then, we're making it available as a free standalone tool.

Snippet Manager

Snippet Manager

Snippet Manager is an extremely lightweight (no setup required) freeware utility that you can use for managing your code snippets in a variety of languages. Snippet Manager works with VB, C++, C#, Java, SQL, ASP, PHP, HTML, even COBOL, Assembler and Fortran (37 languages are supported). You can also use Snippet Manager to manage plain old ASCII text data.
Snippet Manager features a powerful search tool that is geared towards developers. You can use regular expressions or simple search criteria to find the exact code you need, when you need it, based on the language, category, dependencies, keywords or the actual code that you are looking for.
Another useful feature is the ability to publish your snippets on the Internet and optionally password protect your code. All you need is an FTP server to host snippets for your company or for anonymous users over the Internet (your choice).

Microsoft Web Platform Installer

The Microsoft Web Platform Installer (Web PI) is a free tool that makes getting the latest components of the Microsoft Web Platform, including Internet Information Services (IIS), SQL Server Express, .NET Framework and Visual Web Developer easy. The Web PI also makes it easy to install and run the most popular free web applications for blogging, content management and more with the built-in Windows Web Application Gallery.

http://www.microsoft.com/web/downloads/platform.aspx