I'm trying to convert some of my table's field datatypes from text to varchar, and I was able to do some of them without a problem. But when I tried to finish the last of them, I received this error message:

'tblTABLENAME' table
- Unable to modify table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot create a row of size 8810 which is greater than the allowable maximum of 8060.
[Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

I did a count of the characters in the row that I attempted to convert, and the max char count is 2273. I was trying to change it to varchar(5000).

Any ideas on how I can get this to work would be GREATLY appreciated. Thanks.

KWilliams

Show us your statement.

I figured out how to fix it the other day. I simply lowered the length of a few of the larger columns, and I was able to complete the rest of the data type adjustments.

KWilliams

I guess it was this topic that put you in the right direction?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=108400

absolutely:) Thanks for the note peso.

KWilliams