all groups > sql server notification services > february 2007
Using Links in the xslt formatter
Posted by Todd C at 2/28/2007 11:13:10 AM
I am fairly new to NS but learning more as the 'beast' grows!
I have a simple notification class that includes an integer field that, when
added at the end of an hyper-link, yields a valid link the user can click
right from within his/her e-mail to get more details.
In my xslt format file... more >>
Email-NS
Posted by chakris at 2/22/2007 2:11:00 AM
Hi All,
I am very much new to Notification Services. I have to perform a task like
when ever there is some updations in one of my DB tables i have to get some
Alerts like an email. Then i came accross this Notification services. But i
dont know to acheive this functionality.
Can any suggest... more >>
NS Management API & Transactions
Posted by Andy at 2/21/2007 5:28:47 AM
Hi,
I have some subscription management code which is part of a larger
update. I'd like the whole thing to run within a transaction. If I
simply use the new TransactionScope and keep all my update logic + the
API calls within the scope, will the ENTIRE set of updates occur
within a transact... more >>
Using NS for Reminders question - Duplicate notifications
Posted by Rolando at 2/19/2007 2:28:34 PM
My requirement is to allow users to subscribe to notifications when a
task has been created, and also to schedule reminders that the task is
still pending. I have the notification at time the task is created by
an event-triggered subscription, and that works fine. I then created a
scheduled subs... more >>
Order in which datasets executed
Posted by Sanjeev Rampersad at 2/16/2007 12:00:00 AM
Can one specify the order in which datasets are executed in the report?
Thanks
Sanjeev
Order in which datasets executed
... more >>
SHAREPOINT PASSWORD RESET
Posted by Rafael at 2/14/2007 8:00:58 AM
Does anyone know if sharepoint 2.0 has a feature that prompts new users to
change their password when they first access a portal?
Thanks.
--
Rafael... more >>
Notifying on latest event only?
Posted by Andy at 2/12/2007 12:22:20 PM
Hi,
I have an event which may come into the Ns system. The event is a
release of software. A new version can sometimes be released two or
three times in a week. In that case, I only want to deliver the last
event and discard the rest.
Is there a way I can do this with the built in capabi... more >>
NSTimeZone and TimeZoneID in Scheduled Subscriptions
Posted by Todd C at 2/9/2007 11:57:01 AM
I am going through Shyam Pather's book to get myself up and running on NS.
His source CD has a utility that loads scheduled subscriptions into the
appropriate table.
I use it and assign a time zone of "(GMT-05:00 Ineian (East)" for my
subscription.
Looking in the NSTimeZone table, I see ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
time event?
Posted by Andy at 2/9/2007 11:44:20 AM
Hi,
I have some data in my database which stores when a contract expires.
I'd like to send a notification 90, 60 and 30 days before the contract
will expire.
I'm having trouble coming up with a good event to trigger
notifications. Do I setup the event class just to run once a month?
A cus... more >>
Impact on SQL Server
Posted by Rolando at 2/9/2007 9:08:02 AM
I have NS installed on another machine seperate from a SQL 2000
server. I notice that when I start the NS service on the seperate
machine, the processor on the SQL 2000 spikes to approx 50% and
remains there contantly. When I run profiler I notice that the NS
service is constantly performing que... more >>
Upon a notification failure, all subsequent notifications stop
Posted by BigDave at 2/7/2007 6:41:21 AM
Hello again,
Here's our current hurdle. We have a certain event that translates
into 6000 notifications. Our content formatter calls a web service.
Afer about 1000 notifications, IIS reports "Faulting application
w3wp.exe..." and presumably the web service fails and resets.
I need to use ... more >>
Way to increase Distributor timeout?
Posted by BigDave at 2/3/2007 1:30:54 PM
Hello all,
We have built a custom content formatter which creates a report via
Reporting Services.
Unfortunately, for some subscribers, the report can take a minute or
more to generate.
We have found that whenever the content formatter takes more than 15
seconds, the NS Distributor retur... more >>
Logging?
Posted by Andy at 2/2/2007 7:52:08 AM
Hi,
I'm trying to debug my NS application. Is there anyway to log the
actions which NS is taking? Such as running subscriptions, processing
events, etc?
... more >>
Added schedule and that stops notifications?
Posted by Andy at 2/2/2007 5:49:18 AM
Hi,
I'm using the Sql 2005 NS book from Pather, and I got my notifications
working fine when they are delivered as the events arrive in digest
form.
I then, closely following the book, tried to add scheduled delivery,
so that notifications are built up and sent at a scheduled time.
The p... more >>
Getting events upon DB changes (NOT SCHEDULED)
Posted by Elad Gov-Ari at 2/1/2007 7:22:32 AM
Hi.
i'm trying to set an Event Provider that will provide me with events
when a specific data changes in a specific table in the DB.
I've noticed that the built-in SQL Provider polls the DB using a
schedule and that doesn't help me.
I'm thinking of implementing a customed event provider ... more >>
|