CHECKPOINT;
GO
CHECKPOINT; -- run twice to ensure file wrap-around
GO
DBCC SHRINKFILE('MyPage_log', 100); -- unit is set in MBs
GO

Delete From ParMassCreate 
delete  FROM Pel where CodSysPelTypos  = 1  AND COD <> 1000
delete  FROM Pel where CodSysPelTypos  = 2 AND  Cod NOT IN ( Select CodPEl from PelDataPromDef )
select max(cod)  from Pel
DBCC CHECKIDENT ("Pel" , RESEED, 11739)



SELECT  [name]  FROM SYS.OBJECTS WHERE TYPE_DESC='USER_TABLE' ANd NAme Like 'PelData%'
Delete From PelData
Delete From PelDataCheck
Delete From PelDataClient
Delete From PelDataDD
Delete From PelDataEMail
Delete From PelDataFile
Delete From PelDataHM
Delete From PelDataMonada
Delete From PelDataPhone
Delete From PelDataPhoto
Delete From PelDataPoso
Delete From PelDataProm
Delete From PelDataService
Delete From PelDataText
Delete From PelDataWWW
DBCC CHECKIDENT ("PelData" , RESEED, 1)
DBCC CHECKIDENT ("PelDataCheck" , RESEED, 1)
DBCC CHECKIDENT ("PelDataClient" , RESEED, 1)
DBCC CHECKIDENT ("PelDataDD" , RESEED, 1)
DBCC CHECKIDENT ("PelDataEMail" , RESEED, 1)
DBCC CHECKIDENT ("PelDataFile" , RESEED, 1)
DBCC CHECKIDENT ("PelDataHM" , RESEED, 1)
DBCC CHECKIDENT ("PelDataMonada" , RESEED, 1)
DBCC CHECKIDENT ("PelDataPhone" , RESEED, 1)
DBCC CHECKIDENT ("PelDataPhoto" , RESEED, 1)
DBCC CHECKIDENT ("PelDataPoso" , RESEED, 1)
DBCC CHECKIDENT ("PelDataProm" , RESEED, 1)
DBCC CHECKIDENT ("PelDataService" , RESEED, 1)
DBCC CHECKIDENT ("PelDataText" , RESEED, 1)
DBCC CHECKIDENT ("PelDataWWW" , RESEED, 1)


Delete From ParPelData
Delete From ParPelDataCheck
Delete From ParPelDataClient
Delete From ParPelDataDD
Delete From ParPelDataEMail
Delete From ParPelDataFile
Delete From ParPelDataHM
Delete From ParPelDataMonada
Delete From ParPelDataPhone
Delete From ParPelDataPhoto
Delete From ParPelDataPoso
Delete From ParPelDataProm
Delete From ParPelDataService
Delete From ParPelDataText
Delete From ParPelDataWWW
DBCC CHECKIDENT ("ParPelData" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataCheck" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataClient" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataDD" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataEMail" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataFile" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataHM" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataMonada" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataPhone" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataPhoto" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataPoso" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataProm" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataService" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataText" , RESEED, 1)
DBCC CHECKIDENT ("ParPelDataWWW" , RESEED, 1)

-- --------------------------------------------------------------------------------------------------------
Delete From Idos
Delete From IdosPartida
Delete From IdosPartidaDataCheck
Delete From IdosPartidaDataClient
Delete From IdosPartidaDataDD
Delete From IdosPartidaDataEMail
Delete From IdosPartidaDataFile
Delete From IdosPartidaDataHM
Delete From IdosPartidaDataMonada
Delete From IdosPartidaDataPhone
Delete From IdosPartidaDataPhoto
Delete From IdosPartidaDataPoso
Delete From IdosPartidaDataProm
Delete From IdosPartidaDataService
Delete From IdosPartidaDataText
Delete From IdosPartidaDataWWW

DBCC CHECKIDENT ("Idos" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartida" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataCheck" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataClient" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataDD" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataEMail" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataFile" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataHM" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataMonada" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataPhone" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataPhoto" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataPoso" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataProm" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataService" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataText" , RESEED, 1)
DBCC CHECKIDENT ("IdosPartidaDataWWW" , RESEED, 1)
-- ----------------------------------------------------------------------------------------



Delete From ParIdosPartidaDataCheck
Delete From ParIdosPartidaDataClient
Delete From ParIdosPartidaDataDD
Delete From ParIdosPartidaDataEMail
Delete From ParIdosPartidaDataFile
Delete From ParIdosPartidaDataHM
Delete From ParIdosPartidaDataMonada
Delete From ParIdosPartidaDataPhone
Delete From ParIdosPartidaDataPhoto
Delete From ParIdosPartidaDataPoso
Delete From ParIdosPartidaDataProm
Delete From ParIdosPartidaDataService
Delete From ParIdosPartidaDataText
Delete From ParIdosPartidaDataWWW
DBCC CHECKIDENT ("ParIdosPartida" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataCheck" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataClient" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataDD" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataEMail" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataFile" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataHM" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataMonada" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataPhone" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataPhoto" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataPoso" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataProm" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataService" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataText" , RESEED, 1)
DBCC CHECKIDENT ("ParIdosPartidaDataWWW" , RESEED, 1)

Delete From Idos 
DBCC CHECKIDENT ("Idos" , RESEED, 1)
Delete From IdosTypos 
DBCC CHECKIDENT ("IdosTypos" , RESEED, 1)
Delete From IdosPartidaTypos   
DBCC CHECKIDENT ("IdosPartidaTypos" , RESEED, 1)

Delete From Par
DBCC CHECKIDENT ("Par" , RESEED, 1)