esco458
Privilege Access Management Tester
Divine
2
MONTHS
2 2 MONTHS OF SERVICE
LEVEL 1
500 XP
If you are working with stored procedure using SQL Server Management Studio Tools (SSMS), you will encounter a problem (well, not really a problem) “Invalid object name” on the name of your stored procedure.
Please see screenshot below:
This error is not made by SQL Server but rather by SSMS. The solution to this problem is to clear the intelliSense cache. Click on Edit menu => IntelliSense => Refresh Local Cache or press Ctrl + Shift + R at the same time.
Please see screenshot below:

This error is not made by SQL Server but rather by SSMS. The solution to this problem is to clear the intelliSense cache. Click on Edit menu => IntelliSense => Refresh Local Cache or press Ctrl + Shift + R at the same time.