SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Database Engine
Database Engine How-to Topics
Administration How-to Topics
Server Management How-to Topics
Server Configuration How-to Topics
How to: View Server Properties (SQL Server Management Studio)
How to: Check and Set Remote Server Connection Options (SQL Server Management Studio)
How to: View or Change Server Properties (SQL Server Configuration Manager)
How to: Configure the Affinity Mask (SQL Server Management Studio)
How to: Configure the allow updates Option (SQL Server Management Studio)
How to: Configure the awe enabled Option (SQL Server Management Studio)
How to: Configure the c2 audit mode Option (SQL Server Management Studio)
How to: Configure the cost threshold for parallelism Option (SQL Server Management Studio)
How to: Configure the cursor threshold Option (SQL Server Management Studio)
How to: Set the Default Full-Text Language (SQL Server Management Studio)
How to: Set the Default Language (SQL Server Management Studio)
How to: Set a Fixed Fill Factor (SQL Server Management Studio)
How to: Configure the index create memory Option (SQL Server Management Studio)
How to: Configure the locks Option (SQL Server Management Studio)
How to: Configure the Number of Processors Available for Parallel Queries (SQL Server Management Studio)
How to: Set Minimum Query Memory (SQL Server Management Studio)
How to: Configure the Maximum Number of Worker Threads (SQL Server Management Studio)
How to: Set the Backup Retention Duration (SQL Server Management Studio)
How to: Set a Fixed Amount of Memory (SQL Server Management Studio)
How to: Configure the max text repl size Option (SQL Server Management Studio)
How to: Configure the nested triggers Option (SQL Server Management Studio)
How to: Configure the priority boost Option (SQL Server Management Studio)
How to: Set the Recovery Interval (SQL Server Management Studio)
How to: Set Remote Server Access (SQL Server Management Studio)
How to: Set Remote Login Timeout (SQL Server Management Studio)
How to: Configure the scan for startup procs Option (SQL Server Management Studio)
How to: Enforce Distributed Transactions for Remote Procedures (SQL Server Management Studio)
How to: Set a Time Limit for Remote Queries (SQL Server Management Studio)
How to: Configure the two-digit year cutoff Option (SQL Server Management Studio)
How to: Set User Connections (SQL Server Management Studio)
How to: Configure User Options (SQL Server Management Studio)
How to: Configure Packet Size (SQL Server Management Studio)
How to: Configure the query governor cost limit Option (SQL Server Management Studio)
How to: Configure the query wait Option (SQL Server Management Studio)
How to: Enable the Lock Pages in Memory Option (Windows)
How to: Map TCP/IP Ports to NUMA Nodes
How to: Configure SQL Server to Use Soft-NUMA
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Configure User Options (SQL Server Management Studio)

SQL Server 2005

Use the user options option 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. The user options option allows you to change the default values of the SET options (if the server's default settings are not appropriate).

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Connections node.

  3. In the Default connection options box, select one or more attributes to configure the default query-processing options for all connected users.

    By default, no user options are configured.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.