I apologize in advance if this is a stupid question... :-) We are using NS alongside of an existing CRM system that was built in-house. We have our own Customer table that has a CustomerId, Email, and an active/inactive flag (among other things). To integrate w/ NS, we have copied our Custom...more >>

In looking at notification services there is an example in the SQL 2005 April CTP BOL that shows how to create a stored procedure custom protocol. The only thing missing is the code to add to the config and adf. Can someone provide and example for this?...more >>

The NS applicatipon does not work on SQL2005 (Win XP Server). My ASP.NET application crashes with the message: " The registry entries for the specified instance of Notification Services could not be found." The registry entries are exist, but seems like they are in wrong location HKEY_L...more >>

I have to sent the notification at the specified TimeSpan before the specified Time. Example: Unit Train Estimated arrival time notification. Unit Train will arrive to the destination at the specific time (stored in database) User has to receive the notification 3 hours before the Unit Train...more >>

Hi guys, I have added one more named instance to my SQL Server and tried to use NS on it. I can not start the service. The "net use start ...." command shows the following message: Could not start the NS$ELSInstance service on Local Computer. The service did not return an error. This coul...more >>

Hi, I am trying to use notification services to generate notifications to any subscribers. By that I mean, a stock subscriber can subscribe for email if stock price for stock symbol goes above some value, an order handling person can subscribe for SMS if inventory level goes below some limi...more >>

Hi, I have started with using Events table (EventRule selects the data from table names EventName_Events). As a result every time when a event occurs I receive the notification + notifications about ALL the events already handled early. When I switched to CurrentEvents table (Current_Ev...more >>

I am trying to see if SQLNS will be able to help with an application I was going to write from scratch. The purpose of the application, called the Scheduling Component (SC), is to enable a wide variety of processes to be scheduled to run automatically for our product suite. The scheduling ...more >>

The NS applicatipon works fine on the SQL Server 2000 (installed on Win2000). I have moved it now on SQL2005 (Win XP Server). My ASP.NET application statred to crash with the message: " The registry entries for the specified instance of Notification Services could not be found." on the ...more >>

hi, i have a sharepoint portal server installed on windows 2003 server. SQL server is connected to the sharepoint server. it seems to be not working. i started the MSSQL$RTC service however i am not able to start sqlagent$rtc service, which i believe is the cause of the problem. can anybod...more >>

Hi, When I use xslt for formatting the notification, I am facing some issues with the variables inside xslt.I have a variable which is declared with global scope. I am assigning a value to this variable within a TABLE( <TABLE>..</TABLE>) and I am not able to use the value of this variable ...more >>

Hi, I need to prepare the reports in excel sheet and send it as part of notification message. As the current notification (Built in SMTP Delivery protocol) doesn't support attachments, I am creating a cursom delivery protocol (implementing IDeliveryProtocol) to send a email with attachme...more >>

Hello I just wanted to know if SQL-NS is Daylight Savings time aware. W have a recurring schedule we want to run every 2 hours on the eve hour. The schedule started to run at odd hours recently bec. of th change in time I know SQL-NS has everything based on GMT. To make it fire th schedul...more >>

Has anyone here used Notification Services to schedule Reporting Services subscriptions? Just wondering if it's even possible or worthwhile to do so. Thanks! ...more >>

I've built a simple app using the SongAlert sample from the book as my reference. I wrote a fairly simple custom formatter and am trying to debug it. Based on my logging and debugging, I can see that the Initialize() and Close() events on my formatter are getting called, but it never calls For...more >>

Hi All, I am confused about overlapped functionality between Notification Svcs(NS) and Reporting Svcs(RS). I know that RS has report design function that NS does not, BUT both have 'Notification Capability'. Could any body please tell me, what are the differences of 'Notification Capabil...more >>

I have added index definitions to my ADF file (<IndexSqlSchema> node in <EventClass>). However, NS does not create these indexes in my databases. I checked the Stock sample application and NS doesn't create any indexes there either. Has anyone an idea how to get NS to create these indexes?...more >>

Hi, When I have multiple notifications which were setup to run at a particular time, I am not getting some of the notifications and I am getting this following error in the event log. What should I do? How do I handle this kinds of errors? Event Type: Error Event Source: Notifica...more >>

Hi , Whenever I am updating the xslts used in the notification, I need to restart the notification service instance to make the change into effect. Is there any other way? Can I configure the system to take the updated xslts automatically? Thanks. Regards, R.Balaji ...more >>

> i am trying to connect to sql server in a remote database by using windows > authentication. I tried to connect using php and cgi. The apache service > under which i am running my cgi or php is under localsystem account. If i > change it to administrator account, i am able to connect to remo...more >>

Hello, SubscriberDevice does not have the ID field ! How you guys identify the device? Name is read only field (once entered it can not be changed). ...more >>

Hi , I notice in my production environment that the realtime clock fall behind the quantum clock nearly 5 hours. select StartTime from nsquantum1(nolock) where quantumid = (select max(quantumid) from nsquantum1(nolock)) select getdate() Results.... StartTime ...more >>

Hi, As the quantum clock was far behind the realtime clock, i tried to sync them using the following statements exec NSUpdateGeneratorActivationState 3 go --setting the quantumtime to realtime clock exec NSSetQuantumClockDate '2005-05-09 15:14:28.547' --getdate() go exec NSUpdateGenera...more >>

Hi, everyone. I'm embarassed to admit that I set up a SQLNS app some time ago, and it's been so long since I worked with it that I'm at a loss for where to start troubleshooting. A SQLNS server that I work with is experiencing an inordinately high volume of blocking. In particular, the proce...more >>

I have an NS application. In a given EventBatch, 150 events are received. The event rule when executed in Query Analyzer returns on row for each subscriber as desired. Unfortunately, NS is generating 2 exactly duplicate notifications for each subscriber with the same Notification Batch ID and R...more >>

How to configure Sql 2000 notification services to pocket pc when a new record add to a table. ...more >>

Hi, When I add a new subscription class, I am getting the following error. RuleName: CancelOrderEventSubscriptionsRule RuleType: EventSubscriptionRule RuleAction: SELECT dbo.CancelOrderNotificationNotify( s.SubscriberId,s.DeviceName,s.SubscriberLocale, convert(varchar,orderedD...more >>