Chirag (3/20/2009)
In BOL under Creating Indexes (Database Engine) section its mentioned that there can be 249 non clustered indexes per table.But In BOL under Create table sections its mentiond 999 😉
In that case BOL has a bug:-D
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/