Hi, there is a post on the same topic on the SQL2005 part of the forum, with the solution:

http://www.sqlservercentral.com/Forums/Topic747429-145-1.aspx

I can already give you an obvious one :

if you need to modify a common piece of information, which is - in a normalized database design - hold in a...

Grant Fritchey (2/13/2009)

---

And in SQL Server 2000, that is exactly a great solution for doing this. In SQL Server 2005/2008 though, you can take advantage of the MAX data type...

Hi,

I also use some dynamically written queries and also ran into the limit of the maximum string length (VarChar(8000)).

I solved it by cutting down the whole query in separate parts...