SQL Server 2005 Compatibility mode = 70

• David Kranes

  SSCrazy

  Points: 2523

  More actions

  March 4, 2008 at 7:54 am

  #179551

  Hello, I am in the process of upgrading a client database from SQL Server 7 to SQL Server 2005 and I have to use compatibility mode = 70. The reason being is our application has a lot of SQL within it that uses old SQL syntax like *=. My questions are as follows:

  1) If I set it to run in SQL Server 2005 mode will the old SQL syntax not work?

  2) What is the performance impact of running in compatibility mode=70? We do a lot of updates and inserts.

  Thank you.

  David

  Best Regards,

  ~David

• Kev Riley

  SSCrazy Eights

  Points: 9075

  More actions

  March 4, 2008 at 8:11 am

  #784976

  David,

  certainly the *= and =* operators are not supported in compatability level 90 (i.e SQL2005).

  As for performance, it should be no worse than a 'real' SQL Server 7.0 instance - although I would have to admit I've never tried it.