Mike,

My guess is that the Upsizing Wizard tries to change the database's compatibility level to 65 (for SQL Server 6.5 compatibility). You probably don't have permission to do this. Ask your system admin to do it for you. If he or she doesn't know how, tell him or her to use the sp_dbcmptlevel stored procedure.

>I have designed and tested a VFP 6.0 application prototype using local views. Just for my own learning experience I wanted to upsize the project to SQL Server. My system's administrator imported the VFP database to the server using SQL Server 7.0. We created a connection to the database and tested the connection. I tried to run the Upsizing Wizard and got to Step 5 - Select Target Database. Since the database was already there the Wizard identified it and "Existing" was checked. When I click Next, a message box pops up which reads, "The Upsizing Wizard could not set the SQL Server 7.0 database to proper compatibility level for upsizing.” The only option I am given is to click on Ok.
>
>Any ideas and suggestions would be greatly appreciated.
>
>Thanks,