Hi Mike,

I ran sp_dbcmptlevel [realtestcatcboe], 65 and
sp_dbcmptlevel [realtestcatcboe], 65 and when I looked at the SQL Scripts the procedures generated, I didn't notice a big difference.

Is there anything else I should have done.

Thanks
Jim
>7.0 has some features that are implemented in 6.5. For instance, LEN() was added to 6.5 in a service pack. TOP is not support by 6.5.
>
>SQL Server 7.0 support a database compatibility option. Set it to 6.5 and see what happens on the 7.0 box when you run the scripts.
>
>-Mike