Home Forums SQL Server 2005 SQL Server 2005 General Discussion List of SQL 2005 features incompatible with level 80? RE: List of SQL 2005 features incompatible with level 80?

  • January 28, 2008 at 1:19 am

    #772288

    One important thing (which is documented in BOL) is that the "WITH" keyword for table and index hints is NOT optional in mode 90. The script generated by Enterprise Manager in SQL 2000 for table changes likes to omit the WITH keyword. 🙁