Problem Scenario 1:
I was attempting to create a Stored Procedure in my database. However, the SSMS intellisense does not recognize lot of the tables which exists in the database.
Problem Scenario 2:
While writing the select queries, the Intellisense does not work as expected and is not showing the DB Objects (say, Table names) in Query Analyzer Window
Solution:
Try:
Edit -> IntelliSense -> Refresh Local Cache
This should refresh the data cached by Intellisense to provide typeahead support and pre-execution error detection.
Note: Pressing Ctrl + Shift + R refreshes intellisense in management studio 2008 as well.
Once we create a new SQL Server object, the newly created object does not get updated in the IntelliSence Local Cache and due to this, it shows red line underneath that object. So we need to refresh SSMS IntelliSence Local Cache and once we refresh it,
IntelliSence
will automatically add newly created object in the cache and the red line will disappear.
Try this
Edit -> IntelliSense -> Refresh Local Cache
or
Ctrl + Shift + R
Ref URL: http://stackoverflow.com/questions/1362531/sql-server-invalid-object-name-but-tables-are-listed-in-ssms-tables-list
No comments:
Post a Comment