Query compatibility SQL server 2008/2000

I am developing some stored procedures in SQL Server 2008. Some of our customers are running SQL Server 2000.

Is there a way to check whether my queries are compatible without having to install SQL Server 2000? Maybe a tran开发者_如何学运维sact sql tester?

Regards,

Michel

You could set the compatibility mode to 80 but it's not guaranteed

I would also suggest installing MSDE at least to validate your code and performance.$

Or simply install full SQL Server 2000 to develop with.