SQLLog is a server-side, audit trail software package that tracks and logs
changes to data in Microsoft SQL-Server 7/2000 databases. Whenever a record
inserted, updated, or deleted, SQLLog records it and stores the original and
new values as well as the username, timestamp, and application that made the
SQLLog adds complete audit trail capability to any Microsoft SQL-Server
database. It lets you concentrate on the data model and functionality
instead of the boring chore of audit trail code.
Best of all... it is FREEWARE!
> I know nothing about the following product other than their adverti*t,
> but it might be worth a look ...
> BP Margolin
> Please reply only to the newsgroups.
> When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
> can be cut and pasted into Query Analyzer is appreciated.
> > Thanks for the info. I was hoping for a transaction level audit of
> > changes, but I guess that's pushing it a little.
> > > Tom,
> > > Well just got around to installing the final release of SQL 2000 today
> > > while looking in the Server Properties window I did notice the option
> > > audit logins. You could select between success/failure/all. I haven't
> > worked
> > > with it yet but I know it is there.
> > > --
> > > Shawn Clark
> > > Senior Software Consultant
> > > Meridian Technology Group
> > > > I am interested in finding more information about the SQL Server
> > > Audit
> > > > Trail features. I searched the Microsoft web site, MSDN, the online
> > > > concierge, the support webcast transcript, the SQL Server
> > and
> > > > Microsoft Sales, but no one could provide any information.
> > > > From the transcript at
> > > > this was stated:
> > > > Reinaldo: SQL Server 7.0 does not have an audit trail, but SQL
> > 2000
> > > > does and you can turn on C2 security. C2 security is available on
> > > Server
> > > > 2000, but not on SQL Server 7.0. You cannot turn on audit trail on
> > > > Server 7.0.
> > > > Does anyone know more detail about this feature or type of auditing?
> > > > Thank you,
> > > > Tom