Solved

Comparing MSDE 2000 and SQL server 2005 Express

Posted on 2007-03-29
1
295 Views
Last Modified: 2008-02-01
My customer is running MSDE 2000 and are nearing the database limit of 2 GB. Would like to upgrade to SQL Server 2005 Express which gives a limit of 4 GB pr. database.

But is there any known drawbacks? The Express has a memory allocation limit of 1 GB but i cant find the limit for MSDE 2000. The customer has 2,5 GB memory installed.

Any other things to take care of?
0
Comment
Question by:TANGLAD
1 Comment
 
LVL 20

Accepted Solution

by:
Sirees earned 125 total points
ID: 18815341
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question