|
|
Posted by Helmut Woess on 06/06/06 19:42
Am 6 Jun 2006 10:46:41 -0700 schrieb RamaKrishna Narla:
> In MS SQL Server, while creating the table, I am getting a warning
> message saying like "maximum row size can exceed allowed maximum size
> of 8060 bytes".
>
> Is there any way in SQL Server, to increase this allowed maximum row
> size?
The perfect solution would be changing to SQL Server 2005 (or SQLExpress).
There is a new datatype called VARCHAR(MAX) which can grow up till 2 Gb!
I would avoid TEXT for strings in any case. Read BOL to see which functions
do not work with TEXT, how to change TEXT (you need pointers!), ...
bye, Helmut
Navigation:
[Reply to this message]
|