Purpose

The purpose of this article is to teach you the process of configuring user options in Microsoft SQL Server 2000.

To Configure User Options

User options option is used to specify global defaults for all users. A list of default query processing options is established for the duration of a user's work session. user options allows you to change the default values of the SET options (if the server's default settings are not appropriate). A user can override these defaults by using the SET statement.

Following steps describe you the step by step details of configuring user options in Microsoft SQL Server 2000:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click on registered SQL Server i.e. PC54, then click Properties, and select Connections tab. Now, check the user options under Default connection options.

3. Click OK.