>I cost me a whole day but....
>
>The sp_helpindex returns data in the following format:
>
>varchar(128), varchar(210) and nvarchar(2078)
>
>The last one is unicode and quite long (I can't imaging why).
Indexes can be composite so the field needs to large enough to accomodate that.
*snip*
>
>Anyone know a better way?
See my other post.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao