Hi
I have created a Stored Procedure in SQL Server which is parsed and executed successfully but when I check it in Programmabilty-> Stored Procedures I cannot find it. After refreshing the whole database and also restarting SQL Server, the problem is occuring.
Help with a solution.
The Stored Procedure is
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Issues') AND type in (N'U'))
BEGIN
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'DeleteIssue') AND type in (N'P', N'PC'))
BEGIN
DROP PROCEDURE DeleteIssue
END
EXEC sp_executesql @statement = N'CREATE PROCEDURE DeleteIssue
(
@issueId INT
)
AS
BEGIN
DELETE
Go to the complete details ...