Way to Monitor the SQL Server

[Mike2020]

Hi:

I wrote my COM+ using Visual Basic, and one of my method is to monitor the database every 5 seconds to check whether the one of the field change to 1=RUN. IF the field is equal to 1, then I will call other method to run its work. BUT I think this way is not good.

So, do you have any idea/know something on the SQL Server side to monitor the that particular table->field, and if it change to 1, then it call the component to run the work.

Many Thanks

Mike

 

[rorubin]

Well I don't know what your components are doing, but if everything they are doing is on the database side, then take a look at "triggers"

 

[Mike2020]

Hi Rorubin:

My components run the audio searching

 

[rorubin]

You can try the notification service, although from a design standpoint I only see a benefit if you plan to need to scale the application.