Re: Logging changes to the data schema

From: Ray Higdon (rayhigdon_at_higdonconsulting.com)
Date: 12/31/03

Next message: Nancy Kafer: "SQL Server Role Security"
Previous message: kilo: "Re: Trusted SQL Connection. Try everything but nothing works!!!"
In reply to: Dan: "Logging changes to the data schema"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Date: Wed, 31 Dec 2003 05:47:42 -0500

Depending on what type of changes you are wanting to track, you might use
triggers or SQL Profiler. There is also a third party tool by Lumigent
called Entegra that tracks DML and DDL changes.

HTH

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"Dan" <dslaby@NoSpam.evergreeninfo.biz> wrote in message
news:uK4sp9zzDHA.832@TK2MSFTNGP09.phx.gbl...
> How would I use sqlAgent to log changes to the data schema?
>
> Thanks.
>
> Dan
>
>

Next message: Nancy Kafer: "SQL Server Role Security"
Previous message: kilo: "Re: Trusted SQL Connection. Try everything but nothing works!!!"
In reply to: Dan: "Logging changes to the data schema"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]