Under SQL Server 2005 Standard SP1 Each day between 12:00 AM and 12:01 AM, receive error in SQL Agent log: "Date 8/22/2006 12:00:59 AM Log SQL Agent (Archive #8 - 8/27/2006 4:07:00 PM) Message [LOG] Cyclical forwarding detected for event 17177: Event source was 'SERVER' which matches...more >>

One deployment strategy is to have the SQLNS instance service (NS$) and event providers running on one server (A) and the database on another server (B). My questions are: 1) How should SQLNS behave when servers A and B are rebooted? My experience is that if Server A comes up first and can't...more >>

I have two databases with same strucutres. I am able run the notification services for one istance and it is not working for second instance of database. First database have 50,000 Records and the second database have 75,000 records. Please help to solve this error. Thanks in advance. Er...more >>

Hello, I am getting this error while running notification services Message: 4120: The number of events in this quantum is greater than the throttle specified for events. Some of the event and subscription views could not be materialized. </Description> ...more >>

Let me layout the scenario. I'm writing a windows service that will monitor a a SQL Database via SQL Query Notification Service. Nothing out of the ordinary there. All that is working fine. Here where it gets interesting. I'm running SQL Server 2005. Most of the database have been upgraded f...more >>

I would like to create a subscription that once a Notification is generated for the subscription it becomes disabled. If there a way to do this automatically? If not, any recommendations? FYI.. We do have our own custom formatter and delivery protocol/channel. It might be possible to di...more >>

i am looking on some demos in shyam pathar book on NS 2005 and i look at the SubscribtionLoader C# code and i see it sets the ScheduleStartTime property ,i did not find any corresponding setting in the ADF file ,is it possible to set this option only from NMO? -- Danny Ravid Ness Technol...more >>

I tried the samples (especially Newsletter sample) and I see how to get notifications to go via e-mail or to a file. What I am wondering is how to get an application to listen for them and consume them. For example, I have a windows forms app in C# that show my current invnetory and prices -...more >>

Folks, I have read the SQL Notification Services Documentation, but as I am a novice with SQL NS, I was hoping for clarification on a couple of application settings. I am using an app written for SQL 2000 NS (it's called the Notification Workflow Solution Accelerator). I a few mostly yes/n...more >>

Hi all, I am looking at an application configuration that requires me to manage data for multiple clients as a single manager. Basically, I can have any number of clients I am responsible for (say 20), and I need to be able to retrieve any updates to data regarding those clients as it comes...more >>

We have a SQL 2k5 notification service application, which is running on = Windows 2003 server, couldn't start after we applied the SQL 2k5 sp1. = Opened the even viewer, there wasn't any entry found in the logs related = to service failure. The server is located in our internal network, which = ...more >>

Is it proper to create a trigger on delete stored procedure on the NS subscription table to cleanup any chronicle tables that I have created for my application ? When a subscription is deleted, I want to purge data from some chronicle tables for that subscription id. If not, does anyone hav...more >>

Hi all, I am attempting to create a simple event chronicle that stores the last run time, per the example in Shyam's most recent book regarding SQL 2005. The below snippet is an example of what I have for this chronicle and rule specifically. EventChronicle resultsChronicle = new EventC...more >>

Is an explanation available for why one might get the following error when starting an instance using the command line: nsservice InstanceName -a Microsoft SQL Server Notification Services service executable 9.0.242.0 c Microsoft Corp. All rights reserved. Running NS$MyInstance as an appl...more >>

Hi all, If I have a subscriber set up to look for updates to medical records via a client application that is running on their machine, is there a delivery format that will allow me to send a notification directly back to the client assembly that contains the client subscriber that is subsc...more >>

Hi All, I found the Flight Sample Description at http://msdn2.microsoft.com/en-us/library/ms160946(d=ide).aspx . I installed the file SQLServerSamples.msi which is in C:\Program Files\Microsoft SQL Server\90\Tools\Samples by default. I followed the steps strictly. Every thin...more >>

Hi All, I read some theoretical explanation of notification services. I want to find a source for notification services that has examples of how to implement notification services from A to Z. Thank you in advance. Bishoy ...more >>

Hi there. I did search the web for the following question but could not find a clear answer maybe some one can point me in the right direction. I downloaded a sample for service broker and set it up between two SQL Servers and it works just fine. I then recreated the sample between SQL serv...more >>