Allows the client to retrieve and set various thread properties.
sp_thread_props [ property_name [, property_value ]]
is the name of the property to be set or shown.
is the value to which the property is to be set.
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.