how to increase maximum rowsize in sql server 2000

Is there any ways to increase the default maximum row size
of 8060 in SQL server 2000?
Thanks in advance
kiranNo you cannot.
You can however split your table into multiple tables and maintain
relationships between them.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"kiran kumar joseph" <kiran_joseph82@.yahoo.com> wrote in message
news:00f201c3aff4$742ea1c0$a001280a@.phx.gbl...
> Is there any ways to increase the default maximum row size
> of 8060 in SQL server 2000?
> Thanks in advance
> kiran|||Another option is to use text columns instead of varchars.
--
Andrew J. Kelly
SQL Server MVP
"SriSamp" <ssampath@.sct.co.in> wrote in message
news:uLq%23gd$rDHA.1996@.TK2MSFTNGP09.phx.gbl...
> No you cannot.
> You can however split your table into multiple tables and maintain
> relationships between them.
> --
> HTH,
> SriSamp
> Please reply to the whole group only!
> http://www32.brinkster.com/srisamp
> "kiran kumar joseph" <kiran_joseph82@.yahoo.com> wrote in message
> news:00f201c3aff4$742ea1c0$a001280a@.phx.gbl...
> > Is there any ways to increase the default maximum row size
> > of 8060 in SQL server 2000?
> >
> > Thanks in advance
> > kiran
>