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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 SQl Server Log

Author  Topic 

vahidam
Starting Member

13 Posts

Posted - 2010-03-10 : 00:25:59
Hi All ,
I have a databases that i want to log all actions in it,but because i have a lots data,if want to log manualy ,i will have mass data in my database early, i want know that Is Exists any feature in sql that log all actins with details automaticly?
thx

NeilG
Aged Yak Warrior

530 Posts

Posted - 2010-03-10 : 09:22:26
What type of things are you actually trying to log
Go to Top of Page

vahidam
Starting Member

13 Posts

Posted - 2010-03-11 : 02:15:32
for example i have a accounting system that user can be edit his\her billings and i want to log all modified that,and show them whenever user want see them,if i make a manual log(register records befor modified in a subtable and modify main table by new change) my db size grow up very fast , and its bad for me
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2010-03-11 : 04:22:23
Well...there is what's called "change data capture" in sql server 2008. Look it up here:

http://msdn.microsoft.com/en-us/library/bb522489.aspx

- Lumbago
If the facts don't fit the theory, change the facts. Albert Einstein
Go to Top of Page
   

- Advertisement -