Why does the new 'TOP' command in SQL 7 not work? I get a syntax error. Also ALTER TABLE and other SQL 7 only commands.

A. Usual reason for this is that the command only works on SQL 7 mode databases. If you have migrated an existing 6.5 database then it is probably still set to 6.5 compatibility mode. Use sp_dbcmptlevel to check and set it to SQL 7 mode.

Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.