Larry Brister
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
i.e dbo.spname
ASKER
kaufmed:...I am so sorry! I awarded to wrong person...you were first.
Do I need to request attention in this guys?
Do I need to request attention in this guys?
No, no need ;)
Yeah, you can get it changed by using request attention.
Yeah, you can get it changed by using request attention.
ASKER
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) 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 ; )
ASKER
Perfect...thanks