How increasing maximum allowed (4000)

Hi All
i Have Var Type nvarchar in my TRIGGER
The maximum allowed (4000) i need (8000) or more
How can i do this
ThanksI just learned that you could try nvarchar(MAX) and than insert your data
using the ntext declaration. I know this can be done in SQL 2005 not sure
about SQL 2000. Else you could just use ntext in the database too.
-Mark
"Taha" <taha105@.hotmail.com> wrote in message
news:eKYGcsb6FHA.2384@.TK2MSFTNGP12.phx.gbl...
> Hi All
> i Have Var Type nvarchar in my TRIGGER
> The maximum allowed (4000) i need (8000) or more
> How can i do this
> Thanks
>
>|||Note that you cannot declare variables of type (N)TEXT in SQL Server 2000.
If you need access to more characters than declare two variables of type
NVARCHAR(4000) and perform your operations.
--
HTH,
SriSamp
Email: srisamp@.gmail.com
Blog: http://blogs.sqlxml.org/srinivassampath
URL: http://www32.brinkster.com/srisamp
"Mark Nijhof" <Mark@.Nijhof.com> wrote in message
news:%23kgux2b6FHA.1420@.TK2MSFTNGP09.phx.gbl...
>I just learned that you could try nvarchar(MAX) and than insert your data
>using the ntext declaration. I know this can be done in SQL 2005 not sure
>about SQL 2000. Else you could just use ntext in the database too.
> -Mark
> "Taha" <taha105@.hotmail.com> wrote in message
> news:eKYGcsb6FHA.2384@.TK2MSFTNGP12.phx.gbl...
>|||Thank you for reply
i use SQL 2000. and when i try your id i get this message
"The text, ntext, and image data types are invalid for local variables."
i thenk dosnot work
any id
thanks
"Mark Nijhof" <Mark@.Nijhof.com> wrote in message
news:%23kgux2b6FHA.1420@.TK2MSFTNGP09.phx.gbl...
>I just learned that you could try nvarchar(MAX) and than insert your data
>using the ntext declaration. I know this can be done in SQL 2005 not sure
>about SQL 2000. Else you could just use ntext in the database too.
> -Mark
> "Taha" <taha105@.hotmail.com> wrote in message
> news:eKYGcsb6FHA.2384@.TK2MSFTNGP12.phx.gbl...
>|||NVarChar is the unicode (2 bytes per char) version of the VarChar (1 byte
per char) data type. If you don't need unicode support, then VarChar
supports a maximum of 8000 chars.
"Taha" <taha105@.hotmail.com> wrote in message
news:eKYGcsb6FHA.2384@.TK2MSFTNGP12.phx.gbl...
> Hi All
> i Have Var Type nvarchar in my TRIGGER
> The maximum allowed (4000) i need (8000) or more
> How can i do this
> Thanks
>
>