To check whether the secondary truncation point is set for a database, use the dbcc gettrunc command. For example, to see if the secondary truncation point is set in the Parts database, log in to the primary database and execute:
> use Parts > go > dbcc gettrunc > go
In the output that these commands generate, a “0” in the ltm_trunc_state column means the secondary truncation point is turned off for the database. A “1” in the ltm_trunc_state column indicates the secondary truncation point is turned on.