Solved

Comparing MSDE 2000 and SQL server 2005 Express

Posted on 2007-03-29
1
290 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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now