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.
solved SQL Server 2000: Invalid operator for data type. Operator equals add, type equals ntext