As long as the text is less than 8000 bytes you can use varchar
(nvarchar(4000)). For a size above this limit
you can use TEXT (2^31 - 1 (2.147.483.647) bytes or 2^30 - 1 (1.073.741.823)
bytes -->NTEXT.

But be aware that in some cases there are special stored procedures and
handling concerning (N)TEXT

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlpro03/html/sp03g8.asp


HTH, Jens Suessmeyer.

---
http://www.sqlserver2005.de
---


"Zoza" <Zoza@discussions.microsoft.com> schrieb im Newsbeitrag
news:9A2C0847-9D85-4690-BA7E-E92B5F44BD64@microsoft.com...
[quoted text, click to view]

I face a problem of how storing alarge text (such as text page)in a table of