Am I able to track the timeout transactions in C#/.NET on SQLServer or Oracle databases?

Is it able to capture the timeouted transactions on SQLServer or Oracle database by using C#/.NET? Currently I am working on a windows service which needs to monitor a specific data table i开发者_如何学JAVAn SQLServer or Oracle but I don't know how can I implement such kind of requirement.

in sql server, there are some new things introduced since version 2005, DMV (these are managmenet views of sql server), you can query them and get the data, some of them are related to Transactions as well.

Visit this link or Google more about "SQL Server DMV".

http://weblogs.sqlteam.com/mladenp/archive/2008/04/29/SQL-Server-2005-Get-full-information-about-transaction-locks.aspx

Regards,

Mazhar Karimi