James Greaves

  • Interests: Motorcycles, SQL Server

SQLServerCentral Article

Monitoring and Recording DDL changes on SQL 2005 (NARC)

Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.

4.52 (21)

You rated this post out of 5. Change rating


7,440 reads


SQL Prompt Quick Access to Helper Code


We’ve been doing some events as part of the Redgate Roadshow, and at one...

Eleven chapters of my data architecture book are available


As I have mentioned in prior blog posts, I have been writing a data...

Speaking at SQL Saturday Boston 2023


I’m happy to announce that I will be speaking at SQL Saturday Boston on...

Read the latest Blogs


I can query one by one. Need help how to become Single Query

By Adelia

Hi, This is my table and data, CREATE TABLE [dbo].[rpt_AR_StatementOfAcct_003]( [Id] [int] IDENTITY(1,1) NOT...

Baking up and restores VLDBs

By ericwenger1

Some of our databases are getting be close to 2 terabytes. We are backing...

Data Analysis with Python: Calculating Mean and Median

By Piyushbhatt

I'm working on a data analysis project in Python and need to calculate both...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers