Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server notification services > september 2004

Permissions required to create service
Posted by Rich Qartman at 9/30/2004 8:47:10 AM
Our installation of ns is working great except that we have had to place the ASPNET user in the Administrator group on the web server (W2K). We have a domain user account created which NS is running as, and the service is set to run as when created - however, we do not like having the ASP...more >>


How to check schema validation error?
Posted by Jason Wang at 9/29/2004 1:35:07 PM
When using File System Watcher Event Provider and an invalid xml event data file is loaded into event folder, an error message will be logged into event log. In a program, I can check event log and wait for a OK/fail message writeen into the log. Is that the only way to check schema validation...more >>

schema validation problem for FileSystemWatcher
Posted by Jason Wang at 9/29/2004 1:27:02 PM
when I drop event data file to realtor, stock and weather application event folde, the schema validation work fine. All xml data from other applications will be rejected. However, the flight application does not reject invalid xml file. Instead, it adds blank entry into event table. I don't se...more >>

when does Event Chronicle Rule fire?
Posted by Jason Wang at 9/29/2004 1:21:02 PM
Someone please tell me when does an event chronicle rule fire? I could not find it anywhere. I'm having problem on one of my mahines. The weather sample is not working. After I added subscription, then added an event, no notification generated. I noticed no entry was in WeatherEventsChron tab...more >>

1 event 2 notification formats
Posted by lhomes at 9/29/2004 10:00:57 AM
I need to be able to send 2 different formats of email when an event happens. 1 internal that has a bunch of data about the details of the event and the other external with just a simple notification - no details. I can make this work with different device types but it seems like there s...more >>

selecting templates from XSLT
Posted by sanjay at 9/28/2004 11:05:47 PM
Hi All, How NS selects one template from the many i specify in my XSLT. Regards, Sanjay...more >>

Notification services sample
Posted by Jabba jabba at 9/28/2004 1:42:59 AM
Hola to all. Someone might send a small example of sending of mail using the notification service. Thankyou *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Login Failed for user 'NT AUTHORITY\SYSTEM'
Posted by michaelri at 9/27/2004 9:07:01 PM
I recently switched my instance service to use Windows authentication. Now I'm getting the following error everytime I submit an event. Seems like the generator fails when it tries to execute this xp and no notifications are generated. I granted the windows account running the service permissi...more >>



Notification service auto start dependency
Posted by Ben Chan at 9/23/2004 10:46:40 PM
Dear All I changed my NS$instance_name service as automatic startup , but i found the following error message in the event log "The NS$instance_name service failed to start due to the following error: The service did not respond to the start or control request in a timely fashion. " ...more >>

Store MSMQ messages in SQL
Posted by Christian davidsson at 9/23/2004 3:07:01 AM
Hello, Is it possible to have the SQL server pick up messages from MSMQ and store it in a table, if so - how? Thanks in advance, Christian Davidsson...more >>

Notification Delivery Reliability
Posted by Robert May at 9/22/2004 3:29:00 PM
We are investigating whether or not we want to use Notification Services in a project. We'll have a very long running process (it currently takes 6 hours) that is basically a nightly delivery of all of the data that we collected the prior day to 15,000 customers based on their selections of wh...more >>

XP_Sendmail
Posted by Curtis C at 9/22/2004 11:12:58 AM
I have a new Windows 2000 Server with SQL Server 7, and am trying to use XP_Sendmail. The SQL Mail Service tests correctly, but when I execure XP_Sendmail, it just sits there, and no error messages are returned. Anybody seen this? *** Sent via Developersdex http://www.developersdex.com ***...more >>

Sending Attachments Using Notification Services
Posted by Suyog at 9/21/2004 11:25:01 PM
Hi I want to send attachments like pdf file and html pages in the email that is generated by Notification Services (NS). My approach currently is by using CustomDelivery Protocol using IDeliveryProtocol Interface. I am trying to attach some file to mail message in DeliverNotification Method ...more >>

Suggestion about using Notification services needed
Posted by Linas Kricenas at 9/19/2004 5:02:17 PM
Hi everybody, could You please give a suggestion whether Notification services (NS) should be used in following situation ? We have two SQL Server databases (lets call it A and B) on the same SQL server instance. 'A' database contain common data that could be reused across various applicati...more >>

Thread Safety - Delivery Protocol x Delivery Channels
Posted by William at 9/17/2004 6:13:31 PM
Hi, I have a custom delivery protocol, which is described in the appconfig.xml file as several delivery channels - each with varying parameters passed. I'm finding some of the delivery channel arguements are being reset at various times and it looks like there might be a thread safety ...more >>

Creating Notification Services Application
Posted by I Wayan Saryada at 9/16/2004 3:56:43 PM
Dear All, From samples provided in the Microsoft Notification Services, each sample is created as a different application. Flight, Weather, Stock is created as a different application. Is it possible when creating a Notification Services more that one application is created at once using a ...more >>

Notifications log file
Posted by Tamim at 9/14/2004 5:11:03 AM
Hi all, I need to keep notifications log history for each subscriber to be viewed later, problem is NS periodically deletes the events to improve speed, isn't there any event i can use to backup data to another table before vacuumer deletes it? I hope there might be a simple way, instead of t...more >>

Format Mail Sent with xp_sendmail
Posted by William at 9/9/2004 9:55:38 AM
When sending the results of a stored procedure using sendmail, is it possible to format the output of the text?...more >>

'Pushing' messages to multiple recipients
Posted by Royd at 9/9/2004 4:35:13 AM
I'm currently engaged in using Notification Services to send alerts from an application. The straightforward model of users 'subscribing' to what their interested in and matching events with a rule is fine in some situations however in others we wish to be able to push messages to users. As ...more >>

how do i get started?
Posted by Joey Bove at 9/8/2004 7:51:27 AM
I see a need in my company to notify users of things so notification services seems a good place to start. but my question is what does the framework look like? I have a server with 4 sql server 2000 databases on it. all 4 represent different divisions of the company but the schemas a...more >>

Troubleshooting Delivery Failure
Posted by Zatoichi at 9/7/2004 12:45:51 AM
I can't get NS to even write to a simple text file. I get the message below in my Notifications table: "Delivery never attempted: first try pending" or "Delivery failed ". Can someone take a look at my Config and ADF excerpts and point me in the right direction? Thanks in advance. ...more >>


DevelopmentNow Blog