What are the challenges you face when working across database platforms? Take the survey

SQL 2000 and 6.5 compatible DBs?

MikeyCMikeyC Posts: 249 Bronze 3
edited July 2, 2007 2:13PM in SQL Prompt Previous Versions
I am evaluating SQL Prompt 3, and when connecting to a SQL 2000 server, and selecting a DB that is in 6.5 compatibility mode I get this error:

SQL Prompt could not retrieve the database schema:

<db name>

The database may no longer be present or a network connection could not be established.

Is the compatibility level the problem, or do you think it is something else?


  • Options
    Eddie DEddie D Posts: 1,792 Rose Gold 5

    Thank you for your post into the forum.

    Unfortunately SQL Prompt will not support a SQL Server 2000 database that is in 6.5 compatibility mode.

    Many Thanks

    Eddie Davis
    Red Gate Software Ltd
    Technical Support
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.