You can consider using data types like text or image they do not
constitute the limit of 8060.
Kanwar
-----Original Message-----
From: Rajendra Mohanty
[mailto:mssqldba-ezmlmshield-x59326533.[Email address protected]
Sent: Friday, October 29, 2004 10:50 PM
To: LazyDBA Discussion
Subject: Problem in Row Size
Hi Experts,
I have a table of 80 columns, from then one column length is
varchar(8000), but SQL server allow only 8060 character per row. I need
that column would be stored something around 8000 character. If store
8000 Character, I have only 60 character left for other column.
Does there any other way for this???
Thanks and regards,
Mohanty
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]
MS Sql Server LazyDBA home page