Monitoring Transactions

[jpastika]

I would like to develop an application that will monitor the transactions going into my SQL Server Database. I want the application to look at every INSERT, UPDATE, and DELETE transaction that occurs, and based on defined rules, send notifications, set timers, update tables, etc. I don't want to use triggers. I have been looking at Microsoft Message Queue, but I'm not sure that is what I want. Does anyone have any suggestions?

-Jeremy

 

[tlbroadbent]

Check out SQL Profiler and traces in SQL BOL. See also...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q283790

http://msdn.microsoft.com/library/en-us/adminsql/ad_mon_perf_86ib.asp

http://www.itworld.com/nl/db_mgr/04162001/

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.