Export (0) Print
Expand All

Administration Tools FAQ

SQL Server 2000

When I attempt to register an OLAP server running on Microsoft® Windows® 2000 from an OLAP server running on Microsoft Windows NT®, I get the following error:

Errors occurred while connecting to server2000.
Cannot connect to the registry on the server computer (server2000).
Do you still want to register this server?

How do I resolve this error?


Start the remote registry service on the computer running Windows 2000 by performing the following steps:
  1. On the Start menu, point to Programs, point to Administrative Tools, and then click Services.

  2. Right-click Remote Registry Service, and then on the shortcut menu, click Start .

Can the ON DELETE CASCADE option be set in the user interface?


Yes. When creating the table in the Diagram user interface, click Table and Index Properties. On the Relationships tab, select the cascading referential integrity option you want to implement:
  • Cascade Update Related Fields

  • Cascade Delete Related Records

When creating a new table in SQL Server Enterprise Manager, I see a field titled Description for each column. How is this field used?


The purpose of the Description field is to allow you to store a textual description of each column. There is also a Description field associated with the table. This description is stored as an extended property on the field. When generating a script for the table, the Include Extended Properties option appears on the formatting page. If this option is selected when the script is generated, the description property will show in the script.

Using SQL Server Enterprise Manager, how can I set a database to single user mode and dbo use only mode?


In SQL Server 2000, a database cannot be set to both single user mode and dbo use only mode simultaneously. Instead, SQL Server Enterprise Manager allows you to set the following alternative options by right-clicking the database to change, clicking Properties on the shortcut menu, and then clicking the Options tab.

Restrict access

  • When this option is not selected, normal access to the database is allowed.

  • When this option is selected, the following settings are available:
    • Members of db_owner, dbcreator, or sysadmin

      When selected, this option restricts access to the database only to members of the db_owner, dbcreator, or sysadmin roles.

    • Single user

      When selected, this option restricts access to the database to only one user at a time.

Both of these options exist for SQL Server 6.5 and 7.0 databases. However, if you are using SQL Server 2000 tools, you can no longer set these options on the database properties tab in SQL Server Enterprise Manager. Instead, these options can be set only on SQL Server 6.5 and 7.0 databases by running the sp_dboption stored procedure.

Can I have both SQL Server 7.0 and SQL Server 2000 client management tools installed on the same computer?


No. During an installation upgrade, the SQL Server 2000 tools replace the SQL Server 7.0 tools. Additionally, when installing SQL Server 2000 as a separate instance, if you choose to upgrade the tools, the SQL Server 7.0 program group remains and the SQL Server 2000 program group is added. However, the icons in the SQL Server 7.0 program group actually execute the SQL Server 2000 tools instead of the original SQL Server 7.0 tools.

Is it possible to define a special template that is copied automatically into the query pane for SQL Query Analyzer when you select New?


Yes. By default, a blank document is always displayed. However, you can define and save a special template by typing the Transact-SQL statements into a window in SQL Query Analyzer, selecting Save As, and saving it in the directory you want as a Template SQL File (*.tql). You can select the template you want to open by selecting the drop down New icon on the toolbar, and then selecting Template.

Is it possible to use SQL Server 7.0 tools to connect to SQL Server 2000?


It is recommended that you upgrade your tools to SQL Server 2000 if you plan to connect to a computer running SQL Server 2000 because most SQL Server 7.0 tools will not connect to computers running SQL Server 2000. The only SQL Server 7.0 tools that can connect to computers running SQL Server 2000 are SQL Query Analyzer and osql; however, these tools cannot be used to connect to named instances of SQL Server 2000.
© 2015 Microsoft