If I write and test a program with MS SQL Server 7.0 how much must I then
change to use MS SQL 6.5 or 2K ?

Is it enough to change the connection string?

Regards,
 Morten M?ller

It depends on how you designed your application. If all
your SQL statements are placed inside stored procedures,
then probably you will not need to change anything in your
code except connection string. All you need to change is
SP on SQL server. If you build connection string
dynamically, then you even do not need to recompile your
application. If you are using SQL statements inside your
code, then probably you will need to change some SQL
statements, depending on syntax you are using. SQL code,
written in SQL 7.0 is fully compatible with SQL 2000, you
do not have to change it. Problem could be with 6.5.
probably you will need to rewrite some SQL statements

Val