all groups > sql server notification services > july 2005
Subscriber.Enabled() returning incorrect result
Posted by Pinal P via SQLMonster.com at 7/26/2005 1:32:48 PM
I am giving my users the ability to disable their account from my NS front-
end web app and to do that I am using the NS API.
In order to disable the subscriber account, I
- instantiate a Subscriber object for the subscriber
- set its Enabled property to False
- call the Update() method
... more >>
IContentFormattar error
Posted by Yogesh K. at 7/25/2005 12:00:00 AM
I have implemented an IContentFormatter interface.=20
I have just implemented the format content method
Follow is the error I getting .
<NotificationServicesEvent>
<Description>
The notification could not be formatted.
</Description>
<Context>
<EventParameters>
<InstanceName... more >>
Application Definition Schema Reference
Posted by andyjax at 7/22/2005 3:12:01 AM
Why is it that the URL that is referenced for the NS is not available,
http://www.microsoft.com/MicrosoftNotificationServices/ApplicationDefinitionFileSchema?
It would be nice to have that up so intellisense would have the ability to
work. Anyone have answers for this?... more >>
Multiple events
Posted by Yogesh K. at 7/22/2005 12:00:00 AM
Hi,=20
I have a requirement I would need the NS to process multiple events. =
There would be different subscription for every different event.=20
But the notification remains same. The notification will go to a single =
subscriber.=20
Can I configure this on a Notification Service? How wo... more >>
Queries
Posted by Yogesh K. at 7/21/2005 12:00:00 AM
Hi=20
I am working on a project where =20
SQL Server Notifications as a major part of my exploration.=20
There are some practical difficulties I am facing in business =
implementation. I would want to discuss with you. I would be really =
thankful if you could help me with this.=20
... more >>
Notification resend logic
Posted by RDV at 7/20/2005 1:06:03 PM
I am using a subscription chronicle to manage only sending a
notification every X minutes where the subscriber picks X for each
subscription. My subscription logic to update the last time a
notification was sent basically mirrors the logic to determine whether
a match is found or not. This see... more >>
Notification Services API
Posted by Pinal P via SQLMonster.com at 7/19/2005 7:51:52 PM
I have Sql Server 2005 and Notification Services on one machine (DEVSQLSERVER)
and I am developing a web app on another machine (my workstation) that will
be front-end to my Notification Service instance on DEVSQLSERVER. So far all
the examples I've come across for connecting to an Notification... more >>
Installation of SQLNS on Virtual PC
Posted by Henrik Jaeger at 7/19/2005 1:42:27 PM
Hi all,
has anyone had experience installing SQL Notification Services SP1 on a
Virtual PC?
The VPC is set up with WinXP SP2, SQL Server 2000 SP4 (Developer Edition),
SQLXML 3.0 SP1 and Visual Studio 2003 (Enterprise Edition).
When I try installing SQLNS I get an error message saying: "... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Devices Question
Posted by andyjax at 7/19/2005 11:57:09 AM
Does it make sense to have a different subscription for each type of device?
Or is there a way to have the notification before formatted by two different
style sheets based on the Device Name?
We are looking to have at least 3 different layouts based on device type. To
get it working for ea... more >>
un-answered question got removed
Posted by InvalidLastName at 7/14/2005 5:59:23 PM
Hi,
I posted a qustion in this newsgroup on 07/08 without getting any =
responses. However, for some reasons, the post has been removed from the =
news server today (at least I cannot see it from my outlook express)
I can still found it from MSDN newsgroup web site =
http://msdn.microsoft.com... more >>
Error 22022: SqlServerAgent Error: Unable to resolve email recipie
Posted by saigman at 7/14/2005 7:52:01 AM
Hello:
I had SQL Notifications working fine. Recently, though, the notifications
are not being sent when a designated event occurs, and when I go to test the
operator e-mail configuration, I receive the message listed in the subjest
heading.
The changes that I know of on the server sinc... more >>
Computed Fields in Protocol Fields?
Posted by Scott at 7/8/2005 4:34:35 PM
Thanks for your responses to my last few inquiries!
Is it possible to use Computed Fields in the <Fields> section of the
<Protocol> definition? This would facilitate dynamic creation of Subject
lines for emails, which is something we are trying to figure out how to do.
Thanks,
Scott... more >>
NS standard v enterprise
Posted by kate at 7/8/2005 1:44:54 PM
any ideas why a build that is valid and proven in Standard , should
fail in Enterprise when building the generator rules ?
Kate MBCS
Alert Technologies
http://www.alert-technologies.co.uk
Get your notification services implementation going in minutes not
weeks ......
... more >>
Pause/Continue distribution, content formatting or delivering.
Posted by yurkin.roman NO[at]SPAM gmail.com at 7/8/2005 5:30:07 AM
Notification Services get an event and create the notification batch.
Can I pausing or stopping process of notification delivery with (or
without ) ability to continue?... more >>
Using just stored procedures to create and delete users
Posted by sidgam NO[at]SPAM hotmail-dot-com.no-spam.invalid at 7/8/2005 1:00:16 AM
Is it safe to use the follow stored procedures in the order below t
effect a bulk enrollment of users
1) NSMain.dbo.NSInsertSubscribe
2) NSMain.dbo.NSInsertSubscriberDevic
3) NSMain.dbo.NSInsert<SubClassName>SubscriptionSchedul
4) NSMain.dbo.NSInsert<SubClassName>Subscriptio
Is it safe to use... more >>
Reg IHttpProtocolProvider Problem
Posted by Muthu at 7/7/2005 11:05:02 AM
Hi,
I am a new person to SQL NS. I tried to execute the Walkthrough given
in the SQL NS Books Online. In that when I tried the "Task 10: Adding
the Custom HttpLogger Delivery Protocol", I'm facing one problem. The
result in not at all posted to the Destination URL which we specified.
Whe... more >>
Chronicles
Posted by andyjax at 7/7/2005 10:01:02 AM
Ok my mind is becoming mush after reading so much.
I seem to recall that notifications can leverage chronicles to eliminate
duplicate notifications for an event, such that key information that might be
triggered is only sent if what was sent before is different.
I cannot seem to find the ... more >>
Restarting NS$AppName service?
Posted by Scott at 7/7/2005 9:47:02 AM
Hi, and thanks for your followup to my "NotificationsDeliveryNotAttempted"
post the other day.
If the NS$[AppName] service was stopped for a time and then restarted, will
it pickup any events that were submitted during the down time? And if so,
is there some kind of a timeout setting where ev... more >>
Query Notification Through Web Services
Posted by DVinh at 7/7/2005 6:12:01 AM
Hi:
How can I implement 'Query Notification ie. sqlDependency' in web service
context so that a winform app calling that web service receives a
notification.
Thanks,
DV... more >>
No information is displayed in File Channel
Posted by Yogesh K. at 7/6/2005 6:57:35 PM
I have configured the Notification Service to deliver the notifications =
thorough a file channel. whenever the Notification service instance =
meets the criteria, it posts the event to the subscriber and generated =
notification file under the specified path under Config file, but no =
informat... more >>
SQL Notification Services -- Timeout
Posted by ashwinm NO[at]SPAM intelligroup-dot-com.no-spam.invalid at 7/2/2005 12:59:40 AM
Hi all,
I am so glad to find this discussion forums for SQL NS. I’m badl
stuck and need help
Background
I am currently working on an VB.NET + ASP.NET + SQL 2000 + SQ
Notification Services based application.
I maintain / enhance it. The application uses Notification Service
to send automated... more >>
searching good training example
Posted by flemming eriksen at 7/1/2005 12:41:19 PM
Hello NG.
I would investigate if some very small part of my App should be rewritten
under NS.
Have looked for a good example (VS03, Framework 1.2, SQL 2000) but not yet
found.
Could anybody help me?
Thanks,
flemming
... more >>
Using Triggers as event provider and notification instance state
Posted by Hilda at 7/1/2005 9:46:05 AM
Hi,
I have my event provider based on triggers, but sometimes I need to disable
the notification isntance.
The problem is that if the instance is disabled the firing trigger fails,
and all the transaction too.
In the event log appers the error message "The notification instance is
disable... more >>
Looking for a sample application
Posted by Yogesh K. at 7/1/2005 12:00:00 AM
Hi,
I have requirement as mentioned below
a.. There is table Say employee (with the information frequently keeps =
changing).=20
b.. There is another application interested in knowing the information =
thats modified at every moment the information undergoes change. say =
some kind of ... more >>
|