Groups | Blog | Home


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

Inconsistent Double-Ups out of the Generator
Posted by Jason Liddiard at 9/29/2005 11:17:27 AM
Using SQL2000 and NS 2.0sp1. I have read the SAMS publication of the MS SSNS by Shyam and have implmented an application into production. All was working well for a few days, until at random, it would doubleup the Notifications. It would only do this on random days, never consistantly. Always ...more >>


The notification could not be formatted.
Posted by Joe at 9/27/2005 4:14:04 AM
I've developed a custom formatter component to transform complex XML documents, and get the following error when trying to use it: <NotificationServicesEvent> <Description> The notification could not be formatted. </Description> <Context> <EventParameters> <InstanceName>NHSDInstance...more >>

Client app needs to know when data has changed
Posted by Joseph I. Ceasar at 9/26/2005 5:58:09 PM
Hi all, I am developing a multi user application using Delphi. Currently I am using a database engine that is terrible. I am considering switching over to SQL Server. One of the features that I could really use is for the client applications to be notified when data changed. That is, if...more >>

UTC time confusion between EM and Query Analyzer
Posted by dba56 at 9/23/2005 10:45:27 AM
I am testing Notification Services and the SQL Server Event Provider. It is working fine. The only thing that is confusing me is the times reflected in the NS tables depending on how I query them. Three events were added at 12:47:52 PM Eastern Time. When I look at the TimeAdded column of th...more >>

sql training course
Posted by Sher at 9/20/2005 8:58:04 AM
Hi all, I just inherited a sql server and database to support. Can anyone tell me of a sql course that does not include all of the network administrator stuff also. I just need to learn the ends and outs of sql management. Thanks, Sher...more >>

backup job email notification
Posted by Sher at 9/20/2005 8:55:10 AM
Hi all, I'm new to SQL and setup a backup job. I setup my internet email address as the person to notify when back completes. When I do the test I get the following error: Error 22022 SQLServer Agent Error: THe SQLserveragent mail session is not running; check the mail profile and/or the ...more >>

NS<product>Events not be cleaned down
Posted by J at 9/15/2005 8:48:38 AM
Hi, I'm having trouble with the NS<product>Events table not being cleaned down. Initially I thought it was because the vacuum event was clashing with the backup procedure on the server, so I moved the vacuum event to a time 5 hours before hand. Unfortunatley it made no difference, and the num...more >>

Images
Posted by Joe at 9/15/2005 8:31:07 AM
Is it possible to send out HTML emails with embedded images? If so, how can this be accomplished? Cheers Joe...more >>



Delivery Protocol Question
Posted by Andy at 9/15/2005 8:11:17 AM
Is there a place to get the information that is stored in the NotificationState for NotificationHeaders? Since all attributes are marked as internal we cannot get that information out. We are trying to build a MQ component and have Shyam's book, but we would like to pass along the Notificat...more >>

Rule Firing Error with MOM Notification Work Application
Posted by Pete Zerger at 9/14/2005 5:26:29 PM
I have installed SQL Notification Services w/ SP1 in my environment, as well as the MOM 2005 Notification Workflow Solution Accelerator. I am receiving an error relating to the rule firing. The detailed error message is listed below. Any advise as to next step in troubleshooting would be app...more >>

September CTP available
Posted by Joe Webb at 9/14/2005 11:52:14 AM
Hi everyone - Just wanted to let you know that the September CTP is now available for download from the Microsoft site. http://www.microsoft.com/sql/2005/productinfo/ctp.mspx HTH... -- Joe Webb SQL Server MVP ~~~ Get up to speed quickly with SQLNS http://www.amazon.com/ex...more >>

for shyam - error logging from the CDOMessage object of invocation
Posted by kate at 9/9/2005 2:30:16 PM
when CDO fails in the standard SMTP protocol assembly provided in NS, only the outer exception message is reported which is not very useful as the .net class is interopped to the com cdo class. you get the usual rubbish about 'subject of invocation failed' which covers almost any cdo error from ...more >>

Notification failure logic and options
Posted by RDV at 9/9/2005 12:03:58 PM
We have had some recent problems with our SMTP server cycling up and down. Because of this I am not receiving notifications. The NSNew<Application>AlertNotifications table contains the notifications with a DeliveryStatusCode of 4 = Delivery failed. Can I expect these to be reprocessed after ...more >>

Replace subscriber model?
Posted by reiale NO[at]SPAM gmail.com at 9/7/2005 4:04:12 PM
Hi, We have a sproc that dynmaically sends email to users via xp_sendmail. For a variety of reasons, we want to use SNS. However, our subscribers are dynamically generated in the sproc itself. Is there a way to replace the subscriber model w/in SNS and still have events fire? ideally, SNS w...more >>

Chronicle Debugging
Posted by Andy at 9/2/2005 4:21:32 PM
I am trying to find out why my chronicle is getting a double entry for each event. I am loading via a trigger into the view. Has anyone else had a problem like this, or give any debugging advice here? Thanks. ...more >>

E-mail notification when a record is added to a table
Posted by FRED at 9/2/2005 11:42:24 AM
I would like to be notified By E-Mail when a record is added in My SQL 2000 Database. How can I do That ?...more >>

How to handle dead notifications at Final Retry
Posted by InvalidLastName at 9/1/2005 4:09:17 PM
Notification services allows you to define number of retry attempts for the notification delivery. In addition to retry, I need to apply specific logic handle those undeliverable notifications (failed in all retry attempts) I would like to know is there any way to detect the current notificatio...more >>

SMS ? Pager ?
Posted by tarpan at 9/1/2005 2:16:02 PM
Hi guys, How to send a SMS message? How to send a message to a pager? If I send a message to email linked to a cellphone - it works just fine. But most users do not know the emails, they know only phone #. Is it any way to send SMSs based on phone #? Same question about a pager. Tha...more >>


DevelopmentNow Blog