• I use SSMS Tools Back by Mladen Prajdic

    http://www.ssmstoolspack.com/

    Way cheaper than redgate, and I get quite a bit out of it. I find the most useful feature is the snippet generator. I can bind tiny character strings to generate large, commonly used template code. For example, creation of temp tables, I bound "TT" + <TAB> to generate

    if object_id('tempdb.dbo.#<TableName, sysname, >') is not null drop table #<TableName, sysname, >

    create table #<TableName, sysname, >

    (

    )

    It also has code formatting features (such as converting keywords to/from upper and lower case) and stores off history of query windows; very nice when you've been writing code for an hour and your computer crashes.

    Executive Junior Cowboy Developer, Esq.[/url]