sp_thread_props

Description

Allows the client to retrieve and set various thread properties.

Syntax

sp_thread_props [ property_name [, property_value ]]

Parameters

property_name

is the name of the property to be set or shown.

property_value

is the value to which the property is to be set.

Usage

If you do not provide any parameters, or if you provide only property_name, the access service returns a single result set consisting of every instance of property_name and the value for each.