user options
Type: Basic
Default value: 0
The user options parameter allows you to specify certain defaults for all the options allowed with the SET T-SQL command. Individual users can override these values by using the SET command. You are essentially able to establish these options for all users unless the users override them for their own needs. User options is a bitmask field, and each bit represents a user option. Table 60.1 outlines the values you can set with this parameter.
TABLE 60.1 Specifying User Options Values
For a given user connection, you can use the @@options global variable to see the values that have been set.
The following ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
