Thanks,

Yes, when I enabling a table for 'text in a row' on some error comes, can you please advice.

Command : EXEC sp_tableoption 'orders', 'text in row', '1000'


Error :

Server: Msg 2591, Level 16, State 90, Procedure sp_tableoption, Line 79
Could not find row in sysindexes with index ID 255 for table 'Orders'.

Thanks and regards,
Mohanty

-----Original Message-----
From: Singh Kanwar
[mailto:mssqldba-ezmlmshield-x30938359.[Email address protected]
Sent: Saturday, October 30, 2004 10:30 AM
To: LazyDBA Discussion
Subject: RE: Problem in Row Size


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]



---------------------------------------------------------------------
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