SQL Server Performance Forum – Threads Archive
running SQL 2005 script on Sql 2000Hi guys, i got some syntax error when running a sql 2005 generated script on Sql 2000 is there a way to have the script backward compatible thanks AKTHAR
Look at BOL 2k5 for sp_dbcmptlevel stored procedure where you set the backwards compatibility level. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.
You can also run the Upgrade Advisor tool included with 2005 to indentify the incompatable code so that it can be corrected to run properly under 2005 natively. See BOL for more info on the Upgrade Advisor. —————————–
Brad M. McGehee, SQL Server MVP