How to monitor a SQL database and its table

[Jex]

Hi,

I hv created a web application connected with sql server. (VS 2005 & SQL 2000).

Now I want to monitor a particular table in that database, (an alert message should come, when that particular table has modified, updated or deleted)

any idea?

Thank you

[dip_developer]

Hi,

I hv created a web application connected with sql server. (VS 2005 & SQL 2000).

Now I want to monitor a particular table in that database, (an alert message should come, when that particular table has modified, updated or deleted)

any idea?

Thank you

when do u want the message box....?? In a particular event???
whenever you are updating,deleting your table then on successful completion of updation or deletion you can show a messagebox......

moreover if you manually modify your table then your program will not sense the change........so you have to monitor your database periodically after your application starts........

so how do you actually want this to happen???

[Jex]

Actually I have a web application, (running in a local server), in that web app, ppl entering their logout times (If a particular person wants to leave the room, he has to enter his name, time, and the reason to leave the room)

Now, the admin (of the application) wants to see, the status of that room every second. So I add a window application (which is installed only in admin's system) and that window application should interact with the database everysecond, and it should show a message box (like yahoo messanger, gtalk - If your friends comes online, the system immediatly show that your friend is online).

So,this is my prob, how can i achive this.?

Thank you

[dip_developer]

Actually I have a web application, (running in a local server), in that web app, ppl entering their logout times (If a particular person wants to leave the room, he has to enter his name, time, and the reason to leave the room)

Now, the admin (of the application) wants to see, the status of that room every second. So I add a window application (which is installed only in admin's system) and that window application should interact with the database everysecond, and it should show a message box (like yahoo messanger, gtalk - If your friends comes online, the system immediatly show that your friend is online).

So,this is my prob, how can i achive this.?

Thank you

get a timer control.....you can set the time interval......then on Timer_[size=2]Elapsed[/size] event monitor the database...........
any problem???

[Jex]

Hi dip_developer,

Thats great, I got it, its working now, Thank you so much.