Questions: MSDE 2000

Currently using MSDE 7 with SQL Enterprise Manager. Our company is
contemplating upgrading to MSDE 2000.
1. Do I have to download a new SQL Enterprise Manager to work with MSDE
2000?
2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000 databases?
Thanks.Hi,
SQL7 enterprise manager cannot connect to a SQL2000 database.You need to
upgrade.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
news:%23DSqxRaZDHA.656@.tk2msftngp13.phx.gbl...
> Currently using MSDE 7 with SQL Enterprise Manager. Our company is
> contemplating upgrading to MSDE 2000.
> 1. Do I have to download a new SQL Enterprise Manager to work with MSDE
> 2000?
> 2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000 databases?
> Thanks.
>|||Upgrade to what? SQL 2000? All I want to use is the FREE MSDE 2000 database.
As I remember I didn't have to purchase SQL 7 Enterprise Manager. It came
with Visual Studio or something. Do you have a link where I can download
both MSDE2000 and the newest Enterprise Manager to use with it?
"Dinesh.T.K" <tkdinesh@.nospam.mail.tkdinesh.com> wrote in message
news:uL1TybaZDHA.2284@.TK2MSFTNGP10.phx.gbl...
> Hi,
> SQL7 enterprise manager cannot connect to a SQL2000 database.You need to
> upgrade.
> --
> Dinesh.
> SQL Server FAQ at
> http://www.tkdinesh.com
> "VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
> news:%23DSqxRaZDHA.656@.tk2msftngp13.phx.gbl...
> > Currently using MSDE 7 with SQL Enterprise Manager. Our company is
> > contemplating upgrading to MSDE 2000.
> >
> > 1. Do I have to download a new SQL Enterprise Manager to work with MSDE
> > 2000?
> > 2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000
databases?
> >
> > Thanks.
> >
> >
>|||> both MSDE2000 and the newest Enterprise Manager to use with it?
You can't download Enterprise Manager, unless you want the evaluation
version with a timebomb (which, by licensing, would, I think, be illegal to
use for managing MSDE, unless you are truly evaluating it...).
Some other options: http://www.aspfaq.com/2442|||> Part of the "deal" with the MSDE is that it's choked down to only 5
> connections
That's not true. There is a query governor that kicks in after there are
already 5 *concurrent workloads*... much different from *connections*
> and 1 database
Not true either (32,767, IIRC).
For a more concise list of MSDE limitations/features, see
http://www.aspfaq.com/2343 and http://www.aspfaq.com/2345|||Great response. Is it legal to buy SQL 2000 Server Developer Edition JUST to
use the tools (ie Enterprise Manager, etc...) on MSDE databases that I
distributed to my customers?
"J O Holloway" <jholloway@.pinncorp.com> wrote in message
news:eFjfPAdZDHA.1940@.TK2MSFTNGP10.phx.gbl...
> You can use the SQL Server 2000 Enterprise Manager to access both MSDE 1.0
> and MSDE 2000.
> I realize that that doesn't help you right now, since apparently you only
> have the SQL Server 7 EM.
> Part of the "deal" with the MSDE is that it's choked down to only 5
> connections and 1 database and 2 GB and NO GUI TOOLS.
> A full license for SQL Server 2000 Developer is now under $50, including
> shipping. Here's one site:
> http://www.pcconnection.com/scripts/productdetail.asp?product_id=213218
> There are others. For that kind of low cost, you might be better served
to
> just buy the Developer Edition.
> There are a few other GUIs for the MSDE, and you might find a free one.
For
> the money, I was glad to buy my own copy of SQL Server Developer. If
you're
> jammed for time, you can still interact with the MSDE via the oSQL
utility.
> You can find links for downloading the MSDE (and service patches) on the
MS
> site.
> Best of luck.
>
> "VB Programmer" <growNO-SPAM@.go-intech.com> wrote in message
> news:#DSqxRaZDHA.656@.tk2msftngp13.phx.gbl...
> > Currently using MSDE 7 with SQL Enterprise Manager. Our company is
> > contemplating upgrading to MSDE 2000.
> >
> > 1. Do I have to download a new SQL Enterprise Manager to work with MSDE
> > 2000?
> > 2. Can SQL Enterprise Manager access BOTH MSDE 7 AND MSDE 2000
databases?
> >
> > Thanks.
> >
> >
>|||Thanks for the clarifications.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OrFdNQdZDHA.1832@.TK2MSFTNGP10.phx.gbl...
> > Part of the "deal" with the MSDE is that it's choked down to only 5
> > connections
> That's not true. There is a query governor that kicks in after there are
> already 5 *concurrent workloads*... much different from *connections*
> > and 1 database
> Not true either (32,767, IIRC).
> For a more concise list of MSDE limitations/features, see
> http://www.aspfaq.com/2343 and http://www.aspfaq.com/2345
>