Is SQL Server 2005 db script compatible with sqlserver 2000

• karthikeyan-146504

  Ten Centuries

  Points: 1055

  More actions

  December 21, 2009 at 9:24 pm

  #141175

  Is SQL Server 2005 db script compatible with sqlserver 2000

  Thanks,

  ---

  Kindest Regards,

  karthik
  

• Pavel Pawlowski

  Ten Centuries

  Points: 1244

  More actions

  December 21, 2009 at 11:55 pm

  #1095254

  The script could be compatible. Depends whether or not you use syntax available only in SQL Server 2005.

  If yes, then it will not be compatible with SQL Server 2002.

  If you will not use the features of SQL Server 2005, but use only a syntax available in SQL 2000, then it will be compatible.