Monitor SQL activity through .net

  • Thread starter Thread starter .net and SQL Server
  • Start date Start date
N

.net and SQL Server

Anyone have any ideas of how you would build a .net
component to monitor SQL Activity.
Here is what I am trying to do:
When an insert or update to a SQL table occurs, I want to
populate another table (in a different database). I don't
want to use a trigger.

Thx,
Troy
 
.net and SQL Server said:
Anyone have any ideas of how you would build a .net
component to monitor SQL Activity.
Here is what I am trying to do:
When an insert or update to a SQL table occurs, I want to
populate another table (in a different database). I don't
want to use a trigger.
Click to expand...

Troy,

You'll want to hook into the tracing and profiling functions of sql server,
have a look at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=20126&pg=1

hth
andrew
 
Back
Top