Interface for the MSDE

Hi All,
I just installed MSDE Release A. Haven't used it before.
Is there no interface to the database like the Enterprise Manager or isql utility?
How can I execute a query and view the databases?
Thanks
> I just installed MSDE Release A. Haven't used it before.
> Is there no interface to the database like the Enterprise Manager or isql
utility?
> How can I execute a query and view the databases?
There are no tools like EM, or QA.
But there should be a program called "osql". i've never used it before
(command line and all *shudder*). But supposedly it does come with MSDE.
The real answer to the question, "How can I execute a query and view the
databases?" is:
You write a front-end application in VB, C++, or Delphi (yeah Delphi). And
probably using ADO as the database connectivity technology.
Other than that, there are some free and (and some not free) grahical MSDE
management programs.
Google for them "free enterprise manager", or "msde management tool", etc..
|||There are GUI Utils for MSDE 2000 as Ian stated, you can Install Enterprise
manager ie the client tools if you have a full SQL server 2000 Server
version and a SQL License or use OSQL , see below article:
How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql
Utility
http://support.microsoft.com/default...b;en-us;325003
HTH
Dylan
"Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
news:Ogm4v1ZaEHA.2388@.TK2MSFTNGP11.phx.gbl...
> utility?
> There are no tools like EM, or QA.
> But there should be a program called "osql". i've never used it before
> (command line and all *shudder*). But supposedly it does come with MSDE.
> The real answer to the question, "How can I execute a query and view the
> databases?" is:
> You write a front-end application in VB, C++, or Delphi (yeah Delphi). And
> probably using ADO as the database connectivity technology.
>
> Other than that, there are some free and (and some not free) grahical MSDE
> management programs.
> Google for them "free enterprise manager", or "msde management tool",
> etc..
>
|||Sorry i Meant NO GUI tools!
"Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
news:%23bJVcnaaEHA.3752@.TK2MSFTNGP12.phx.gbl...
> There are GUI Utils for MSDE 2000 as Ian stated, you can Install
> Enterprise manager ie the client tools if you have a full SQL server 2000
> Server version and a SQL License or use OSQL , see below article:
> How To Manage the SQL Server Desktop Engine (MSDE 2000) by Using the Osql
> Utility
> http://support.microsoft.com/default...b;en-us;325003
> HTH
> Dylan
>
> "Ian Boyd" <admin@.SWIFTPA.NET> wrote in message
> news:Ogm4v1ZaEHA.2388@.TK2MSFTNGP11.phx.gbl...
>
|||You can even install some free GUI tools for MSDE from web. I use a great tool by Andrea, you can grab it from http://www.asql.biz/DbaMgr/DownLoad2k.shtm
Let us know if you have any more questions.
dev_kh
"Dylan kruger" wrote:

> Sorry i Meant NO GUI tools!
> "Dylan kruger" <carmellobear1@.hotmail.com> wrote in message
> news:%23bJVcnaaEHA.3752@.TK2MSFTNGP12.phx.gbl...
>
>
|||Thank you Dylan and Dev for the links
"dev_kh" wrote:
[vbcol=seagreen]
> You can even install some free GUI tools for MSDE from web. I use a great tool by Andrea, you can grab it from http://www.asql.biz/DbaMgr/DownLoad2k.shtm
> Let us know if you have any more questions.
> dev_kh
> "Dylan kruger" wrote:
|||MSDE does not come with a front-end. Try WinSQL at
http://www.synametrics.com/winsql
sm wrote:

> Hi All,
> I just installed MSDE Release A. Haven't used it before.
> Is there no interface to the database like the Enterprise Manager or isql utility?
> How can I execute a query and view the databases?
> Thanks

Integration Services in BOL: Is this all I get?

Short answer
NO, the beta or CTP Books Online that you're using is not all there's going to be. Make sure that you watch for the Web release of BOL that will drop around the time that SQL Server 2005 hits the streets! Read more to understand why.

More information
SQL Server 2005 is going to be released simultaneously in 8 or 9 languages. Since the documentation team had to lock down early to allow time for translation, the version of Books Online that you'll get on the CD in the box is going to be several months old. Think of the BOL in the box as Version 0.9, while Version 1.0 will be the RTM Web release. Meanwhile we're working non-stop to update, improve, and add to the Integration Services content in Books Online.

Remember that the BOL feedback links are your most direct route to improved content!

-Doug

Doug,
Are we going to be able to sync our local install with the web release?

-Jamie|||Jamie,

If you mean, will you see updated content silently downloaded on a topic-by-topic basis in your existing BOL installation, unfortunately, no. BOL and the Microsoft Help 2.0 technology that we rely on don't currently support that. The Web release around RTM that I mentioned will simply be a complete new BOL installation...and yes, a rather sizeable download.

We will, at least, be flagging content that has changed significantly so that you won't have to scan all the sections that interest you with the hope of coming across some new tidbit of information.

Best regards,

-Doug