WARNING when Adding a column on SQL server existing Table

[indyandumi]

After i run the sql which adds some columns on one particular table.I am getting this Warning

Warning: The table 'usac499_499A' has been created but its maximum row size (9033) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

I got a series of the above warning message , but the coulmn wa created.

[nosepicker]

SQL Server will only warn you if you create a table with column definitions exceeding 8060 bytes. It will still allow the table to be created. It is your responsibility to not actually insert enough data to exceed the 8060 byte limit.

[indyandumi]

So in other words that is a normal warning when you add an column to an existing table in SQL server???

[rmiao]

Yes, but you'll get error if data row has more than 8060 bytes.

[indyandumi]

is there any way of working around this, or sql server does not all the coulmns with more that 8066 bytes ??

[rmiao]

You can use text data type that can store 2g characters.

[jpendergraft]

You can use text data type that can store 2g characters.

FYI,
I use a dts package to import an excel sheet to a table. One of the columns in the table is of type Ntext. I have seen this several times when I load the file. The data sometimes needs to be reloaded because the column of type NText only stores part of the data.

[rmiao]

Ntext column can only store 1g characters.

[shahzadmasih]

Hi, this post is very informative; however I would like some specific information. If someone can help me then please send me a private message. Best Regards,

[nosepicker]

You can send a private message yourself to any one of us.

[rmiao]

Or just post your specific questions here.