QA does not seem to recog. new Table in EM

[Taij]

I have created a new table in an existing DB. I have run a query from the table via EM, but when I try to do the same via QA, it does not seem to reccongize the table exists.

 

[JayKusch]

Can you post the table name as well as the query you are running in QA.

Thanks

J. Kusch

 

[Taij]

select firstname from test;

error msg:
Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'firstname'.

 

[tlbroadbent]

The error indicates the column name is incorrect rather than the table name. This question should be posted in forum183- Microsoft SQL Server: Programming instead of the DTS forum.

If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.comcast.net/sql/sql_articles.htm