Auditing DDL Changes in SQL Server databases

Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when it happens. With suitable scripting, you can even do it if you don't have direct access to the live database. Grant shows how easy this is with SQL Compare.

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Execute DDL Task

The term DDL designates Data Definition Language, which implies an action involving creating data structures. In the context of Analysis Services Execute DDL Task, this is a bit of a misnomer because its capabilities are much more diverse, extending to such areas as backups, restores, deletions, modifications, or processing. This is accomplished by employing Analysis Services Scripting Language (ASSL).

Update 2 databases with 1 script

This script will allow you to update 2 databases with the same names, but different schemas/software/database versions.

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.

DDL Rollback

Auditing with SQL Profiler

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.

Drop Column

Drop Column after checking regular constraints and dropping these constraints

Create Role for specific set of Objects based on a set of Conditions.

This script is for the Generating a code block that makes it easier to grant various permissions on a group of objects qualified by specific Criteria.

RE: special situation... full text search for anything?

Not exactly sure about your question, but : SELECT fulltextcatalogproperty('Catalogue_name', 'PopulateCompletionAge')  Returns the difference in seconds between the completion of the last full-text index population and 01/01/1990 00:00:00. This can be manipulted according to the requirement.

RE: Trouble with Subscriptions

I posted my message a little too soon.  I did a little more browsing through the forum and found that Reg Mayfield posted on 8-4-2004 a problem similar to mine.  Reg Mayfield also discovered the proper FIX from microsoft for this problem.  Thanks for the information.