Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!


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 2007

Issues with sql mail in SQL 2000
Posted by Jack at 7/22/2007 2:16:01 PM
I am using Outlook 2003 and sql 2000 and POP email service. When completing backup jobs, I want an email notification to be sent out. The email is not being received. Only when I stop sql server and open outlook on the server do all the emails get sent out. If I keep outlook open on the se...more >>

Multiple Periodic Notifications to same Subscriber based out of single Event
Posted by raj at 7/21/2007 11:07:30 AM
We have a requirement where in we need to schedule notifications in folloing period: 1.) 2 days before the Order Start Date 2.) 1 day before the Order Start Date 3.) When the Order start date arrives I understand making application defination files for sending notifications for a s...more >>

Grouping Data for Consolidated Notification
Posted by raj at 7/21/2007 11:06:51 AM
We have a requirement where we need to send a single consolidated list of items belonging to a user which get active on particular date. So, for example Item 1, Item 2, Item 3 gets active. These entries are inserted as Events. Now, we need to send single notification to the user with the e...more >>

Using Notification Services for an event driven framework?
Posted by chris at 7/17/2007 8:10:13 AM
I am just reading up on this sql notification services and have a question. Has anyone used this for the basic use of just firing events when data changes? I need an event framework that we can easily add new events and this seems to be a good model for it. I'd like to be able to register a n...more >>

Publishcation Types 4 SQL-NS
Posted by James at 7/16/2007 4:34:43 PM
I have our production database on an SQL 2000 DB Server. I am developing a notification application in the new 2005 Server. My theory is to create a publication from the 2000 Server to the 2005 Server and then the Instance Applications on the 2005 Server will operate against the published da...more >>

Adjusting to user's local time
Posted by Andy at 7/10/2007 7:27:11 AM
Hi, I have a notification I'm sending out, and I'm storing an expiration date as UTC. I'd like to format this to the user's local time based on the subscriptions timezone setting. I can figure out how to do this, but I'd be tapping into NS' timezone tables and I'd like to confirm that this...more >>



DevelopmentNow Blog