Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Triggers 2

Status
Not open for further replies.
KWasp

KWasp

Technical User
May 3, 2001
5
GB
I have a customer using Maximizer sitting on a MS SQL server and they want to track changes to the database.

They will need to do this using Triggers on the SQL server to write the changes in to another table. They would like to track Who changed/Added/Deleted data, When it was changed, Old value, new value.

Does anynoe have experience of this and/or a quick explination on how it all works?
 
Sort by date Sort by votes
Yes and it is a huge pain. Look into a product called sql-audit, it will do most of the work for you.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

davism
  • Locked
  • Question
DDL to files for DB artifacts (Stored Procedures, Views, Triggers, etc) in a SQL Server DB. 1
Replies
1
Views
146
TamarGranor
TamarGranor
Emmy2368
  • Locked
  • Question
Inserting start and end timestamps using triggers on multiple rows
Replies
10
Views
345
Emmy2368
Emmy2368
misscrf
  • Locked
  • Question
Triggers and Inserts from Access Append Query?
Replies
2
Views
163
misscrf
misscrf
pjw001
  • Locked
  • Question
Question about triggers
Replies
2
Views
124
pjw001
pjw001
Mus986
  • Locked
  • Question
Update Triggers
Replies
3
Views
122
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top