sp_sqlgetinfo  Appendix A: Configuration Quick Reference

Chapter 12: Retrieving Information with System Procedures

sp_thread_props

Description

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





Copyright © 2005. Sybase Inc. All rights reserved. Appendix A: Configuration Quick Reference

View this book as PDF