sql server notification services: Hi everyone,

We have to solve a problem and I need expert help. The situation is as
follows:

We have an ASP.NET Web Application running on IIS 6.0 NLB Cluster. It
connects to clustered(Virtual) SQL Server 2000.

There are a number of production lines and users at each line. The user
starts IE and enters the URL and then gets a screen with some data from the
database. As soon as certain table in the database gets
modified(insert/update) we want the IE window on the client to get refreshed
to reflect the up to date data without any user intervention. We thought
that it could be done with SQL Notification Services, but I am not sure if
it could be done(or how it could be done).

My question is:

Is it possible to achieve our goal with SQL Notification Services ?

If yes, could you provide some details how to do it.

If no, could you suggest any alternative solution.



Best regards.

Sezgin Rafed

Hi Sezgin,

Thanks for your post.

From your descriptions, I understood that you would like to make IE refresh
automatically. Have I understood you? Correct me if I was wrong.

Based on my scope, unfortunately, I am afraid it is not possible to do so.
Notification Services is a platform for developing and deploying
applications that generate and send notifications to users. A notification
can be generated and sent to the user as soon as a triggering event occurs.
However, refresh IE need the the client do the operations automatically.

For now, I think you could use a hidden web page to SELECT the datasource
in a schedule, such as per 5 seconds, to see whether there is any updates.
If so, the hidden page could trigger an IE refresh. You may also raise your
questions in asp.net newsgroup to see whether there is any others ideas on
this issue instead of Notification Services.

Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!

Thanks Michael.

Hi Sezgin,

Welcome!


Sincerely yours,

Michael Cheng

Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---------------------------------------------------------------
Get Secure! - http://www.microsoft.com/security

This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!