managing msde

[Ive]

Hi,

You can use MS Access (from 2000 upwards) to manage databases in MSDE.

You can use your VS.NET IDE to do the same.

The enterprise manager works fine on MSDE too! Just check regarding
licensing-issues but if you are working on your company-pc you should be
safe. However, some things (such as maintenance plans) won't work.

Basically, there is no difference between MSDE and native SQL Server except
for:
. max db-size is 2GB per database
. Works on all client-os systems (except Win 95 I think).
. Can NOT act as a publisher for replication (only as a subscriber)

I may have forgotten something but I think this it it. MSDE is great for up
to 5 concurrent users!

Ive

 

[William \(Bill\) Vaughn]

Yes, you forgot a couple of things.
MSDE is limited to 5 concurrent workloads--not 5 users.
MSDE is a "deployment" configuration--not a development tool. Other versions
of SQL Server come with the needed tools.

--
____________________________________
Bill Vaughn
MVP, hRD
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Joe Fallon]

Actually it is not even limited to 5 concurrent workloads.
That's just when the governor kicks in and slows it down!
Once the number of processes is 5 orless they go full throttle again.
There is a dbcc command you can use to determine how often the governor
kicks in.
DBCC CONCURRENCYVIOLATION
This is for determining when you need to upgrade to a real version of SQL
Server.

The Developer Edition price dropped from $449 to $49.
There is no excuse for not owning it now.

 

[Ive]

All helpful information!

I think MSDE is great for DEPLOYMENT, not for development!

Ive