title: Can't use LONG data type
body: <p>I'm trying to get some legacy SQL 2005 code to work on SQL 2012 Express.  However, whenever I set the <a href="http://msdn.microsoft.com/en-us/library/bb510680.aspx" rel="noreferrer"><code>compatibility_level</code> to 90</a>, I error out when I try to use older data types.  In theory the following code should work:</p>
  
  <pre><code>USE wsus_results
  GO
  
  ALTER DATABASE wsus_results
  SET compatibility_level = 90
  GO
  
  CREATE TABLE ScTable (
   TblName VARCHAR(255) NULL,
   TblType VARCHAR(255) NULL, 
   FieldCnt INTEGER NULL,
   RecordCnt LONG NULL,
   Description LONGVARCHAR NULL,
   TblId AUTOINCREMENT PRIMARY KEY)
  GO
  </code></pre>
  
  <p>But, I get the following error:</p>
  
  <blockquote>
    <p>Msg 2715, Level 16, State 6, Line 2 Column, parameter, or variable #4:
    Cannot find data type LONG.</p>
  </blockquote>
  
  <p>I'm sure there's something simple I'm missing, and I just need a nudge in the right direction.  This isn't a permission issue and as far as I can tell, the <code>SET compatibility_level = 90</code> executes fine with no errors. Still, I get an error when using <code>LONG</code>.</p>