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.
For a given user connection, you can use the
@@options global variable to see the values that have been set.
The following ...