Missing tools in SSMS 2005

I am using SSMS since a few weeks, and I found it is missing a few
tools/utilities from the old Query Analyzer. One of the things which hit
me is the lack of the Debug (I know I can do it in VS 2005, but I can't
understand why I can't debug in SMSS), another is the lack of support
for Sql Server 2000 diagrams, and then there are annoying things as
forcing us to use a different shortcut to bookmark and so on.
The worst of all, anyway, is that we still can't apply a customized
format to the sql documents. In the development team I am working in
we're using a formatting code convention quite different from that
recommended by the Books Online, so every time I use the Query Designer,
I have then manually to 'beautify' the resulting T-SQL code. Even in VS
2005 there seems not to be a way to format all of a SQL document, as it
is possible to do with c# i.e..
Get me right, so far my experience with SMSS has been positive, only
these and other little defaillances are marking the difference between
an useful tool and a tool to recommend.
ale
http://www.riolo.org
Hi
Check out the SQL Server Magazine article on debugging:
http://www.windowsitpro.com/Article/...754/47754.html
For diagrams look in Books online on how to set them up and add one
http://msdn2.microsoft.com/en-us/library/ms189279.aspx
John
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Go to the Product Feedback Center and put in a request to add the features
that are missing
Mike
Mentor
Solid Quality Learning
http://www.solidqualitylearning.com
"Alessandro Riolo" <alessandro.riolo@.sen.it> wrote in message
news:etpS%23FiEGHA.644@.TK2MSFTNGP09.phx.gbl...
>I am using SSMS since a few weeks, and I found it is missing a few
>tools/utilities from the old Query Analyzer. One of the things which hit me
>is the lack of the Debug (I know I can do it in VS 2005, but I can't
>understand why I can't debug in SMSS), another is the lack of support for
>Sql Server 2000 diagrams, and then there are annoying things as forcing us
>to use a different shortcut to bookmark and so on.
> The worst of all, anyway, is that we still can't apply a customized format
> to the sql documents. In the development team I am working in we're using
> a formatting code convention quite different from that recommended by the
> Books Online, so every time I use the Query Designer, I have then manually
> to 'beautify' the resulting T-SQL code. Even in VS 2005 there seems not to
> be a way to format all of a SQL document, as it is possible to do with c#
> i.e..
> Get me right, so far my experience with SMSS has been positive, only these
> and other little defaillances are marking the difference between an useful
> tool and a tool to recommend.
> --
> ale
> http://www.riolo.org
|||Michael Hotek wrote:
> Go to the Product Feedback Center and put in a request to add the features
> that are missing
I already did it for one of the most annoying of the lack, a
customizable sql document formatter either in SSMS either in VS2005:
http://lab.msdn.microsoft.com/produc...e-43fe9c69ad8f
ale
http://www.riolo.org
|||Alessandro Riolo (alessandro.riolo@.sen.it) writes:
> The worst of all, anyway, is that we still can't apply a customized
> format to the sql documents. In the development team I am working in
> we're using a formatting code convention quite different from that
> recommended by the Books Online, so every time I use the Query Designer,
I can't say that the most serious problem with the Query Designer is
that you cannot customize how it formats the code. A much more serious
problem is that it may rewrite queries to have a different meaning.
That tool is dangerous!
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
|||John Bell wrote:
> For diagrams look in Books online on how to set them up and add one
> http://msdn2.microsoft.com/en-us/library/ms189279.aspx
Quoting the BOL:
"SQL Server 2005 database diagrams and SQL Server 2000 database diagrams
are created and rendered differently. Because of these differences, SQL
Server Management Studio cannot work with SQL Server 2000 diagrams. Use
SQL Server 2000 Enterprise Manager"
ale
http://www.riolo.org