Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sdw
Starting Member
6 Posts |
 Posted - 2008-05-04 : 05:12:06
|
| Hi all,I am have database consist of 10 tables, I want to make log transactions for this tables, So any act happened on these tables, such as adding or modifying or deleting record, I want to put this information somewhere in the database, to determine the user who has done such acts on these tables.I would high appreciate for any assistant. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-04 : 05:22:04
|
| You can do this via triggers on each of your tables.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
sdw
Starting Member
6 Posts |
Posted - 2008-05-04 : 05:37:44
|
| Thank you for your response.I am aware of the trigger thing; however, I had the chance to read EVENTDATA and DDL in SQL Server 2005. According to what I read, DDL can trigger all the tables in terms of structure not the data inside (Delete, Insert and update).So, I was wondering if DDL can do the same but with data changing. Please advice. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-04 : 05:42:16
|
| You read about DDL triggers. I'm talking about just the regular triggers.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
sdw
Starting Member
6 Posts |
Posted - 2008-05-04 : 05:45:15
|
| Thank you again.Direct question :) do you have any experience with DDL? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-04 : 05:48:33
|
| I haven't touched DDL triggers yet, but I'm very familiar with DDL as should any DBA be.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
sdw
Starting Member
6 Posts |
Posted - 2008-05-04 : 05:54:25
|
| Thank you my friend. It seems I need to dig more on the web!! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-04 : 18:12:57
|
| Sql2k5 comes with standard schema change history report. |
|
|
|
|
|
|
How can I make Log Transactions using SQL 2005