The SQL syntax has been verified against the data source

Posted on 2008-11-19
Last Modified: 2012-05-05
In order to edit result panel in SQL 2005 I have been run a query by
1: From the Object Explorer, I expand the database containing the AllIndividuals table
2. expand the tables folder
3. right-click on the table
4. select Open table
5.  then click on the SQL Pane icon.

It works all the time. However, today when I click on the SQL pane icone, it shows me this message
"The SQL syntax has been verified against the data source". what's wrong?


Question by:whttc
    LVL 17

    Expert Comment

    That is the correct response from the SQL Syntax Icon.
    LVL 17

    Expert Comment

    Are you trying to open a query?
    LVL 17

    Accepted Solution

    Click on the WHITE box with the words SQL in it to open a query, not the YELLOW.

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now