SQL Server Express and MSDE - Differences

SQL Server Express and MSDE - Differences

This URL explains the major differences between SQL Server Express and MSDE (Microsoft Desktop Engine) SQL Server Express 2005 MSDE 2000 Application XCopy support Feature not present No DTS DTS runtime present Easy deployment because of no MDAC MDAC is part of install MSI only, good servicing story MSI and MSM, servicing of MSM hard Client Replication for Transactional, Merge, and snapshot Merge/snapshot publication supported in addition to replication subscription Robust Setup UI Basic setup UI No agent Agent present Supports Windows 2000 SP4, Windows XP SP1, and Windows 2003 Supports Windows 98, Windows Me, Windows 2000, Windows XP, Windows NT4, and Windows 2003 CLR support No CLR support GUI tools provided No GUI tools Database size limit: 4G Database size limit: 2G 1 CPU, 1GB RAM 2 CPU, 2GB RAM No throttle Workload throttle enforced Deep integration with Visual Studio Basic integration with Visual Studio Read more .. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp Regards, Mitesh Mehta Microsoft Certified Professional miteshvmehta@gmail.com