Table too wide. 1

[oracleSQLdba]

We're getting the "exceeds the maximum numberof bytes per row (8060)." error in sql 2000.

Does anyone have any kb articles , whitepapers, something else from Microsoft which acknowledge the problem AND indicate it's ok to proceed?

The one article I've found from MSFT simply notes that inserts can fail.

I need a bit more than that for assurance for our environment.

 

[habneh]

I have tried the
order by left(col1, 100)
left(col2, 100)

it is not working for me either

 

[gmmastros]

[COLOR=blue]order[/color] [COLOR=blue]by[/color] [COLOR=#FF00FF]SubString[/color](col1, 1, 100)
         [COLOR=#FF00FF]SubString[/color](col2, 1, 100)

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom