title: Max NVARCHAR length
body: <p>I am waiting a stored procedure that creates a script more than 4000 characters in SQL Server 2000. I am using <code>NVARCHAR (4000)</code> but when I use <code>NVARCHAR (MAX)</code> I am getting this error.  </p>
  
  <p>What type can I use for this …. ?</p>
  
  <blockquote>
    <p>Msg 170, Level 15, State 1, Procedure sp_Sxxxx, Line 19<br>
    Line 19: Incorrect syntax near 'MAX'.<br>
    Msg 137, Level 15, State 1, Procedure sp_ Sxxxx, Line 109<br>
    Must declare the variable '@ExecuteScript'.<br>
    Msg 137, Level 15, State 2, Procedure sp_ Sxxxx, Line 113<br>
    Must declare the variable '@ExecuteScript'.</p>
  </blockquote>