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