What are the specific errors that you're seeing?

-Mike

>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