USE [AIADatabaseV5] GO /****** Object: StoredProcedure [dbo].[ClearSessionManager] Script Date: 2/1/2018 12:15:55 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: -- Create date: <7/27/2017> -- Description: -- ============================================= if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClearSessionManager]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ClearSessionManager] GO CREATE PROCEDURE [dbo].[ClearSessionManager] -- Add the parameters for the stored procedure here @sSessionId VARCHAR(100) AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT OFF; -- Insert statements for procedure here DELETE FROM SessionManager Where sessionId = @sSessionId END GO