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

how i can save byte array in database?

hi all
i have Byte Array like this:
dim Arr(388,8) as Byte
its working good in my application, but after i close my application all
data saved in this array is lost.
i need save all data from this array to Database (MDB or SQL), then after i
run application again i load data from Database to my Array Variable.
how i can do that?
its byte aray.
Best Regards
Tark M. Siala
Software Development
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
You can save these values in a Blob field
regards
Michel Posseth [MCP]
"Tark Siala" <tarksiala@.icc-libya.com> wrote in message
news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
> hi all
> i have Byte Array like this:
> dim Arr(388,8) as Byte
> its working good in my application, but after i close my application all
> data saved in this array is lost.
> i need save all data from this array to Database (MDB or SQL), then after
> i run application again i load data from Database to my Array Variable.
> how i can do that?
> its byte aray.
> --
> Best Regards
> Tark M. Siala
> Software Development
> INTERNATIONAL COMPUTER CENTER (ICC.Networking)
> Mobile: +218-91-3125900
> E-Mail: tarksiala@.icc-libya.com
> Messenger: tarksiala@.hotmail.com
> Web Page: http://www.icc-libya.com
> Blog: http://spaces.msn.com/tarksiala
> ======================================
>
|||hi
thanks
but i know how i can working with Blob to save Pictures, but how i can
working with Blob to save (Byte Array)?
Best Regards
Tark M. Siala
Development Manager
INTERNATIONAL COMPUTER CENTER (ICC.Networking)
Mobile: +218-91-3125900
E-Mail: tarksiala@.icc-libya.com
Messenger: tarksiala@.hotmail.com
Web Page: http://www.icc-libya.com
Blog: http://spaces.msn.com/tarksiala
======================================
"m.posseth" <michelp@.nohausystems.nl> wrote in message
news:uomlDeQQGHA.2012@.TK2MSFTNGP14.phx.gbl...
> You can save these values in a Blob field
> regards
> Michel Posseth [MCP]
>
>
>
> "Tark Siala" <tarksiala@.icc-libya.com> wrote in message
> news:O%23GSIoIQGHA.3872@.TK2MSFTNGP15.phx.gbl...
>

How generate documentation ?

Hi All
I need genrate documentation of SqlServer DB and I heard about programs
which let you genrate documentation including yours comments of fields,
tables etc. to chm file.
Do you know that program and how can I find it ?
Regards
MichalHello,
Please look at this product
AGS SQL Scribe Documentation Builder
www.ag-software.com
kind regards
Greg O
Need to document your databases. Use the first and still the best AGS SQL
Scribe
http://www.ag-software.com
"Michal" <michalb77@.gazeta.pl> wrote in message
news:dfovl8$3g1$1@.nemesis.news.tpi.pl...
> Hi All
> I need genrate documentation of SqlServer DB and I heard about programs
> which let you genrate documentation including yours comments of fields,
> tables etc. to chm file.
> Do you know that program and how can I find it ?
> Regards
> Michal
>
>|||Michal
Another SQL Server documentation tool that may be worth a look is ApexSQL
Doc (http://www.apexsql.com/sql_tools_doc.asp). The documentation is
produced in a searchable CHM (HTML Help Compiled Help File).
- Peter Ward
WARDY IT Solutions
"Michal" wrote:

> Hi All
> I need genrate documentation of SqlServer DB and I heard about programs
> which let you genrate documentation including yours comments of fields,
> tables etc. to chm file.
> Do you know that program and how can I find it ?
> Regards
> Michal
>
>
>|||From what I've seen, auto generated database documentation is of limited
use. By that, I mean that if it gives you a list of each object and what
objects are related to it, then it is really nothing that can't be seen
directly in Enterprise Manager or queried from Query Analyzer. Also, not all
databases use referentual integrity constraints, so the application cannot
determine how the objects are related. However, it may be useful for the
purpose of system metrics.
"Michal" <michalb77@.gazeta.pl> wrote in message
news:dfovl8$3g1$1@.nemesis.news.tpi.pl...
> Hi All
> I need genrate documentation of SqlServer DB and I heard about programs
> which let you genrate documentation including yours comments of fields,
> tables etc. to chm file.
> Do you know that program and how can I find it ?
> Regards
> Michal
>
>