question

Nrv999 avatar image
Nrv999 asked

sql server 2008 notification

I m using sql server 2008 and I want to get notification on my web application with vb.net code **Not email notification**
sql-server-2008
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image sp_lock commented ·
What sort of notification... Errors?
2 Likes 2 ·

1 Answer

·
tanglesoft avatar image
tanglesoft answered
You could write a C# assembly with public event that is loaded into SQL Server so it could be called from T-SQL. Then write another C# assembly that is exposed in Silverlight, or COM callable as a OLE component in the web page. The assembly would need to act as a sink for the server side event using remoting or other call back technology. Either way it would be horrid. It would be much easier for client side web code to make an async call to a service to check if the desire event has occured in the database.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.