|
Returns whether or not you can maintain historical data for the specified database server property by storing its tracked values.
PROPERTY_IS_TRACKABLE( property-ID )
The PropNum of the database server property. You can find the PropNum of the database server property by running the sa_eng_properties system procedure or by calling the PROPERTY_NUMBER function.
1 if the database server property can be tracked; otherwise, returns 0.
Only database properties that return a numeric value can be tracked.
The following example returns all database server properties that are trackable:
SELECT PropName FROM sa_eng_properties( ) WHERE PROPERTY_IS_TRACKABLE( PropNum ) = 1;