I've noticed that 'Text' is not included in the DDT when designing a Table Structure. When dealing with SQL 2000 Varchar(MAX) is limited to 8000 chars while text is limited to 2 gigs unlike the new SQL 2005...



I am just curious if there is an implemented difference in the DDT or if it's assumed that varchar(max) is the same as 2005's implementation which means it's ok to use that instead of Text since 2005 supports 2 gigs with varchar(max)





...Corporate Budgets should not get in the way of upgrading our toys

Open up the Profile properties and allow deprecated data types to be shown.  The reason Text is considered deprecated is because the next version of SQL Server will not have it, so we went ahead and considered it deprecated.  Also, if you create a field as a VarChar(MAX) and deploy to a SQL Server 2000 box it will automatically convert the type to Text.

Perfect, Thanks for your help.