how to notify the .Net application about the alerts in database?
-
hi, How do we notify the application about alerts in the database. Actually i have created an alert in the database and it gets called whenever an update occurs in the database.how does the application gets to know that an alert has been called?the database is SQL Server 2000 and im using c#.
people laugh at me because they say im different and I laugh at them because they are all the same.
-
hi, How do we notify the application about alerts in the database. Actually i have created an alert in the database and it gets called whenever an update occurs in the database.how does the application gets to know that an alert has been called?the database is SQL Server 2000 and im using c#.
people laugh at me because they say im different and I laugh at them because they are all the same.
Do you mean a trigger ? You can't.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
-
Do you mean a trigger ? You can't.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog
Not triggers actually.You have "sp_add_alert" like http://msdn2.microsoft.com/en-us/library/aa259587(SQL.80).aspx by this you can create a database alert .I just wana know how to notify the alert to the application.
people laugh at me because they say im different and I laugh at them because they are all the same.