"RobR" wrote:

> I have SQL Server 2000 but discovered it doesn't install on
> Server 2003 Web Edition, so I installed MSDE 2000 revision
> A.  Now I've googled up the wazoo, searched the SQL 2000
> CD and searched the MS website but I can't figure out where
> to get the tools to actually manage MSDE and set up a db and
> what not.  Any pointers appreciated.  Thanks!
>
>
>

"burt_king" <burt_k***@yahoo.com> wrote in message
news:2A73C903-5A83-45C0-AE30-C00889C85766@microsoft.com...
> MSDE doesn't come with any tools.  If you have enterprise manager in your
> environment you can use that but it's not something you can purchase
> seperate
> from the SQL 2000 server license.
>
> Use the command prompt to administer the MSDE.  osql is the default
> "Manager" and requires a pretty good knowledge of SQL Server to get
> around.
>
>
> --
> burt_k***@yahoo.com
>
>
> "RobR" wrote:
>
>> I have SQL Server 2000 but discovered it doesn't install on
>> Server 2003 Web Edition, so I installed MSDE 2000 revision
>> A.  Now I've googled up the wazoo, searched the SQL 2000
>> CD and searched the MS website but I can't figure out where
>> to get the tools to actually manage MSDE and set up a db and
>> what not.  Any pointers appreciated.  Thanks!
>>
>>
>>

"RobR" wrote:

> Problem solved, as I mentioned I do have the actual SQL server 2000 CD.
> I just couldnt use it on 2003 Web Edition so resorted to MSDE.
>
> I figured out that you have to go through the motions as though
> you were actually going to install SQL server.  i didn't expect
> this to work since I was running on XP Pro.  I finally found
> the info on installing the client tools in the help file on the CD.
>
> "burt_king" <burt_k***@yahoo.com> wrote in message
> news:2A73C903-5A83-45C0-AE30-C00889C85766@microsoft.com...
> > MSDE doesn't come with any tools.  If you have enterprise manager in your
> > environment you can use that but it's not something you can purchase
> > seperate
> > from the SQL 2000 server license.
> >
> > Use the command prompt to administer the MSDE.  osql is the default
> > "Manager" and requires a pretty good knowledge of SQL Server to get
> > around.
> >
> >
> > --
> > burt_k***@yahoo.com
> >
> >
> > "RobR" wrote:
> >
> >> I have SQL Server 2000 but discovered it doesn't install on
> >> Server 2003 Web Edition, so I installed MSDE 2000 revision
> >> A.  Now I've googled up the wazoo, searched the SQL 2000
> >> CD and searched the MS website but I can't figure out where
> >> to get the tools to actually manage MSDE and set up a db and
> >> what not.  Any pointers appreciated.  Thanks!
> >>
> >>
> >>
>
>
>