SQL Server 7.0 to SQL Server 2000 Upgrade Question

SQL Server 7.0 to SQL Server 2000 Upgrade Question

Post by YWxhbl8yMD » Thu, 29 Sep 2005 08:09:01


Hello,
I am upgrading a database from SQL Server 7.0 to SQL Server 2000. I am
wondering if anyone can tell me what differences there are between T-SQL
commands in 2000 versus 7.0. I would like a list of the actual commands that
behave differently in 2000 versus 7.0.

Also, I'd be very interested to hear what differences one needs to
consider re. connectivity between these two versions, from a client
application (Windows VB 6.0 app.).

Thanks,
Alan
 
 
 

SQL Server 7.0 to SQL Server 2000 Upgrade Question

Post by Jerry Spiv » Thu, 29 Sep 2005 08:21:50

Alan,

Might check out:

http://www.yqcomputer.com/

and

'SQL Server 2000 and SQL Server version 7.0' and 'Relational Database
Enhancements' in the SQL Server Books Online.

HTH

Jerry