title: How to check if a SQL script is compatible with sql server 2000
body: <p>I wrote a lot of scripts for SQL Server 2005, but now I have to rewrite those original scripts to make them work on SQL Server 2000.</p>
  
  <p>I don't remember all the differences between 2005 and 2000. For instance, <code>CTE</code> was announced only in 2005 - and I must rewrite these queries to work on SQL Server 2000.</p>
  
  <p>I need a way to check the syntax, while not having SQL Server 2000 at hand. Setting the compatibility level to 80 does not solve the issue - I get no warning, no errors.</p>
  
  <p><strong>Is there a tool to use for cheking the syntax of the scripts? Can it be done with SSMS 2008?</strong></p>