9d6043c5   
   From: hugo@perFact.REMOVETHIS.info.INVALID   
      
   Hi JAW,   
      
   The error message tells you what the problem is. The parameter for   
   sp_executesql that holds the statement should be of type   
   ntext/nchar/nvarchar. You have declared it as varchar. Change that to   
   nvarchar (and ditto for the parameter that holds the parameter list)   
   and it will work.   
   --   
   Hugo Kornelis, SQL Server MVP   
   My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)