use [#DBNAME#]
go

delete from [AttributeValues]
delete from [Attributes]

delete from [MachineBins]
delete from [MachineCards]
delete from [MachineSettings]
delete from [Machines]

delete from [Cards]
delete from [Jobs]
delete from [Vendors]
delete from [Products]
delete from [Users]

delete from [Reports]
delete from [ReportEmails]
delete from [EmailAddresses]

delete from [Security]
delete from [Transactions]
delete from [TransactionJobs]
go

dbcc checkident('[AttributeValues]',reseed,0)
dbcc checkident('[Attributes]',reseed,0)

dbcc checkident('[MachineBins]',reseed,0)
dbcc checkident('[MachineCards]',reseed,0)
dbcc checkident('[MachineSettings]',reseed,0)
dbcc checkident('[Machines]',reseed,0)

dbcc checkident('[Cards]',reseed,0)
dbcc checkident('[Jobs]',reseed,0)
dbcc checkident('[Vendors]',reseed,0)
dbcc checkident('[Products]',reseed,0)
dbcc checkident('[Users]',reseed,0)

dbcc checkident('[Reports]',reseed,0)
dbcc checkident('[ReportEmails]',reseed,0)
dbcc checkident('[EmailAddresses]',reseed,0)

dbcc checkident('[Security]',reseed,0)
dbcc checkident('[Transactions]',reseed,0)
dbcc checkident('[TransactionJobs]',reseed,0)
go
