System and catalog stored procedures
966
sa_conn_properties_by_conn system procedure
Reports connection property information
sa_conn_properties_by_conn ( [
property-name
] )
None.
None
"sa_conn_properties system procedure" on page 965
"Connection-level properties" on page 1090
This is a variant on the sa_conn_properties system procedure, and returns the
same result columns.It returns results only for connection properties that
match the property-name string. You can use wild cards in property-name, as
the comparison uses a LIKE operator. The result set is sorted by connection
number and property name.
$ For a listing of available connection properties, see "Connection-level
properties" on page 1090.
♦ The following statement returns the AnsiNull option setting for all
connections:
call sa_conn_properties_by_conn( ’ansinull’ )
♦ The following statement returns the Ansi-related option settings for all
connections:
call sa_conn_properties_by_conn( ’ansi%’ )
sa_conn_properties_by_name system procedure
Reports connection property information
sa_conn_properties_by_name ( [
connection-id
] )
None.
None
"sa_conn_properties system procedure" on page 965
"Connection-level properties" on page 1090
This is a variant on the sa_conn_properties system procedure, and returns the
same result columns. The information is sorted by property name and
connection number.
Function
Syntax
Permissions
Side effects
See also
Description
Example
Function
Syntax
Permissions
Side effects
See also
Description
To Next Page
Loading...