27 lines
788 B
Transact-SQL
27 lines
788 B
Transact-SQL
|
|
/****** Object: StoredProcedure [purgeData] ******/
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[purgeData]') AND OBJECTPROPERTY(id,N'IsProcedure') = 1)
|
|
DROP PROCEDURE [purgeData];
|
|
GO
|
|
|
|
CREATE PROCEDURE [dbo].[purgeData]
|
|
|
|
WITH EXECUTE AS OWNER
|
|
AS
|
|
BEGIN TRY -- Try Block
|
|
BEGIN TRANSACTION
|
|
delete from [Sessions]
|
|
dbcc checkident([Sessions],reseed,0)
|
|
IF( @@TRANCOUNT > 0 ) COMMIT
|
|
END TRY
|
|
BEGIN CATCH -- Catch Block
|
|
IF( @@TRANCOUNT = 1 ) ROLLBACK -- Only rollback if top level
|
|
ELSE IF( @@TRANCOUNT > 1 ) COMMIT -- Otherwise commit. Top level will rollback
|
|
EXEC vlnErrorHandler
|
|
END CATCH
|
|
GO
|
|
-- Display the status of Proc creation
|
|
IF (@@Error = 0) PRINT 'Procedure Creation: purgeData Succeeded'
|
|
ELSE PRINT 'Procedure Creation: purgeData Error on Creation'
|
|
GO
|