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?