Delete records in all related tables
Used to generate Select/Delete scripts. It does NOT run them.
You need to copy the output of this script to a new window and run it manually.
2008-08-06
548 reads
David Jackson
- Interests: Geek stuff
DB to VSS V2
This is an update/improved version of my script that I'm pleased to see is rated in the top 10! It will script off all of your objects in your database and if they differ from the scripted version in your VSS db, automatically check it in. If the object does not exist in VSS, this […]
2006-03-30 (first published: 2005-03-04)
734 reads
Check DB into VSS
I use this VBScript to get a DDL copy of all objects in my DB, and check them into SourceSafe if they have changed. I run it via Scheduled Tasks every night. Make sure unauthorised users have no access to the script location, as you need to enter the VSS password in it.
2004-08-04 (first published: 2004-05-20)
460 reads
Blogs
Generating Unicode Characters in Power Query
You may have used the UNICHAR() function in DAX to return Unicode characters in...
Daily Coping 29 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Daily Coping 28 Jun 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Create Multiple XML Files using SSIS
Hi community, I have a table in my database which consists of 100,000 rows....
Performance problem
Hi I have one server running SQL server 2017 and one running SQL server...
AOAG Listener Error:Kerberos Status is showing: Incorrect username and Password
Hi, I am having error in creating AG Group Listener. We finally try to...
Ask SSC