SQL Server Performance

SQL Server shows some tables as unknown when i refernece them

Discussion in 'SQL Server 2008 General DBA Questions' started by AMOURGH, Feb 28, 2009.

  1. AMOURGH Member

    Hello everybody,
    To make a change in a stored proc , i opened its script and at that time i created a new table in my DB and fill it.
    but when i reference that new table ,SQL Server 2008 points out "invalid object name" with a red line under the referncing script.
    What' s bizzard is:the procedure script compiles well and executes well.
    Any idea?
    thanks in advance.
  2. madhuottapalam New Member

    Check the Object's (new table) Owner(Schema). Also if your DB is case-sensitive, you will have to provide the name with proper case
    Madhu
  3. AMOURGH Member

    After i disconnected from the instance and connected after,i dont see the pb anaymore.
    Thanks.

Share This Page