kwilliams Posted August 8, 2008 Share Posted August 8, 2008 I'm trying to convert some of my table's field datatypes from text to varchar within SQL Server 2000 Enterprise Manager, 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] 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. Link to comment Share on other sites More sharing options...
jesh Posted August 8, 2008 Share Posted August 8, 2008 Looks like this person had the same problem as you:http://www.eggheadcafe.com/software/aspnet...-row-of-si.aspx Link to comment Share on other sites More sharing options...
kwilliams Posted August 14, 2008 Author Share Posted August 14, 2008 Looks like this person had the same problem as you:http://www.eggheadcafe.com/software/aspnet...-row-of-si.aspx Hi Jesh,Thanks for helping me to solve the problem. 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.