set ANSI_NULLS ON set QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[STPDeleteAll] AS begin try begin tran delete from dbo.InvoiceTbl delete from dbo.GoodColorTbl delete from dbo.GoodSizeTbl delete from dbo.StockTbl delete from dbo.stockGroup1Tbl delete from dbo.stockGroup2Tbl delete from dbo.WareHouseTbl delete from dbo.InvoiceCostTbl delete from dbo.DocLinkTBL delete from dbo.DocTbl delete from dbo.CodeMNGDWNTbl delete from dbo.CostGroup1Tbl delete from dbo.CostGroup2Tbl delete from dbo.PersonGroup1Tbl delete from dbo.PersonGroup2Tbl delete from dbo.DataBaseSettingTBL delete from dbo.DataLog delete from dbo.telbook delete from dbo.TelNumbers -- delete from dbo.Groups -- delete from dbo.users -- delete from dbo.UserDefaultGridLayoutTbl -- delete from dbo.UserDefaultPrintLayoutTbl delete from CodeMNGUPTbl where accountsyscode0>=100 if @@error =0 commit tran end try begin catch rollback tran DECLARE @ErrorMessage NVARCHAR(4000); DECLARE @ErrorSeverity INT; DECLARE @ErrorState INT; SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(), @ErrorState = ERROR_STATE(); RAISERROR (@ErrorMessage, -- Message text. @ErrorSeverity, -- Severity. @ErrorState -- State. ); end catch