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 > 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 >>



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 >>


DevelopmentNow Blog