stored procedure

Invalid object name in Stored Procedure Alter Command

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 =>