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

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

462 reads

Blogs

Errata for my book: Pro Encryption in SQL Server 2022

By

My biggest fear when my book went into production was that any factual errors...

SQL Server Quickie #45 – SQL Server Availability Groups

By

Today I have uploaded SQL Server Quickie #45 to YouTube. This time I’m talking...

Daily Coping 21 Mar 2023

By

Today’s coping tip is to listen to a piece of music without doing anything...

Read the latest Blogs

Forums

Cloud Diagrams

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Diagrams

How much RAM in an Azure Database on Pay As You Go

By Weegee71

Ive been doing some benchmark testing using an application, running this on my local...

Data Problem

By immad

This is the Data ID ----- Date From ------   Date To    ------- 2 ...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Cloud Diagrams

See possible answers