Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do you check if full text change tracking is on?
- Thread starter vnad
- Start date
- Thread starter
- #2
Found it
SELECT OBJECTPROPERTY (<object_id>,'TableFulltextChangeTrackingOn')
SELECT OBJECTPROPERTY (<object_id>,'TableFulltextBackgroundUpdateIndexOn')
You can find the object ids from the sysobjects table. If the query returns a 1, that means it is on, a 0 means it is off.
SELECT OBJECTPROPERTY (<object_id>,'TableFulltextChangeTrackingOn')
SELECT OBJECTPROPERTY (<object_id>,'TableFulltextBackgroundUpdateIndexOn')
You can find the object ids from the sysobjects table. If the query returns a 1, that means it is on, a 0 means it is off.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question