推荐: SQL Server Management Express Edition插件

如果使用SQL Server2005的Express版本时，不可避免需要使用SQL Server Management  Express Edition。而2005版本之前的管理器中书写SQL、查找字符、格式化SQL等都觉得不好使。这两天网上看到了两个工具，可以加强SQL Server Management  Express Edition的功能。
1 Red Gate的SQL Prompt。可以看一下blog
www.cnblogs.com/jintan/archive/2008/06/15/1220365.html
2 ssmstoolspack
http://www.ssmstoolspack.com/
It contains a few upgrades to the IDE that I thought were missing from the Management Studio:

• Uppercase/Lowercase keywords.
• Run one script on multiple databases.
• Copy execution plan bitmaps to clipboard.
• Search Results in Grid Mode and Execution Plans.
• Generate Insert statements for a single table, the whole database or current resultsets in grids.
• Query Execution History (Soft Source Control).
• Text document Regions and Debug sections.
• Running custom scripts from Object explorer's Context menu.
• CRUD (Create, Read, Update, Delete) stored procedure generation.
• New query template.

在Vista安装时可能出现：外接程序“SQL Server Management Studio Express Tools Pack”未能加载或导致了异常。错误号: 80040154。
解决：使用setup.exe安装，所有用户环境下使用。