yes,you can only create one clustered index on a table.

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN
SQL SERVER?

Question Posted / samrat sen

Answer Posted / samrat sen

Is This Answer Correct ?

10 Yes

12 No

Please Help Members By Posting Answers For Below Questions

Do you know spatial data types - geometry and geography in sql server 2008?

1004

What is 1nf normalization form?

1015

What is inline table-value user-defined function?

1089

Why is there a performance difference between two similar queries where one uses union and the other uses union all?

1014

What is nolock hint in sql server 2008

1106

What is star, snowflake and star flake schema? : sql server analysis services, ssas

1130

What are the different types of stored procedures?

1099

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1035

Why do we need different type of parameter?

1037

How to replace the Query Result 'Null Value' with a text ?

1012

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

960

Can we store videos inside the sql server table?

945

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

1239

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1017

How to perform key word search in tables?

947