Monitoring SQL Server activies from an outside environment

Hi,

I don't know if this is the right place to post this kind of question (moderators, please move it to the right place if it's not here).

I want to know how can I monitor some operations that are executed on a SQL Server database. Operations like: INSERT, DELETE, UPDATE, transactions, and so on (I know that I can do this using triggers, but doing this way I'll have to fill a table with the information from the triggers and stay loading the table data all the time. I want a way to monitor using other resources, in realtime).

My idea is to build a program to monitor these activities (C# to be more exactly). How can I do this?

Thanks

SMO is a set of object libraries that allow you to manage SQL Server. What I think you're looking for is a transaction log sniffer, and I believe there are some good commercial products for that, SMO addresses an entirely different problem.|||

Allen, I know some commercial products, but I'm planning a project for my graduation degree.

|||I understand and wish you the best of luck. SMO doesn't have the objects to read the log pages, though. You might want to post a similar question in the Database Engine forum.|||I understand. Thanks for your patience.