[dba-SQLServer]index limits

Wow... thanks Franciso -- 249? I'm wondering if this holds for an Access
project -- I mean the tables are SQL Server, right? Rabbit wants to know if
rootbeer has vitamin A? :)

Susan H.


> Each table can have as many as 249 nonclustered indexes (regardless of how
> they are created: implicitly with PRIMARY KEY and UNIQUE constraints, or
> explicitly with CREATE INDEX). Each index can provide access to the data
in
> a different sort order.