Post reply

can't run index tuning on a query

  • August 17, 2009 at 4:53 am

    #134867

    When running index tuning on following query an error occurs with a critical error message "An error occured trying to execute a SQL Statement"

    Query: Select Scheme_id, Company_urn from tblScheme

    has anyone come across anything like this?

    Thanks in advance.

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

  • August 18, 2009 at 4:01 am

    #1040714

    I would really appreciate any thoughts or ideas guys on this one.

    Vivek Shukla - MCTS SQL Server 2008

  • August 19, 2009 at 8:35 am

    #1041580

    The error sounds like the query can't be parsed. If you run the query in Query Analyzer does it return results? If so, please script the table and post it here.

  • August 19, 2009 at 2:17 pm

    #1041848

    Thanks for your reply danie.

    I have managed to resolve this issue.

    Index tuning wizard was unable to parase a query because some of the field in that table had special characters and apparently sql server 2000 index tuning wizard has problem with it (i've found out after doing some research).

    Thanks though. 🙂

    Vivek

    Vivek Shukla - MCTS SQL Server 2008

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply