The datatype of column '<1s>' in the '<0s>' table can't be changed because it participates in index '<2s>'.

Message Text

The datatype of column '<1s>' in the '<0s>' table can't be changed because it participates in index '<2s>'.

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
Changing the Data Type Assigned to a Column Index Object
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 SQL Server Indexes Table Indexes
How to create an index on an existing table (Enterprise Manager)  

 

  


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