all groups > sql server notification services > april 2007
SSNS clustering
Posted by JohnH at 4/27/2007 10:50:04 AM
We have installed SSNS in an active-passive SQL cluster. All seems to go
well until the SQL group moves to the 2nd server. At that time, the NS
service fails to start and the group fails back over to the 1st server where
the NS service starts successfully.
In the cluster log, I see this e... more >>
SSNS Performance
Posted by CD at 4/25/2007 9:34:06 AM
Hello All,
In a previous email, Shyam Pather, asserted that:
"Overall, you should be aware that SQL-NS was specifically designed to
scale
well in high-volume applications. It has been deployed successfully in
many
real-life production environments, from low volume (thousands of
events/sub... more >>
Enterprise edition and SSNS
Posted by CD at 4/24/2007 10:43:10 PM
Hello All,
>From my readings, using SQL Server Enterprise edition would allow me
to use clustering and Multicast for SSNS.
Are there any other benefits that I might be missing? Scallability,
reliability,...?
What is th difference in cost in depleyment?
Kind regards
CD
... more >>
SSNS Performance
Posted by CD at 4/24/2007 10:39:31 PM
Hello All,
In a previous posting, Shyam Pather stated that
"Overall, you should be aware that SQL-NS was specifically designed to
scale
well in high-volume applications. It has been deployed successfully in
many
real-life production environments, from low volume (thousands of
events/subsc... more >>
Notification Services vs. Peer-to-peer
Posted by CD at 4/24/2007 10:22:43 PM
Hello All,
I am pretty sure that some of you may have faced a similar dilema...
We use a peer-to-peer notification framework in our system and have
been considering replacing it with SSNS. I have some experience with
SSNS but, in this particular case, have my doubts about whether it
would ... more >>
Changing the SSNS windows service to "start automatically"
Posted by Mwob at 4/20/2007 7:23:09 AM
Hi,
When we deploy our SSNS instance, the SSNS windows service that gets
created has a startup type of "manual" by default. We'd like to change
that to "automatic" so that it always starts up when the PC is
rebooted. Is there an option to control that?
Also, when we change the type to "auto... more >>
howto link notification class for subscription sql
Posted by abefuzzleduser2 NO[at]SPAM yahoo.com at 4/19/2007 5:53:49 AM
I have 3 subscrip events and 3 notification classes. All the
notifications are using the same notification class. I specify the
output channel in the sql subscrip. But i dont see where to add the
notif class in sub.
INSERT INTO [NSInstance].[NSSubscriberDeviceView]
(SubscriberId, Devic... more >>
Configure max number of events.
Posted by Sarah Kingswell at 4/18/2007 12:00:00 AM
Hi
Where do I go to configure the SQL 2000 Notification Services. We support
an application which integrates with notification services and we cannot
setup any new database scheme's due to a maximum number of events. I have
no idea where to go on the server to configure this?
Sarah
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Setting up Custome Delivery Protocol with MAPI
Posted by PH at 4/13/2007 8:53:47 AM
Hi,
We are exploring the idea of using Notification Services (SQL 2005)
and we found out that the out of the box delivery protocol is SMTP.
Our mail server is set up not to relay SMTP requests. Do you know how
much of a trouble would be to create custom delivery prococol using
MAPI. A search on... more >>
Multi-Valued Subscription Parameters
Posted by Todd C at 4/13/2007 5:30:02 AM
Hello All
I am setting up a Subscription class with two parameters; let's call them P1
and P2. However, the subscribers would like to have multiple combinations of
these two parameters. In other words, if they want 4 possible values for P1
and 3 possible values for P2, then they would need ... more >>
Windows Messenger
Posted by Justin at 4/10/2007 8:30:01 PM
Hello Everyone:
I have to appoligize...I had started this question in a different Group and
have been re-directed to this one...
Does anyone know how I can use Notification Services to create a Windows
Instant Message that will be sent to an individual whenever a new record is
created wi... more >>
Book Recommendations
Posted by Al at 4/10/2007 12:00:00 AM
Good morning all:
I would like some book recommendations for a novice @ Noification Services
2005.
Thanks,
Al
... more >>
How to set the quantum duration after the application is built
Posted by jayanthigk2003 NO[at]SPAM yahoo.com at 4/6/2007 5:19:37 PM
Anyone know how to change the quantum duration without have to rebuild
NS? We have a production NS and would like to increase the quantum
duration for scheduled subscriptions.
Thanks
... more >>
Permissions for NSEventBeginBatch
Posted by Todd C at 4/4/2007 1:18:01 PM
Hello all:
I will be using a non hosted Event Provider to 'push' events into the NS
app. IT will be done using the three stored procedures NSEventBeginBatch,
NSEventWrite, and NSEventFlushBatch written into UPDATE and INSERT triggers
on the tables in question. I can confirm that the triggers... more >>
How to clear event of scheduled subscripton?
Posted by Reid LI at 4/4/2007 12:00:00 AM
Hi, I have setup SQL 2K5 notification application with event and scheduled
notification through email. Everything seems all right. Email notification
can be sent.
When an event is generated, event email notification fire immediately and
scheduled email notification fire at scheduled time wi... more >>
Scheduled Rule not adding rows to Chronicle Table
Posted by Todd C at 4/3/2007 10:40:05 AM
I am building an app using Shyam Pather's book as a reference. I set up my
Scheduled Subscription Processing Times chronicle table no problem.
At the beginning of the <ScheduledRule> <Action>, the T-SQL is supposed to
insert a record into the chron table for any NEW subscriptions.
I can w... more >>
|