Alphabetical list of options
196
This option specifies whether integrated logins are permitted. The following
values are accepted (the values are case insensitive):
♦
Standard This is the default setting, which does not permit integrated
logins. An error occurs if an integrated login connection is attempted.
♦
Mixed With this setting, both integrated logins and standard logins are
allowed.
♦
Integrated With this setting, all logins to the database must be made
using integrated logins.
Caution
Setting the LOGIN_MODE database option to Integrated restricts
connections to only those users who have been granted an
integrated login mapping. Attempting to connect with a user ID
and password generates an error. The only exceptions to this are
users with DBA authority (full administrative rights).
$ For more information on integrated logins see "Using integrated logins"
on page 77 of the book ASA User’s Guide.
LOGIN_PROCEDURE option
A login procedure that sets connection compatibility options at startup. By
default the procedure calls the
sp_login_environment
procedure to determine
which options to set.
String
Can be set for an individual connection or for the PUBLIC group. Takes
effect immediately.
sp_login_environment
This login procedure calls the sp_login_environment procedure at run time to
determine the database connection settings.
You can customize the default database option settings by creating a new
procedure and setting LOGIN_PROCEDURE to call the new procedure. You
should not edit either sp_login_procedure or sp_tsql_environment.
MAX_CURSOR_COUNT option
A resource governor to limit the maximum number of cursors that a
connection can use at once.
Description
Function
Allowed values
Scope
Default
Description
Function
To Next Page
Loading...