I have created a simple procedure that will give me the table entries containing a similar keyword.
CREATE PROCEDURE resource_lookup @ProjectName nvarchar(100)=null
WHERE [Project Name] LIKE @ProjectName + '%'
DECLARE @return_value int
EXEC @return_value = [dbo].[resource_lookup]
@ProjectName = N'mutually'
SELECT 'Return Value' = @return_value
You don't specify an explicit schema in the
create so it creates it in your default schema which looks like it isn't dbo.
CREATE PROCEDURE dbo.resource_lookup @ProjectName nvarchar(100)=null AS /* ... */
To ensure it is created as desired.
But it sounds like this is an intellisense warning rather than a runtime error.
So use Ctrl+Shift+R to refresh the intellisense cache so it picks up your newly added object.
Or if that doesn't work (some SSMS addins hijack this combination) do it through the menu options
Edit -> IntelliSense -> Refresh Local Cache