Re: How to know which tables is updated ?
From: James Goodman (james_at_norton-associates.REMOVE.co.uk)
Date: 03/17/04
- Next message: CW3: "SQL Profiler"
- Previous message: Tom: "Re: DB capability, daily backup, import access and excel files"
- In reply to: Ashish Kanoongo: "How to know which tables is updated ?"
- Next in thread: Wayne Snyder: "Re: How to know which tables is updated ?"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 17 Mar 2004 13:13:59 +0000 (UTC)
You could use profiler to audit certain types of activity & subsequently see what activity has occured through time.
You could use triggers &/or default values to maintain a list of who & when records are added.
I generally add [Creator] & [CreationDate] fields with defaults of SUSER_SNAME() & GETDATE() respectively to any important tables...
-- James Goodman MCSE MCDBA http://www.angelfire.com/sports/f1pictures/ "Ashish Kanoongo" <ashishk@armoursoftware.com> wrote in message news:%23xGORhBDEHA.3664@TK2MSFTNGP10.phx.gbl... is there way to know to which object is updated or in which tables record has entered recently? is there any utility in Sql Server 2000 or any kind of third party tool available ? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.627 / Virus Database: 402 - Release Date: 03/16/2004
- Next message: CW3: "SQL Profiler"
- Previous message: Tom: "Re: DB capability, daily backup, import access and excel files"
- In reply to: Ashish Kanoongo: "How to know which tables is updated ?"
- Next in thread: Wayne Snyder: "Re: How to know which tables is updated ?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
