Hi Michaela,

Thanks for your reply.

I am need of how to create Clustered Index,What is their use and how to use them.

I already go through some online articles. In that, they have given

DBCC ind(@DBID, @TableID, -1).But i cant able to execute this query in Sqlserver2005.I am getting 'Could not find database 'dbid'. Check sys.databases.' error while executing this query.So I thought of this site to be the best help for me to know about Clustered Index Concept in Detail.Waiting for reply.

With Regards,

Poornima