David Jackson

  • Interests: Geek stuff

Technical Article

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: )

734 reads

Technical Article

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: )

460 reads

Blogs

Generating Unicode Characters in Power Query

By

You may have used the UNICHAR() function in DAX to return Unicode characters in...

Daily Coping 29 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 28 Jun 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Create Multiple XML Files using SSIS

By Jobs90312

Hi community, I have a table in my database which consists of 100,000 rows....

Performance problem

By Jonas Jisendal

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

By Shashihemanth

Hi, I am having error in creating AG Group Listener. We finally try to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers