I've read Shyam's book and the section on updates possibly failing (p. 576 on). It mentions two subscription tables that must be restored if a subscription schema changes. And that you should in general backup the NS DB's before any schema-changing update. But the restore instructions on p....more >>

Hi, I have a requriement where the I need to push the information to the = "text" field.=20 When I tried to modify the structure of the events table. It gave me a = following error.=20 C:\SS_Argos_Rakya\NotificationService\ApplicationDefinitionFile\ArgosRAPA= DF.xml( 508,4): error NS9116:...more >>

My messages are going through successfully via SMTP, but the To field does not show the email address of the person. If you look at the SMTP message with notepad you see X-Receiver: <email address>, but there is not a To: field declared. Is this correct for SQL 2005 June CTP for NS? We woul...more >>

I'm running "NS 2.0 SP1 Std en" on Windows 2003 Server. I'm sending alerts via the SMTP channel. I got the basics working by adding the Mail Server role to the server using Manage Your Server. Now I'm getting mail but the subject line is in Kanji when opened in Outlook, but the text is in e...more >>

i have configured sql mail in sql server 2000. the mailid is also successfully getting tested. but when i execute the xp_sendmail command i get the following error Server: Msg 18025, Level 16, State 1, Line 0 xp_sendmail: failed with mail error 0x80040107 do i have to apply any servi...more >>

Attempt 2 to post, first one did not seem to go through: This is a duplicate from the post found at https://forums.microsoft.com/msdn/ShowPost.aspx?PostID=78223, but just seeming where it gets answered first. Posting Question Asked below: Here is what we want to do, and I have not been ...more >>

in a custom delivery protocol we have just done we need to clean up some transient files when all the work items in this cycle of the distributor have been processed. any ideas how we can detect this? Kate MBCS Alert Technologies http://www.alert-technologies.co.uk Get your notificati...more >>

How do we setup a expiration date for an subscription. Example. a user subscribes to alert from an airport on a paticular depature or arrival. We now know the date for the plane to arrive or depart, but the day after this there is no reason for keeeping the subscription in NS. Is there some...more >>

I was asked to look into a problem a customer was having , Turned out they moved SMTP server and in the process the generator got disabled. This was back in May. So I have that all squared away and now I'm looking for a quick way to clear out the events that have been backing up. Vacuu...more >>

We have a need to send events out to multiple devices for a single subscription, the user may be able to decide what devices with what subscriptions. So far we have the following two ideas for accomplishing this: create a multiple subscriptions, one for each device the user wants the even...more >>

we are setting up ns standard on a w2k server and we get the following nscontrol.exe register -name trackerinstance -server ARG-SERVER -service -serviceusername localsystem ns registry entries being updated ns windows service is being installed ns performance counters are being installed...more >>

Hi I am using two types of replication (Transactional and Merger) i need to monitor the replication status through T-SQL which i need to show on my user screen. Any idea where i can get the help. Thanks Imran...more >>

Hi All, I sent this question a few months ago but still could not find a way to resolve it. On two servers we have Notification Services installed and problem is when I start the service cpu usage gets to 100%. In event viewer I found this event as well: <NotificationServicesEvent> ...more >>

I'm trying to updated subscriptions for a single subscriber, so far all is working well. However, I was wondering is there a way to pull back just the sing subscriber? Currently I am doing the following: new SubscriberEnumeration(nsInstance)[subscriberId]; As I understand from the help the...more >>

I wonder if the following is a known problem: Essentially, it seems there is no way to add a schedule rule to an existing subscription class in ADF file. NS update runs without errors, but no schedule-related tables and fields are created. Yet NS documentation says that "<ScheduledRules> nod...more >>

Hi, One issue I am facing with SQL Server Notifications is=20 I post the events to Notification Server when the service is not = running. The events are seen in the NSPersonEventsEvents table under the = Application database. Once I start the service, no notifications are = generated for th...more >>

Is it possible to have an assembly in SQL 2005 to expose the NS API? The idea is to have interfaces exposed as web services from SQL 2005 directly that allow for the management of NS subscriptions. This would allow the existing ASP.Net 1.1 code to call the service without having to install all...more >>

Hi, I have a requrirement where I want to post the events from a different = machine. I am using a custom event provider which is hooked as a part = with some third party application.=20 When some change occurs with some information, an event is fired, which = is posted to NS.=20 This gi...more >>

I'm testing on my XP-Pro machine. I have the Default SMTP Virtual Server installed. I have tried various Relay Restrictions including "All except the list below". Also tried with and w/o Smart host as smtp-server.cfl.rr.com, our ISP. I get the following errors in the Application Event lo...more >>

I have configured the NS to send events through E-mail.=20 I have used the content formatter to format the Data in XML format,=20 Though I provide the information to format the information using "utf-8" = encoding, but for some reason, I get the information as mentioned below = in "utf-16" enc...more >>