i am vipul and i use this method to truncate all table from database. but constraint was not enabling by
Exec sp_MSforeachtable 'alter table ? check constraint all'
print 'all constraint enable'
MESSAGE WILL APPEAR THAT- 'all constraint enable'
BUT WHEN I CHECK THE DATABASE ALL CONSTRAINT DISABLE
SO WHAT I SHOULD DO ENABLE AGAIN ALL THE CONSTRAINT
VIPUL SACHAN