T-SQL script to purge all the tables including foreign key references. The script has been made smart enough to use TRUNCATE wherever there is no foreign key reference and to use DELETE wherever there is foreign key reference.
2019-12-10
1,725 reads
By Steve Jones
A customer recently was concerned about the time to run SQL Compare for a...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Arun Sirpal
On the theme of failover groups let’s do a quick recap on my environment....
Comments posted to this topic are about the item Tracking, Privacy, and Lots of...
We are having an issue applying CU24 patches on SQL 2017. The version of...
I work on sql server 2012 I don't understand condition below do this condition...
Ask SSC