[thelist] MSDE management

[Ed Courtenay]

Correct me if I'm wrong - but MSDE *is* essentially a runtime MSSQL without
any of the management facilities or utilities (Enterprise Manager, iSQL,
iSQL/W etc.)

IIRC, you can install the SQL Server Developer Edition on the machine you
are running MSDE on, and you'll gain Enterprise Manager without losing any
data within MSDE.

Ed Courtenay
http://www.edcourtenay.co.uk

"We've all heard that a million monkeys on a million
keyboards would eventually come up with the entire
works of Shakespeare - thanks to the Internet, we now
know this isn't true...."


----- Original Message -----
From: "Joshua Olson" <joshua at alphashop.net>
To: <thelist at lists.evolt.org>
Sent: Tuesday, August 28, 2001 3:25 PM
Subject: Re: [thelist] MSDE management


> Norman,
>
> Until someone speaks up that actually knows the answer, have you tried
> simply copying the db to the HD, then set up an ODBC datasource to it that
> uses the MSDE drivers?  The instructions you have are not really pertinent
> because MSDE is *not* MSSQL.  The MSDE is more powerful than Access, and
> uses the syntax of MSSQL, but it *not* MSSQL and is therefore missing the
> cool features of it, like the Enterprise Manager.  But, again, you may be
> able to just set it up as an ODBC datasource.
>
> HTH,
>
> -joshua
>
> ----- Original Message -----
> From: "Norman Beresford" <n.beresford at anansi.co.uk>
> Subject: [thelist] MSDE management
>
>
> : Hi all
> :
> : This is possibly me being a bit thick, but I'm rather stupmed atm.  I've
> : installed the .net framework sdk on a win2k pro machine at home.  As
part
> of
> : the install it's setup MSDE, with a number of sample databases.  Now my
> : friend recently won a copy of Professional ASP.Net which he gave to me.
> : I've started working my way through it but it requres an additional
sample
> : DB to be added to the server.  However it only includes instructions on
> : adding it through SQL Server Enterprise Manager, and for the life of me
I
> : can't find this mentioned in the MSDE documentation anywhere.
> :
> : Thanks in advance to anyone that can help me out
> :
> : Norman
>
>
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt !