Link to home
Start Free TrialLog in
Avatar of Larry Brister
Larry BristerFlag for United States of America

asked on

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
Avatar of anillucky31
anillucky31
Flag of India image

Do not worry about this. This is sql 2008 intellisense problem. I also face the same issue but after sometime it will go away.
ASKER CERTIFIED SOLUTION
Avatar of kaufmed
kaufmed
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
Due to it was created on different schema
Full qualify your sp name with the schema

i.e dbo.spname
Avatar of Larry Brister

ASKER

kaufmed:...I am so sorry!  I awarded to wrong person...you were first.

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

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

I use EE extensively as a daily (and sometime hourly) resource and appreciate all EE Experts and their contributions.
I use EE extensively as a daily (and sometime hourly)
Hey! Me too!!!  Just on the other side of the board  ; )
Perfect...thanks