Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Gordon Beeming,
This script is one that will be use primary after development before go live and will clean up all data in the database quicky and easily.
I ended up modifying the middle bit of this script to remove all users from our database that didn't meet certain requirements and because of the cascading it took all there details throughout the database with it =D