hi

What is the logic behind it that maximum no of clustered index on any
table is 249?On Oct 23, 10:12 pm, vinod...@.gmail.com wrote:
> What is the logic behind it that maximum no of clustered index on any
> table is 249?
I'm assuming you are referring to either the 249 limit on maximum XML
indexes or the maximum non-clustered indexes. This link might be
helpful in explaining the reasoning behind the limit.
http://msdn2.microsoft.com/en-us/library/ms191497.aspx
Regards,
Enrique Martinez
Sr. Software Consultant