Hi,
could u pls illustrate what is the use of creating index in Sql Server 2000? Is it used to create a unique key for each row in a table ? or is there any other special reason for that?

I tried an example by seeing help. the index is starting from 1. can't i start the index from my desired value like 1000?

The question what i am posting may be silly one, but really i don't know. please help me if u know it.

Thanks & regards,
raghunadhs