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

Standard Ed-Digest delivery work around
Posted by Next at 5/31/2006 9:38:01 PM
Hello, SQL Standard Ed doesn't support Digest Delivery. Is there a way I can simulate this and pass to the notifications table? I have three individual notifications going to a user. I want all of the individual email bodies to be in one email. I think I am asking how the XSLT formatte...more >>


Can I use NS to send alerts when logs files are grown?
Posted by Dinesh Priyankara at 5/29/2006 2:47:01 AM
Hi All, I have used "Performance Monitor" to track and send alter when files are larger than specified size. Is it possible to use NS to handle this type notification? Is possible, what is the best way? ...more >>

Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table or
Posted by emer.kurbegovic NO[at]SPAM gmail.com at 5/28/2006 8:22:47 PM
I am having problems enabling sql table for notifications in sql 2005. The problem is that when i use custom schema name i get following error: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table o...more >>

multipart mime emails with ssns built in SMTP Protocol
Posted by Phaitour at 5/26/2006 3:18:02 PM
Is there a way to send Multipart MIME emails with the Notification Service built in SMTP Protocol? Multipart emails being both text and HTML. Thanks in advance!...more >>

Installing SQL 2000 NS App on SQL NS 2005
Posted by Pete Zerger at 5/21/2006 1:08:23 PM
I have been working with some folks attempting to install the Notification Workflow Solution Accelerator for MOM 2005 on SQL 2005 Notification Services....an application that was written for the SQL 2000 version of Notification Services. We are able to perform the installation, but when ...more >>

monitor sql backups
Posted by Scott at 5/18/2006 10:33:02 PM
I currently receive a notification if my sql backup fails through sql agent. However, there is always an outside chance that the sql agent is not working either in which case I have no notification if my backups fail. Perhaps one can easily write a command prompt code to monitor the dates o...more >>

Using SPs to fire events - but the notifications dont get sent!
Posted by matt roberts at 5/18/2006 12:00:00 AM
Hi, I hope someone can help me! I have setup triggers on a table, so that when the table is inserted to or updated, it fires an event to my SSNS application, which should then send a notification email out. For some reason, the notifications are not being sent out. I cannot find any evid...more >>

Where are SSNS's dates coming from?
Posted by matt roberts at 5/11/2006 11:53:06 AM
Hi, I'm a little confused as to where SSNS gets its date information. If I connect to my SSNS database on my database server (local), and type "Select GETDATE()", I get the correct current date. But, the date information entered in SSNS tables is always offset by an hour. So for example ...more >>



Multi Server Deployment Scenario - What Port Does NS windows service use for communication?
Posted by sudhakar at 5/10/2006 6:52:02 PM
Hello All, I am having a multi-server deployment scenario. my DB Server will reside in our domain and would run the NS instance windows service . In other words, my DB server is behind a firewall. Our Web server would be outside this domain. the web server would host the subscription manageme...more >>

Creating an installer package for SSNS applications
Posted by matt roberts at 5/3/2006 12:00:00 AM
Hi, I want to create an installer package for my SSNS application. Its going to shipped to a number of clients, and each client will need to customise the installation to do things like set up local accounts for running the windows service, specifying the database name and server name, and ...more >>


DevelopmentNow Blog