The total size of an index or primary key cannot exceed 256 bytes.

Message Text

The total size of an index or primary key cannot exceed 256 bytes.

Explanation

The sum of the lengths of all columns in an index cannot exceed 256 bytes. Changing to the specified datatype would exceed the maximum index size of <3d> bytes.

See Also
CREATE INDEX How to create an index using the Create Index Wizard (Enterprise Manager)
Creating an Index How to create an index when creating a table (Enterprise Manager)
Creating and Modifying Identifier Columns Index Object
Creating SQL Server Indexes Indexes
How to create an index on an existing table (Enterprise Manager) Table Indexes

 

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.