Results 1 to 2 of 2

Thread: Full text index queries can not be executed as database is still in 6.5 mode.

  1. #1
    swati ringe Guest

    Full text index queries can not be executed as database is still in 6.5 mode.

    I had my database in 6.5 which i upgraded to 7.0 using SQL Server upgrade wizard.Then I created full text catalog. When I say incremental population It gives me warning that You can create full text indexes but can not execute queries against it as the database is still in SQL server 6.5 mode.What is the reason behind this?

  2. #2
    Craig Guest

    Full text index queries can not be executed as database is still in 6.5 mode. (reply)

    Your compatability mode is 6.5 after you upgrade wizard to 7.0.

    You can change it to 7.0 mode with the sp_dbcmptlevel.

    Read books online and test.........


    ------------
    swati ringe at 2/24/00 6:40:05 AM

    I had my database in 6.5 which i upgraded to 7.0 using SQL Server upgrade wizard.Then I created full text catalog. When I say incremental population It gives me warning that You can create full text indexes but can not execute queries against it as the database is still in SQL server 6.5 mode.What is the reason behind this?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •