How to use text in row option?

I have to store in some cases more than the 8000 character limit. And i have
read about the text in row option. Seems like that will do what i need. But
i dont really get how i enable it. I have searched google and google groups
for some idea as how to enable it - and all i find is EXEC sp_tableoption
'orders', 'text in row', 'ON'
Can some one explain in step wise fachion how to enable it? Where do i run
this? Thx
AshokHi
See
http://msdn.microsoft.com/library/d...>
_04_0x5t.asp
on how to enable it and when it should be used.
John
"Showjumper" <sdfhk@.kjsdfk.com> wrote in message
news:eIVBb8XLFHA.576@.TK2MSFTNGP15.phx.gbl...
>I have to store in some cases more than the 8000 character limit. And i
>have read about the text in row option. Seems like that will do what i
>need. But i dont really get how i enable it. I have searched google and
>google groups for some idea as how to enable it - and all i find is EXEC
>sp_tableoption 'orders', 'text in row', 'ON'
> Can some one explain in step wise fachion how to enable it? Where do i
> run this? Thx
> Ashok
>|||Hi
If you need to store text that is bigger than 8000, use the text or ntext
data type. These 2 support data up to 2Gb in size. sp_tableoption is only
for advanced tuning when the text is really small (say less than 4000) and
it, plus the other data in the row all fit into 8060 bytes, the row size.
Look up text and ntext data types in BOL as then you incur certain
limitations (BOL Index: 'ntext data type')
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Showjumper" <sdfhk@.kjsdfk.com> wrote in message
news:eIVBb8XLFHA.576@.TK2MSFTNGP15.phx.gbl...
> I have to store in some cases more than the 8000 character limit. And i
have
> read about the text in row option. Seems like that will do what i need.
But
> i dont really get how i enable it. I have searched google and google
groups
> for some idea as how to enable it - and all i find is EXEC sp_tableoption
> 'orders', 'text in row', 'ON'
> Can some one explain in step wise fachion how to enable it? Where do i
run
> this? Thx
> Ashok
>
>