We have some users who are nervous about our upgrading to SQL Server 7.0 even though we will use 6.5 compatibility mode initially while we work through 7.0 upgrade issues in the applications.

Has anyone had bad experiences with the 6.5 compatibility mode feature? Just how good is it?

Cheers

Matt