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!

hi Rob,
RobR wrote:
please have a look at http://www.microsoft.com/sql/msde/partners/ and/or
http://www.aspfaq.com/show.asp?id=2442 for a list of free and commercial
tools...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

"Andrea Montanari" <andrea.sqlDMO (AT) virgilio (DOT) it> wrote

Thanks, but doesnt MS provide tools? As I mentioned I do have
SQL server 2000, but couldn't figure out how to install any tools
that might be on there. No install option, no SUPPORT or
TOOLS directory.

"RobR" <nospam (AT) nospam (DOT) com> wrote

Problem solved. 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.