Click here to Skip to main content
15,887,371 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am trying to add a new stored procedure inside the
MyDb\Programmability\StoredProcedure folder

i have added successfully and it is executed
then i try to open that storedprocedure
i got the error as

"Invalid object name dbo.WarrantCertificate"

What I have tried:

USE [MyDb]
GO
/****** Object:  StoredProcedure [dbo].[WarrantCertificate]    Script Date: 18-04-2021 23:16:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[WarrantCertificate]
as
SELECT AssetNo FROM dbo.CalibrationCertificate
Posted
Updated 8-Apr-22 0:16am

1 solution

You need to refresh the Intellisense cache, the procedure isn't in it yet.
Close SSMS and reopen, or press CTRL+SHIFT+R to refresh it.

The command will run fine even if you don't as Intellisense errors don't affect the actual DB.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900