I'm probably missing something, but according to our T-Sql manual, the status of column of the sysindexes table should have the following values with the following meanings:
1 = Cancel command if attempt to insert
duplicate key.
2 = Unique index.
4 = Cancel command if attempt to insert
duplicate row.
16 = Clustered index.
64 = Index allows duplicate rows.
2048 = Index used to enforce PRIMARY KEY
constraint.
4096 = Index used to enforce UNIQUE constraint
Instead I see values like 18,2113554,16402. Please, how do I interpet these values? 18 could be the addion of 16 and 2. but what the heck produces 2113554?
Thanks
Thanks
Gar W. Lipow