MSDE
From Wikipedia, the free encyclopedia
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 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 concurrent workloads on the engine.[1]
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.
Contents |
[edit] 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 [1]
[edit] SQL Slammer
MSDE was affected by the 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 NAT can be infected. This vulnerability can be corrected by installing the latest security patches available from Microsoft.
[edit] SQL Server Express
SQL Server Express has replaced MSDE. Support for MSDE ended on April 8, 2008[2].
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[3].
[edit] See also
- Microsoft Servers
- List of relational database management systems
- Comparison of relational database management systems
[edit] References
[edit] External links
|
|||||||||||||||||||||||||||||||
.
