CODEWITHSUNDEEP
t-sqlsql-server-2008sql-server-2000
Michel van Engelen
Michel van Engelen

Reputation: 2879

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 transact sql tester?

Regards,

Michel

Upvotes: 1

Views: 362

Answers (1)

gbn
gbn

Reputation: 432180

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.

Upvotes: 2

Related Questions