ChrisM@Work (8/12/2013)
"Text, Ntext, and Image data types are invalid for local variables." is misleading:
In such case you should file a Connect bug on message 2739. Although I don't really understand what is misleading - you cannot declare local variables of this type, only parameter. (And such parameters are readonly.)
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]