I tried it these ways;
SELECT INDEXPROPERTY(OBJECT_ID(SEPROPTEXT), tSEPROPTEXT, 'IsHypothetical')
Thanks for the link, but it's not really what I am looking for, when I try to defrag the "tSEPROPTEXT" index it gives me the following...
I'm new to the forum and SQL Server(2000), I have taken over a database and I have begun to schedule jobs to defrag our larger tables...
Separate names with a comma.