[ad_1]
I made a careless Mistake. I was actually concatenation my varchar variable with the ntext variable. As Ntext concatenation is not allowed, I got stuck.
[ad_2]
solved SQL Server 2000: Invalid operator for data type. Operator equals add, type equals ntext