MSDE 1609939 210653053 2008-05-06T20:48:52Z 72.54.132.91 /* Versions for Windows */ '''MSDE''' stands for '''MS Data Engine''', '''Microsoft Desktop Engine''' or '''Microsoft SQL Server Desktop Engine'''. It is a toned down version of [[Microsoft SQL Server]] 7.0 or 2000 which is free for non-commercial use as well as certain limited commercial use. MSDE and SQL Server are [[Microsoft]]'s database platforms. MSDE has some restrictions: a limit of 2 [[Gigabyte|GB]] databases, and it comes with no [[GUI]] tools to administer it. It also has a workload governor which reduces its speed once you exceed eight [[parallel programming|concurrent]] workloads on the engine.<ref>[http://msdn2.microsoft.com/en-us/library/aa224554(SQL.80).aspx The SQL Server 2000 Workload Governor]</ref> MSDE can be distributed with commercial products by registering with Microsoft — in most cases this distribution is also free of charge. The product is intended primarily to compete with other freely-available database platforms. ==Versions for Windows== * [[1999]] - MSDE 1.0 (based on SQL Server 7.0) * [[2000]] - MSDE 2000 (based on SQL Server 2000) * [[2003]] - MSDE 2000 Release A [http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en] ==SQL Slammer== MSDE was affected by the [[SQL slammer (computer worm)|SQL Slammer worm]] and that increased the number of the systems affected. This, together with many home users unaware that they had MSDE installed, worsened the impact of this worm. Also, if a computer running MSDE was infected with this worm via the Internet and then connected to a [[VPN]], the SQL Servers inside the [[Network address translation|NAT]] can be infected. This vulnerability can be corrected by installing the latest security patches available from Microsoft. ==SQL Server Express== [[SQL Server Express]] has replaced MSDE. Support for MSDE ended on [[April 8]], [[2008]]<ref name = "Upgrade">[http://www.microsoft.com/sql/editions/express/upgrade.mspx MSDE Upgrade].</ref>. Microsoft states that MSDE is not supported in Windows Vista, their new operating system; they recommend applications be built (or rebuilt) with [[SQL Server Express]]<ref name = "Vista">[http://www.microsoft.com/sql/howtobuy/sqlonvista.mspx MS SQL Server on Vista].</ref>. ==See also== *[[Microsoft Servers]] *[[List of relational database management systems]] *[[Comparison of relational database management systems]] ==References== <references /> ==External links== *[http://www.microsoft.com/sql/prodinfo/previousversions/msde/prodinfo.mspx Microsoft product page] *[http://www.microsoft.com/sql/editions/express/default.mspx SQL Server Express Edition] {{MS DevTools}} [[Category:Database management systems]] [[Category:Microsoft server technology]] [[fr:MSDE]] [[ja:Microsoft SQL Server#MSDE]] .