Introducing Microsoft SQL Server 2000 Desktop Engine

The Microsoft SQL Server 2000 Desktop Engine is a data engine that is built on core SQL Server technology.

As Microsoft SQL Server 2000 Desktop Engine supports single and dual processor desktop computers, it serves as a reliable storage engine and query processor for the desktop extensions of enterprise applications. Both SQL Server and Microsoft SQL Server 2000 Desktop Engine share a common technology base. This enables developers to build applications that can scale seamlessly from portable computers to multiprocessor clusters.

The Microsoft SQL Server 2000 Desktop Engine does not have a default user interface or any tools. You can interact with the Microsoft SQL Server 2000 Desktop Engine through the application in which it is embedded. For ease of distribution and embedding, the Microsoft SQL Server 2000 Desktop Engine is packaged in a self-extracting archive. The Microsoft SQL Server 2000 Desktop Engine can also be built into applications and redistributed without royalty with Microsoft development tools such as Microsoft Visual Studio.NET and Microsoft Office XP Developer Edition. This enables developers to build enterprise-class reliability and enhanced database features into their desktop applications.

Microsoft SQL Server 2000 Desktop Engine is fully compatible with SQL Server. The operating systems in which you can run the Microsoft SQL Server 2000 Desktop Engine as an embedded database, are Microsoft Windows 98, Windows Millenium Edition (Windows Me), Microsoft Windows NT Workstation version 4.0 (With Service Pack 5 or later), and Windows 2000 Professional.

Some of the features of Microsoft SQL Server 2000 Desktop Engine include:

• Multi-Instance Support - The Microsoft SQL Server 2000 Desktop Engine supports up to 16 database server instances on a single computer.

• Replication - The Microsoft SQL Server 2000 Desktop Engine fully supports merge and snapshot replication both as a publisher and as a subscriber, which enables you to keep copies of the same data on multiple sites.

• Data Transformation Services - The Microsoft SQL Server 2000 Desktop Engine can run Data Transformation Services packages. The Microsoft SQL Server 2000 Desktop Engine can only run the Data Transformation Services packages and cannot design one, as it is not equipped with a Data Transformation Services Designer.

• Remote Administration - The Microsoft SQL Server 2000 Desktop Engine supports both local and remote administration. Remote administration of the Microsoft SQL Server 2000 Desktop Engine is not possible in a multi server environment.

| What is Private Access Modifier in C#? |Introducing Microsoft SQL Server 2000 Desktop Engine | What is Protected Access Modifier in C#? | What is Protected Internal Access Modifier in C#? | What is Public Access Modifier in C#? | What is the difference between virtual and abstract keywords in .NET? | What is the importance of Microsoft Application Blocks in .NET Architecture? | What is the need for Factory Method in C# | What is the purpose of ArrayList in .NET? | What is the purpose of Datareader in ADO.NET? | What is the purpose of Dataset in ADO.NET? | What is the purpose of finally block in C#? | What is the purpose of interlocked class in .NET? | What is the purpose of main() function in C# | What is the purpose of ManualResetEvent in .NET? | What is the purpose of sealed method in C#? | What is the purpose of Thread.Join() method in .NET? | What is the purpose of Thread.Sleep() method in .NET? | What is the purpose of throw keyword in C#? | What is the usage of ENUM in .NET? |