T-SQL statements from SQL 2000 not allowed in SQL 2005

• dsbolanos

  SSC Eights!

  Points: 830

  More actions

  July 16, 2008 at 1:45 pm

  #188195

  Hi guys

  I've got a question, what T-SQL Statements worked ins Sql 2000 that doesn't work in Sql 2005, we are actually migrating our sistemas and we want to know which statements to look for change such as Outer joins that sql 2005 wont allow like *=.

  Thanks for the info.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  July 16, 2008 at 1:56 pm

  #844047

  Look in BOL under deprecated features. This does not give a list of everything like *= outer joins because that is included under compatibility versions. You can also run the Microsoft SQL Server 2005 Upgrade Advisor as noted here.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• dsbolanos

  SSC Eights!

  Points: 830

  More actions

  July 16, 2008 at 1:57 pm

  #844048

  Thanks Jack I'll take a look.