How come a stored procedure is displayed with a squiggly line saying invalid object name even though it exists.

Posted on 2011-10-26
Last Modified: 2012-05-12
Hello Experts,
I have some SP,s that display with a squiggly line under the nmae saying it is an invalid object even though it is valid and does work fine.  The same happens with some colum name references.  Some have a squiggly line under and say 'invalid column name'.  Is there a place in the master database where all stored procedures in other databases are stored.

Question by:katzhoward
    LVL 29

    Accepted Solution

    Use CTRL-SHIFT-Are to refresh the intellisense  cache or from the menu edit > Intellisense > Refresh  local cache

    Author Closing Comment

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now