Tracking Log AND DB Changes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Brennan (Brennan_at_discussions.microsoft.com)
Date: 12/16/04 

Date: Thu, 16 Dec 2004 07:25:08 -0800

Hi All:

I need to devel a tsql script that will track changes of various SQL 2K DBs
and Logs on a weekly basis and write this information to a statistical table.

Any sample code would be appreciated

Thanks
Brennan

Relevant Pages

  • how quick a transaction will be committed to DB
    ... We have some SQL ... We use Double-Take for a DR server. ... Rolling transaction logs forward might indicate that our DBs, ...
    (microsoft.public.sqlserver.server)
  • Re: Concatenating the same field from multiple records
    ... Dim dbs As DAO.Database ... dim utblSQLPartInsert as String ... each of the sql steps is different so i would need to set the variable each ... it be better to execute the query, or can i use docmd.sql " my sql here" ...
    (microsoft.public.access.queries)
  • Re: testing vulnerable web application.
    ... You should be able to just open up your logs and look for things that are out of the ordinary. ... Keep your database and all but double check it to make sure there really aren't accounts and what not that should not be there. ... We assumed the attacker was using some sort of SQL injection to alter the DB records or possibly he can craft a SQL query in a way that will create an admin account to use to simply log in and alter the records and then delete his username...NO rogue admin accounts have ever been found. ... You have an option to go with a managed service or an enterprise software. ...
    (Pen-Test)
  • Re: Unable to start SQL SERVER service for a SQL EXPRESS instance.
    ... Event Viewer, as you directed), so that's what that said. ... As for the SQL Error Log, there don't appear to be ANY logs. ... Now, it won't install completely. ...
    (microsoft.public.sqlserver.clients)
  • Re: Getting Started - RAID, Multiple Instances, SQL 2000-2005 . . .
    ... SQL 2000 Std. ... Data and Logs on RAID 5 partition ... Planning to put OS on RAID 1 partition, logs on different RAID 1 partition, ...
    (microsoft.public.sqlserver.setup)