• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1254
  • Last Modified:

The SQL syntax has been verified against the data source

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?

Thanks,
wanshu

0
whttc
Asked:
whttc
  • 3
1 Solution
 
HoggZillaCommented:
That is the correct response from the SQL Syntax Icon.
0
 
HoggZillaCommented:
Are you trying to open a query?
syntax-tools.bmp
syntax-icon-msgbox.bmp
0
 
HoggZillaCommented:
Click on the WHITE box with the words SQL in it to open a query, not the YELLOW.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now