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 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.