Allows the client to retrieve and set various thread properties.
sp_thread_props [ property_name [, property_value ]]
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.
If you do not provide any parameters, or if you provide only property_name, the server returns a single result set consisting of every instance of property_name and the value for each.
