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