Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Table change event

2 Posts 2 Posters 0 Views 1 Watching

R Offline
R Offline
RoyRose78

wrote on last edited by

#1

Hey all, Is there a way to know when table changed and who changed it? is there a default table that logs those kinds of changes in MSSQL 2000? Thanks RoyRose.
C 1 Reply Last reply

0
R RoyRose78

Hey all, Is there a way to know when table changed and who changed it? is there a default table that logs those kinds of changes in MSSQL 2000? Thanks RoyRose.
C Offline
C Offline
Chris Buckett

wrote on last edited by

#2

Nope, unless you've enabled it. Article here talks about it.[^] If it's just one table, then you can implement it yourself using triggers etc... Googling for "sql server audit trigger" provides a load of methods. ChrisB
1 Reply Last reply

0

Log in to reply