Hi, Does anyone know anything about Dbwatch? http://www.fencel.com/ What other tools are similar to Dbwatch? Thanks.
Seems to be a good tool I think we can achive these things by using SQL Trace quote:Originally posted by pcsql Does anyone know anything about Dbwatch? http://www.fencel.com/ What other tools are similar to Dbwatch? Thanks.
Hi Dinesh, I have never used SQL Trace but I'm not aware that it can be used to capture changes. Where can I find example how to use SQL Trace to capture changes? Thanks.
http://www.sqlservercentral.com/columnists/bkelley/auditingwithsqlprofiler.asp http://www.sqlservercentral.com/col...queryexecutionplansthroughsqlprofilertrac.asp http://vyaskn.tripod.com/server_side_tracing_in_sql_server.htm http://www.developer.com/db/article.php/3490086 quote: I have never used SQL Trace but I'm not aware that it can be used to capture changes. Where can I find example how to use SQL Trace to capture changes?
Hi Dinesh, Thanks for the links but I believe those links are just basically information how to use SQL Profiler. One of the important feature (Step 6) in Dbwatch is - Displays changed fields in red, deleted rows in green, added rows in blue. If SQL Trace can do this, it will be nice.
Yes SQL Trace may not have that UI facility. However, you will be able to filter those. quote:Originally posted by pcsql One of the important feature (Step 6) in Dbwatch is - Displays changed fields in red, deleted rows in green, added rows in blue. If SQL Trace can do this, it will be nice.
