Script to audit schema changes

Last Post 26 Jun 2008 02:30 PM by jak8989. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
jpacbo
New Member
New Member

--
11 May 2008 08:20 PM
Hi Guys,
I was wondering if you were able to create a script that would audit schema changes in SQL Server 2000.

Thanks in advance,

Jiggerman..
jak8989
New Member
New Member

--
26 Jun 2008 02:30 PM
THere is a COM file, I think it's script.dll. It's the same COM objects that's run when you script out db objects in enterprise mgr or query analyzer. You can run this file from the command line with parameters for extra functionality. Run this from a job scheduler every night, for example, then compare the generated text file of db objects with a previous version to see if there have been any changes.
If I still had mssql on my laptop I would've been able to have given a better article but Google something like

script.dll "sql server"

and there will be a ton of articles about the .dll file and parameters that it accepts.
You are not authorized to post a reply.

Acceptable Use Policy