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

SQL Glitch with naming?

This is making me crazy...

Everytime I alter a procedure in SQL 2008R2 The procedure name is underlined with squigly red line and on mouseover...

"invalid object name...etc..."

Any ideas what this is?
screenprint.jpg
0
lrbrister
Asked:
lrbrister
  • 3
  • 2
  • 2
  • +3
1 Solution
 
anillucky31Commented:
Do not worry about this. This is sql 2008 intellisense problem. I also face the same issue but after sometime it will go away.
0
 
käµfm³d 👽Commented:
Press Ctrl-Shift-R after the Alter to refresh the Intellisense repository.
0
 
EvilPostItCommented:
If its a new procedure that has been created then it may be due to intellisense not being up to date.

You can refresh this by pressing CTRL+SHIFT+R
0
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
Alpesh PatelAssistant ConsultantCommented:
Due to it was created on different schema
0
 
kamindaCommented:
Full qualify your sp name with the schema

i.e dbo.spname
0
 
lrbristerAuthor Commented:
kaufmed:...I am so sorry!  I awarded to wrong person...you were first.

Do I need to request attention in this guys?
0
 
EvilPostItCommented:
No, no need ;)

Yeah, you can get it changed by using request attention.
0
 
lrbristerAuthor Commented:
I've requested attention folks.

I use EE extensively as a daily (and sometime hourly) resource and appreciate all EE Experts and their contributions.
0
 
käµfm³d 👽Commented:
I use EE extensively as a daily (and sometime hourly)
Hey! Me too!!!  Just on the other side of the board  ; )
0
 
lrbristerAuthor Commented:
Perfect...thanks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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