Can you guys recommend some good SQL tools?

[Cole]

I need some tools for creating DB documents as well as scripting and DB comparisons.

Thanks!

[ncushing]

In general, the tools I'm most familiar with are the Apex SQL tools, which you can find at: Apex SQL Tools - SQL Tools for Auditing, Comparison, Recovery and more

Red Gate software makes a similar set of tools that is highly regarded, though I haven't used the personally. SQL Server tools, .NET developer tools - Red Gate Software

[SQLGuru]

I'd second the vote for Apex. Their applications have some simple features (e.g. Intellisense) that Microsoft couldn't manage to put in their tools. Only down side is that their tools tend to eat up a lot of memory.

[SSLMatrix]

Do you guys think Learnvisualstudio with the videos is a good way to learn SQL Server 2005?