Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Sep 10, 2000

Create Your Own Administration Tool for MSDE

By Danny Lesandrini

What is MSDE

According to the Microsoft Office 2000/Visual Basic Programmer's Guide MSDE (Microsoft Data Engine) is a new technology that provides local data storage compatible with Microsoft SQL Server 7.0. You can think of MSDE as a client/server database engine alternative to the file-server Microsoft Jet database engine. MSDE runs under Windows NT 4.0 or later and Windows 95 or later. It is designed and optimized for use on smaller computer systems, such as a single-user computer or small-workgroup server. MSDE doesn't limit the number of users who can connect to its database, but is optimized for five users.

Because MSDE is based on the same database engine as SQL Server, most Microsoft Access projects or client/server applications can run unchanged on either version. However, unlike SQL Server 7.0, MSDE has a 2-gigabyte database size limit, supports up to 2 processors for Symmetrical Multiprocessing (SMP), and in a replicated database environment cannot be a replication publisher for transactional replication (although it can act as a replication subscriber for both transactional and merge replication, and as a replication publisher for merge replication).

For the developer, this means that you can now create applications that leverage the power of SQL Server while providing your users with a robust, royalty free database. All of the familiar features of SQL Server are available in MSDE: tables, views, stored procedures, rules, constraints, triggers and even the security SQL Server model.

Page 2: How is MSDE administered?

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM