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