Upgrade SQL Server 6.5 to SQL Server 2000.

[MrSatan]

Hi,

My boss has finally decided to upgrade the SQL 6.5 to SQL 2000, and he want a list of possible impacts that may happen to the 10 VB applications that currently use the database, these applications are written in VB 4/5/6.

I am not a database admin, and am a pure VB programmer, I only use the database to create stored procedures, access some system tables, update/insert/delete/retrieve the data in the tables via the VB applications.

I would like to know what need to be awared between the 2 version of SQL.

Any suggestion or direct to any reference will be appreciated.

Thanks in advance.

 

[JayKusch]

This link may help ...

http://www.microsoft.com/technet/tr...odtechnol/sql/deploy/upgrdmigrate/sqlugrd.asp

Thanks

J. Kusch

 

[MrSatan]

Hi Jay,

Thank you very much, the article is very useful. I am still reading through it to see if any of those changes are applied to me...

Cheers.