Export (0) Print
Expand All

Administering SQL Server 2000 Desktop Engine (MSDE 2000)

SQL Server 2000

Administering SQL Server 2000 Desktop Engine (MSDE 2000)

  Topic last updated -- January 2004

The database engine, replication, and Data Transformation Services (DTS) components in SQL Server 2000 Desktop Engine (MSDE 2000) are administered in the same manner as in any other version of SQL Server 2000. The primary difference is that MSDE 2000 does not include the graphical management tools or wizards, so the following mechanisms are typically used to administer instances of MSDE 2000:

  • Applications can be coded to fully administer an instance of the Desktop Engine by either:
    • Using the SQL Server administration APIs, such as SQL-DMO, and the DTS and replication programming objects.

    • Running Transact-SQL statements using the general database APIs (such as ADO.NET, ADO, OLE DB, and ODBC).
  • The following command prompt utilities are installed by the MSDE 2000 setup application and are provided without restrictions for use with the copy of MSDE 2000 that is installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The dtsrun.exe utility is also provided, but may not be used during development.

  • If you installed MSDE 2000 with another edition of SQL Server, you can administer instances of MSDE 2000 using the SQL Server 2000 graphical tools.

The SQL Server Books Online section called "Administering SQL Server" contains the topics that document the potential administration actions for the databases and instances of any version of SQL Server 2000. Topics in these sections contain procedures that indicate the steps required to perform that administration task. For example, there are procedures detailing how to perform the task using Enterprise Manager or Query Analyzer, how to perform it using SQL-DMO, and how to perform it by running Transact-SQL statements. Note that:

  • The procedures documenting using a graphical tool such as Enterprise Manager or Query Analyzer typically do not apply in MSDE 2000 environments.

  • Programmers coding applications to administer instances of MSDE 2000 typically use either the items documenting using SQL-DMO or using Transact-SQL as a guide to coding their applications.

  • End users who must administer an instance of MSDE typically use the osql utility to run the Transact-SQL statement or statements mentioned in the Transact-SQL item.

See Also

Administering SQL Server Overview

Using the osql Utility

Managing Replication with SQL Server 2000 Desktop Engine (MSDE 2000)

© 2014 Microsoft