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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|