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]]
.