sp_loginconfig

Description

Windows NT only Displays the value of one or all integrated security parameters.

Syntax

sp_loginconfig ["parameter_name"]

Parameters

parameter_name

is the name of the integrated security parameter you want to examine. Values are:

  • login mode

  • default account

  • default domain

  • set host

  • key _

  • key $

  • key @

  • key #

Examples

Example 1

Displays the values of all integrated security parameters:

sp_loginconfig
name                config_item
---------------------- ----------------------
login mode          standard
default account     NULL
default domain      NULL
set host            false
key _               domain separator
key $               space
key @               space
key #               -

Example 2

Displays the value of the login mode security parameter:

sp_loginconfig "login mode"
name                config_item
---------------------- ----------------------
login mode          standard

Usage

Permissions

Only a System Administrator can execute sp_loginconfig.

Auditing

Values in event and extrainfo columns from the sysaudits table are:

Event

Audit option

Command or access audited

Information in extrainfo

38

exec_procedure

Execution of a procedure

  • Roles – Current active roles

  • Keywords or options – NULL

  • Previous value – NULL

  • Current value – NULL

  • Other information – All input parameters

  • Proxy information – Original login name, if set proxy in effect

See also

System procedures sp_revokelogin