How do u know if someone modifies data in a table?

Question

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jamie Thomson SSChampion Points: 11805 More actions · Answer 1

You need to capture all the queries that are fired against your server. SQL Server Profiler is the best tool to do this that I know of.

This is not a Yukon specific question. If I were you I'd check the other forums.

Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson

Frank Kalis SSC Guru Points: 111183 More actions · Answer 2

Triggers and audit tables are the usual way to deal with this problem.

Is there a specific reason why you're asking or is this a general question?

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 3

SQL doesn't supply built-in tracking. You need to supply the audit trails, etc..

Good Hunting!

mamidimahesh-127681 SSC Eights! Points: 868 More actions · Answer 4

SSC Eights!

Points: 868

April 5, 2005 at 6:37 am

This is general question.

Thanks,

Mahesh Babu

Frank Kalis SSC Guru Points: 111183 More actions · Answer 5

See if this helps:

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]