SQP SP

[DeepanKumarS (deepankumar soundrarajan)]

Hi All,

I written a SP for checking whether the database is available or not in SQL server.

My SP:-
USE [CAPEX]
GO
/****** Object: StoredProcedure [CPX].[sp_db_status] Script Date: 10/24/2018 8:42:35 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [CPX].[sp_db_status]
@DBName varchar(25),
@ReturnStatus int OUT
AS
BEGIN
SET NOCOUNT OFF

 --DECLARE @ReturnStatus int OUT

IF DB_ID(@DBName) IS NOT NULL
BEGIN
	SET @ReturnStatus = 1 -- TRUE
END
ELSE
BEGIN
	SET @ReturnStatus = 0 -- FALSE
END
RETURN	@ReturnStatus

END

always I am getting 0 on my output parameter.

Can you any one help me on this ASAP. Or give me the right solution

Note : I want to get what I am return.

many thanks in advance…