>I have a memo field for inventory item description information and
>need to save it in SQL Server.
>
>What data type/length should I use in SQL Server ????
>
>Any other ideas, I must have at least enough space for 2 or 3 pages
>of information for each item--so all I can think of using is a memo.
>
>Thanks in advance !!!!!

You use a Text datatype, but its a real space hog. Each non NULL value takes at least one 2K page. Plus you must initialize a text column. The Transact SQL Reference has a pretty good section on the Text datatype.


HTH.