| Author |
Topic |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2008-08-20 : 14:47:26
|
| Any one using, Lumigent Log Explorer for SQL Server?How is the experience? Is there a better tool?------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-20 : 23:31:09
|
| Log Explorer is not auditing tool, Lumigent's Audit DB is. |
 |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-21 : 09:43:09
|
| Thanks rmiao. I was bit confused with both tools. There is also a demo here, http://www.lumigent.com/products/products_overview.htmlI will watch it today. Hope things will be more clear after watching this.------------------------I think, therefore I am - Rene Descartes |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-21 : 14:25:47
|
| 1. In case of data loss, or object deletion, I need to find the user activities. 2. Also I need to monitor who all are accessing the server and their activities ------------------------I think, therefore I am - Rene Descartes |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-08-21 : 14:50:53
|
| These can be achieved by DML and DDL Triggers in SQL 2005. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2008-08-21 : 14:57:14
|
| ..or probably we can also use trace. However we have large number of servers, probably an off the shelf porduct whould make it smoother.------------------------I think, therefore I am - Rene Descartes |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-08-21 : 23:52:46
|
| >> 2. Also I need to monitor who all are accessing the server and their activities Audit DB can monitor selection. |
|
|
|
|
SQL auditing