Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE OR SQL Server
Message
General information
Forum:
Microsoft SQL Server
Category:
Installation
Miscellaneous
Thread ID:
00797428
Message ID:
00797596
Views:
24
>I have 2 options: MSDE on 2000 PRO or install 2000 server and install SQL Server 2k.
>
>
>It will be a small DB (less than 500Mb) with less than 20 concurrent users.
>
>Cen I simply use MSDE, since it will be much cheaper than having to buy Windows server 2k and SQL server 2k ???
>
>On my other server, I have both SQL Server 2k and Win2K.
>
>
>Thanks.

Solution is hidden in limitations
First - you can install SQLServer on Win2000Pro
That's why you do not need Win2000Svr or Win2003Svr.
If you like it is cheaper to by as OEM with new hardware

MSDE is scutted SQLServer without QA(Query analizer) and EM(Enterprise manager). There are a few products - VB & VFP , which can substitude succesfuly it.

MSDE alow to 10 concurent connections, your application should be done in a way to use as less as possible database. In this case could apears that will be not a problem 20 users to work with it.

2GB per database is enoudgh storage place. As example we have warehouse application which add to database 50000 rows every month and for two years it piles 160MB
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform