Viewing Server Attributes

SQL Enterprise Manager can display attribute names and matching values for SQL Server, the database gateway, and the underlying data source.

    To use SQL Enterprise Manager to display server attributes

1. From the Microsoft SQL Server 6.0 program group, start SQL Enterprise Manager.
2. From the Server Manager window, open a server group and select a server.
3. From the Server menu, choose Configurations.

   The Server Configuration/Options dialog appears.

4. Choose the Attributes tab.

   The Attributes window appears, listing SQL Server version information, various environmental variables, and their values.

   

   The displayed values cannot be modified.

Server attributes can also be viewed using xp_msver. For information, see the Microsoft SQL Server Transact-SQL Reference.