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