Index properties

Hi group.
Where can i find in the system tables of the SQL 2000, all the propreties of
an index. For example, if a create an index unique but not constraint and
'Ignore duplicate key' checked?. Where the SQL 2000 store this information?
Thanks
Nuno Teixeira
PortugalLook at the system function INDEXPROPERTY in Books Online.
"Nuno Teixeira" <NunoTeixeira@.discussions.microsoft.com> wrote in message
news:0A1884EE-1B7D-460C-B6AC-6F0582A5B7E7@.microsoft.com...
> Hi group.
> Where can i find in the system tables of the SQL 2000, all the propreties
> of
> an index. For example, if a create an index unique but not constraint and
> 'Ignore duplicate key' checked?. Where the SQL 2000 store this
> information?
> Thanks
> Nuno Teixeira
> Portugal|||See if this helps:
http://www.microsoft.com/communitie...7d47&sloc=en-us
AMB
"Nuno Teixeira" wrote:

> Hi group.
> Where can i find in the system tables of the SQL 2000, all the propreties
of
> an index. For example, if a create an index unique but not constraint and
> 'Ignore duplicate key' checked?. Where the SQL 2000 store this information
?
> Thanks
> Nuno Teixeira
> Portugal|||Forget this.
AMB
"Alejandro Mesa" wrote:
> See if this helps:
> http://www.microsoft.com/communitie...7d47&sloc=en-us
>
> AMB
> "Nuno Teixeira" wrote:
>|||Maybe this can help:
http://milambda.blogspot.com/2005/0...-with-kick.html
ML