• We just launched and are currently in beta. Join us as we build and grow the community.

Invalid object name in Stored Procedure Alter Command

esco458

Privilege Access Management Tester
Divine
E Rep
0
0
0
Rep
0
E Vouches
0
0
0
Vouches
0
Posts
118
Likes
96
Bits
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:

invalid_object_name.jpg

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.

 

452,292

323,341

323,350

Top