Managing Servers

Managing Servers

SQL Server 2000

Microsoft® SQL Server™ server management comprises a wide variety of administration tasks, including:

  • Registering servers and assigning passwords.

  • Reconfiguring network connectivity.

  • Configuring linked servers. This allows you to execute distributed queries and distributed transactions on OLE DB data sources across the enterprise.

  • Configuring remote servers.This allows you to use one SQL Server installation to execute a stored procedure residing on another SQL Server installation.

  • Configuring standby and failover servers.

  • Setting server configuration options.

  • Managing SQL Server messages.

  • Setting the polling intervals.

In most cases, you do not need to reconfigure the server. The default settings for the server components, configured during SQL Server setup, allow you to run SQL Server immediately after it is installed. However, server management is necessary in those situations where you want to add new servers, set up special server configurations, change the network connections, or set server configuration options to improve SQL Server performance.

© 2016 Microsoft