Results presented in either a grid or a free-form text window, or in XML form. Templates to speed development of the T-SQL.Įditing of execute and parse queries with SQLCMD extensions. Parameter tipping for system stored procedures and user-defined functions.Ĭolor-coding of Transact-SQL and MDX syntax. From MSDN I found following list which is quite complete and concise. There are many standard features also brought over from previous tools. SQL Server 2005 Query Editor has many other enhancements over previous versions. I realize that my answer is not complete. One of my reader asked recently is it really true SSMS = QE + EM. I have been pointing my users to my previous post so far. SQL SERVER 2005 has combined Query Analyzer and Enterprise Manager into one Microsoft SQL SERVER Management Studio (MSSMS). Where is Query Editor in SQL Server 2005? Recently I have been receiving similar question. Earlier this year, I have received one question many times – Where is Query Analyzer in SQL Server 2005? I wrote small post about it and pointed many users to that post – SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio. This post may be very simple for most of the users of SQL Server 2005.

Ms sql management studio 2008 download