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

Missing Tools after Setup

In the MSDE BOOKs there is a list of utilities and there directorys that i
should have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-bcp2
-console
-isql2
-sqlagent
-sqldiag
-sqlmaint
-sqlservr
-vswitch
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp2
-dtsrun
-dtswiz
-isql2
-isqlw
-itwiz
-odbccmpt
-osql
-rebuildm
-sqlftwiz
x:\Program Files\Microsoft SQL Server\80\Com
-distrib3
-logread3
-replmerg3
-snapshot3
x:\Program Files\Common Files\Microsoft Shared\Service Manager
-scm
x:\Program Files\Common Files\Microsoft Shared\?
-regxmlss
That is the list that i should have, here is the list that i do have:
x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
-cmdwrap.exe
-sqlagent.exe
-sqlmaint.exe
-sqlservr.exe
x:\Program Files\Microsoft SQL Server\80\Tools\Binn
-bcp.exe
-cnfgsvr.exe
-dcomscm.exe
-DTSRUN.exe
-OSQL.exe
-scm.exe
-sqladhlp.exe
-sqlmangr.exe
-SVRNETCN.exe
x:\Program Files\Microsoft SQL Server\80\Com
-DISTRIB.exe
-replmerg.exe
-snapshot.exe
x:\Program Files\Common Files\Microsoft Shared\Service Manager
NO Service Manager Directory Exists
x:\Program Files\Common Files\Microsoft Shared\?
It says that this all should have been installed on the install by default
here is how installed
i moved my command prompt to the directory containing the setup folder
(C:\MSDERela)
then i ran
setup SAPWD="??"
this installed fine
what did i do wrong?
ALso i am very new to databases
the only thing that i have ever used is access which is pretty cut and dry.
I have had a lot of trouble finding simple tutorials for a beginner if any
one knows of one please let me know.
In the mean time a couple of quick questions:
1) does a database file have to be in the directory: C:\Program
Files\Microsoft SQL Server\MSSQL\Data
in order for it to work?
2) other than osql how can i access my data? The Books say that thre is a
SQL Server Query analyzer but could not find it (see beginning of post)
thanks Again for the help
WStoreyII
Hi,
I'm not sure which MSDE book you are referring to but the tools you mention
are those that are installed with SQL Server, not with the MSDE. The MSDE
ships with limited tools. The intention is that your application will do the
work. We have some tools you could try at our site. Others are at:
http://www.microsoft.com/sql/msde/pa.../default.aspx.
The data files do not have to be in a specific folder but you will find life
much easier if you have them all in a particular folder.
If you are going to be doing development for the MSDE, I'd strongly suggest
you purchase a copy of the SQL Server Developer Edition. I gather it's
currently only around $49 USD and provides a wealth of things you'll find
useful during development.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"WStoreyII" <WStoreyII@.discussions.microsoft.com> wrote in message
news:9109A07D-4093-4473-AB0A-CFDFD9611C06@.microsoft.com...
> In the MSDE BOOKs there is a list of utilities and there directorys that i
> should have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -bcp2
> -console
> -isql2
> -sqlagent
> -sqldiag
> -sqlmaint
> -sqlservr
> -vswitch
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp2
> -dtsrun
> -dtswiz
> -isql2
> -isqlw
> -itwiz
> -odbccmpt
> -osql
> -rebuildm
> -sqlftwiz
> x:\Program Files\Microsoft SQL Server\80\Com
> -distrib3
> -logread3
> -replmerg3
> -snapshot3
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> -scm
> x:\Program Files\Common Files\Microsoft Shared\?
> -regxmlss
> That is the list that i should have, here is the list that i do have:
> x:\Program Files\Microsoft SQL Server\MSSQL\Binn1
> -cmdwrap.exe
> -sqlagent.exe
> -sqlmaint.exe
> -sqlservr.exe
> x:\Program Files\Microsoft SQL Server\80\Tools\Binn
> -bcp.exe
> -cnfgsvr.exe
> -dcomscm.exe
> -DTSRUN.exe
> -OSQL.exe
> -scm.exe
> -sqladhlp.exe
> -sqlmangr.exe
> -SVRNETCN.exe
> x:\Program Files\Microsoft SQL Server\80\Com
> -DISTRIB.exe
> -replmerg.exe
> -snapshot.exe
> x:\Program Files\Common Files\Microsoft Shared\Service Manager
> NO Service Manager Directory Exists
> x:\Program Files\Common Files\Microsoft Shared\?
> It says that this all should have been installed on the install by default
> here is how installed
> i moved my command prompt to the directory containing the setup folder
> (C:\MSDERela)
> then i ran
> setup SAPWD="??"
> this installed fine
> what did i do wrong?
> ALso i am very new to databases
> the only thing that i have ever used is access which is pretty cut and
> dry.
> I have had a lot of trouble finding simple tutorials for a beginner if any
> one knows of one please let me know.
> In the mean time a couple of quick questions:
> 1) does a database file have to be in the directory: C:\Program
> Files\Microsoft SQL Server\MSSQL\Data
> in order for it to work?
> 2) other than osql how can i access my data? The Books say that thre is a
> SQL Server Query analyzer but could not find it (see beginning of post)
> thanks Again for the help
> WStoreyII
>
|||Greg's correct. MSDE was not intended to ship
with the full compliment of (management) tools
as SQL Server is.
If you're want to get up and running as quick as
possible then Microsoft Access (2000 and above)
is an excellent interface to MSDE for your own
internal development purposes. Micrsoft press has
a decent book on Access Data Projects also.
If you're wanting to use MSDE to develop a
distributable application, then you'll need to
be coding everything yourself.
Good luck.