Posted by Erland Sommarskog on 01/03/07 22:27

Dan (dan_barber2003@hotmail.com) writes:
> Is is the varchar(max) that replaces text in SQL Server 2005?

Yes.

And to make it clear, text is still there but deprecated. You will
have to make an explicit change to the tables to use the new goodies.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: when to use fully qualified names ([database].[schema].object)
• Prev in forum: Re: Site Search Code Help
• Thread view: Re: Problem with Updatetext in SQL 2000 trying to concatenate multiple text fields

[Reply to this message]