If you try to truncate a table that is referenced by foreign key you usually get the following error:
Cannot truncate table 'TableName' because it is being referenced by a FOREIGN KEY constraint.
To avoid this error the easiest way to use DELETE without where clause and RESEED the identity:
DELETE FROM AccVoucher
DBCC CHECKIDENT (AccVoucher, RESEED, 0)
Spend less time CD'ing around directories with the PowerShell Z shortcut - Everyone has a trick for moving around their computer faster. It might be a favorite shell, a series of aliases or shortcuts. I like using popd and pushd...
2 days ago