SQL Server Notification Services Forum

The Notification SP [dbo].[NSAdministrationHistory] doesn't return a correct value for the delivered count.

Thu, 26 Nov 2009 16:16:08 Z

All,

The stored procedure [dbo].[NSAdministrationHistory] in ..NSMain db for sql server notification doesn't return a correct NotificationSuccessfulDeliveredCount. I think the problem is from a "AND DeliveryStatusCode = 0" filter. Does anyone know when MS will fix this problem.

Here is a query statement from the sp above.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------
SELECT @NotificationBatchesAwaitingDistribution = ISNULL(SUM(CASE DeliveryStatusCode WHEN 0 THEN 1 ELSE 0 END), 0),
                   @NotificationsSuccessfulDeliveredCount = ISNULL(SUM(CASE DeliveryStatusCode WHEN 6 THEN 1 ELSE 0 END), 0),
                   @NotificationsFailedDeliveryCount = ISNULL(SUM(CASE DeliveryStatusCode WHEN 1 THEN 1 WHEN 4 THEN 1 WHEN 5 THEN 1 ELSE 0 END), 0)
            FROM [FlightInstanceFlight].[dbo].[NSFlightNotificationsNotifications] WITH (READUNCOMMITTED)
            WHERE SentTime > @IntervalStartDateTime AND SentTime <= @IntervalEndDateTime AND DeliveryStatusCode = 0
---------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks in advance,

Dave

Sending mails to multiple id's

Thu, 19 Nov 2009 09:40:14 Z

Hi,

How to send multiple mails from SQL Server 2005.
The To-MailId's are to be picked from a query.

Please let me know how to implement this.

Regards,
Ruhani

The Operation Timed Out

Wed, 18 Nov 2009 17:55:59 Z

Running SQL 2005, I have a stored procedure that executes a query and sends an e-mail with pdf attachment to about 20-30 recipients. Occasionally messages are successfully sent but lately most are failing.

The ones that are failing have a "sent" date 4 minutes after the triggered request. The only error message reported in sysmail_event_log is: The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 8 (2009-11-17T18:06:41). Exception Message: Cannot send mails to mail server. (The operation has timed out.). )

We are not blocking port 25 and I am running out of options on how to resolve this. I have set the retry to 2 and extended the minimum lifetime for databasemail to 800 seconds, i will see what happens tonight (11/18/09).

how to unsubscribe from a subscription

Tue, 24 Nov 2009 12:35:48 Z

hi

If i have some scheduled subscription like news letter and users keep on subscribing to it. now if some subscriber wants to un-subscribe ... how to do that?

or is it any Schedule End property as there is ScheduleStart? i mean i want to end daily subscription say by 15 days?

Regards,
Rashmi

How to create one time schedules for subscriptons

Thu, 05 Nov 2009 13:52:06 Z

hi

I have a requirement to have a scheduled subscription where no recurrence is required that means notification should go only once. I cant configure this as event based as I required it to be triggered on some button click and should send notification and then should be done.

I gone through ScheduleRecurrence related documentation but it is not useful.

Please suggest.

Regards,
Rashmi

Mail not send through msdb.dbo.sp_send_dbmail when @Body contains a period(.) character

Wed, 18 Nov 2009 19:20:48 Z

Hi,

I am trying to use sp_send_dbmail to send a custom email. I am essentially using this for sending some custom alerts.

When I execute the following it works fine. I get the 'mail queued' message and I recieve the mail in mail account.

EXEC msdb.dbo.sp_send_dbmail
@recipients='jithin.jerald@xyz.com',
@subject = 'Trial',
@Body = 'Blank Message',
@profile_name = 'SQL Alert'

But when I execute the same with a period character (.) , it just shows up as "mail queued" but I never recieve it to my mail account.

EXEC msdb.dbo.sp_send_dbmail
@recipients='jithin.jerald@xyz.com',
@subject = 'Trial',
@Body = 'Blank Message.',
@profile_name = 'SQL Alert'

Due to this reaason I am not able to send any decimal values either which is what my original intent was.
Any help is much appreciated and apologize in advance if this is a stupid question.

steps to reach the properties of database in sql server enterprise

Tue, 17 Nov 2009 08:58:49 Z

How can i reach the properties of database in sql server enterprise in order to modify the query time out ?

How to define multiple notifications for a single application

Wed, 18 Nov 2009 14:21:21 Z

hi

I may be missing some basics but i am bit confused. My requirement is to write a custom formatter which can format my message template which has some placeholders those needs to be replaced with actual data before sending it to reciever.

My application has say 4-5 such message templates , all of these are having different data place holders. now each template actually represents a separate notification. but in IContentFormatter.FormatContent method i get array of hashtable where its nothing to know which hash belongs to what notification?

I mean how can i get appropriate set of data as per my notification? or do i need to write diff formatters for diff notifications?? i dont think so ...

so in short i need to get some data place holders replaced by notification fields data in message before delivering it so my question is where to keep these fileds data? is the notification field is appropriate place if yes how to match it according to specific notification? or do i need to keep single notification class having all data fields collection required by all notifications?

Pelase reply ASAP.

Thanks
Rashmi

Server Migration

Wed, 11 Nov 2009 21:19:06 Z

I need to migrate my NS application from one server to another. The servername/sql instance names are different on the new server.
Server A is the current production server. Server B is where I want to migrate it to.

I tried doing the following steps:
1. Created a new NS instance/application on the new server using the ICF/ADF (with the new servername B).
2. Detach the 2 NS databases that were created.
3. Move a backup from server A to server B and reattach the 2 databases.
4. Update the instance using server B as the server/sql instance name in the ICF/ADF.

The update fails. No meaningful error is given, just that the update failed. I am assuming when it compares these to what is stored within the NS instance/application databases, it sees the different names and fails. Can this be done this way? I need to keep all of the event/notification/retry data and don't want to have to manually move it all by scripting out inserts.

Thanks,

Mike

Event providers is disabled automatically

Mon, 09 Nov 2009 23:12:24 Z

Hi There,

I ran into some event provider disable issue days ago.

I am using SQL 2005 with Notification services. We have one application with six event providers. It work fine before but recently,

1) some of the providers get disabled by itself. I enable all of them but they get disabled again later.
2) I find some errors in event log (application). I believe there is some relation between them.

Source: NotificationServices

Event ID: 2026

Description: The event provider did not return from its Run method within the specified timeout period.

EventParameters:

Provider Name: Rule6

InstanceName: 123

ApplicationName: EmailAPP

Component: Event provider host

Thread: 13

Source: NotificationServices

Event ID: 2026

Notification Services is terminating the event provider because it returned an error from its Run method.

EventParameters:

Provider Name: Rule6

InstanceName: 123

ApplicationName: EmailAPP

Component: Event provider host

Thread: 13

Source: NotificationServices

Event ID: 2990

Description: The SQLProvider event provider failed to submit a batch.

EventParameters:

Provider Name: Rule6

Event Class Name: Rule6_ev

Description: Thread was being aborted.

InstanceName: 123

ApplicationName: EmailAPP

Component: Event collection

Thread: 18

Please give some advices on how to solve this problem. ( maybe the timeout error is the key? I am not sure)

Regards

David

How to Auto start Notification Services application?

Mon, 04 May 2009 12:41:14 Z

Hi,
Some of my technitians need to reboot my server time to time. Then, I need to manually go an start the Notification Application. How do I make it start automatically when the server starts?

DBMail Error: Protocol is not supported for sending mails.

Tue, 09 Sep 2008 18:35:17 Z

I'm receiving the eror message in the subject line when attempting to send mail via DBMail. My SMTP server is 127.0.0.1 (the IIS SMTP virtual server), so I don't believe that there is a firewall issue. In addition, I'm able to Telnet to that server on port 25, and manual send an email successfully, so I don't believe that there's a configuration issue with the SMTP server.

Does anyone have any idea why I would be receiving this error?

Thank you.

Problem with notification services on DB copied from another host

Thu, 05 Nov 2009 22:53:35 Z

I'm running SQL Server 2005 on Windows Server Standard 2003 SP2. Notification services seem to work fine from my web application, but are broken when activated from NUnit unit tests. I used the information at http://www.simple-talk.com/sql/t-sql-programming/using-and-monitoring-sql-2005-query-notification/ to determine that the subscription is successfully created, but something goes wrong when SqlServer tries to process the notification -- there is no "subscription fired" event -- and DbDataAdapter.Update fails with a SqlException that simply says "A severe error occurred on the current command. The results, if any, should be discarded".

SQL Server's ERRORLOG contains the following:

2009-11-05 16:55:25.46 spid55 ***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump0101.txt

2009-11-05 16:55:25.46 spid55 SqlDumpExceptionHandler: Process 55 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.

2009-11-05 16:55:26.02 Server Error: 17310, Severity: 20, State: 1.

2009-11-05 16:55:26.02 Server A user request from the session with SPID 55 generated a fatal exception. SQL Server is terminating this session. Contact Product Support Services with the dump produced in the log directory.

To the best of my knowledge, I've done all the things you need to do for a database that was copied from another host (alter authorization, set new_broker, set enable_broker).

Database Mail - User not receiving Emails

Tue, 03 Nov 2009 20:23:32 Z

I am trying to schedule email notifications containing the maintenance report using SQL 2005 Database Mail.

Once the maintenance job is completed, only the email addresses within the Database Mail Profile of “CompanyIT” is notified.

Profile Name: CompanyIT

SMTP Accounts

Priority 1 – User1 – user1@company.com

Priority 2 – User2 – user2@company.com

Priority 3 – User3 – user3@company.com

When the maintenance job is completed only user1 & user2 receives notification and user3 does not.

User1, User2 and User3 all have Database Mail accounts.

I moved user3 to priority 2 without any success

I restarted SQL Server Agent without any success

Any suggestions?

ms sql server 2005

Tue, 03 Nov 2009 13:14:43 Z

Error on

Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The Transaction Manager is not available. (Exception from HRESULT: 0x8004D01B)

Database Mail SMTP authentication

Fri, 25 Aug 2006 19:56:10 Z

SS 2005 Standard 64bit

I configured database mail and I suspect the SMTP authentication credentials are not being sent. Here are the two scenarios I have tried:

1) Use a local exchange server with basic authentication passing network credentials that have access to use the exchange service. I have a SS 2000 machine that is configure this way. Sending email to an address outside the domain fails with

"mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T14:02:23). Exception Message: Cannot send mails to mail server. (Mailbox unavailable. The server response was: 5.7.1 Unable to relay for ...."

I can send emails within the domain no matter what the credentials specified in basic authentication are, including invalid users.

2) Use a remote smtp server with basic authentication passing username (email address) and password, which fails with "The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2006-08-25T12:56:22). Exception Message: Cannot send mails to mail server. (Transaction failed. The server response was: 5.7.1 myaddress@me.com: Sender address rejected: Access denied)."

any idears?

SQLServer 2005 Notification Service

Mon, 26 Oct 2009 19:18:38 Z

hi,
I had created View in SQL server 2005 databse named Employee which contains the details of employee like: EmpID, EmpName, EmpEmailID etc.
I have requirement where i have to send notification to employee (in certain condition) using sQL server 2005 Notification Services taking his/her Email ID from EmpEmailID field of Employee view .

I have no knowledge about SQL Server 2005 notification Services.Please help me , how can i do this.

Error when sending mails thru database mail

Thu, 27 Aug 2009 12:05:33 Z

Hi All

I am receiving the following error when i send mails through database mail.

"The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 5 (2009-08-27T17:17:10). Exception Message: Cannot send mails to mail server. (The operation has timed out.)"

Regards
Sundaram R

Unable to get Email alerts

Fri, 16 Oct 2009 20:15:08 Z

I am not sure if I am in the right group.

I am trying to do the following on SQL 2005

- Email completion alerts from our maintenance jobs.

- Email task from SSIS tasks.

I have Database Mail running within Management Studio

I performed a test Email (Database Mail) and I got it.

I performed a telnet mailserver 25 test and I got it.

I have a receiver connection with the IP address of the SQL server on my mailserver.

I edited a maintenance job and setup an Email alert within the Notifications.

I run the job and I don't get Email alert (when the job completes)

Any ideas?

Thanks

Message 364 When Running Maintenance Plan

Tue, 22 Sep 2009 02:59:12 Z

I am receiving the following error when my maintenance plan runs:

[364] The Messenger service has not been started - NetSend notifications will not be sent

Now I am sure I can start the messenger service and set it to auto and this error will probably go away. I would rather not start the messenger service and figure out how I can make it stop another way. I did a search for this error and came back with a lot of posts but many were confusing. I am using database mail and I have a profile set up, as well as an operator. I am not sending any notification in the maintenance plan, but only via the SQL server agent when that job completes.

Any ideas?

Thanks,
Marty Shifflett

SQL Server 2005 Notification Services Components Package Availability

Tue, 09 Sep 2008 23:07:06 Z

The SQL Server 2005 Notification Services component package made available in the February 2007 release of the Microsoft Feature Pack for SQL Server 2005 is being updated to include Notification Services components, such as Notification Services server and client components, but will not include Management Studio integration. These updated components are designed to work with SQL Server 2005 and SQL Server 2008 databases.

The SQL Server 2005 Notification Services components package update will be released in two phases:

Phase 1: RC1

The SQL Server 2005 Notification Services component package RC1 is available from the Microsoft Download Center.

This release is a pre-release version and is available only for testing. Product support is not available for this pre-release.

Phase 2: RTW

Release to Web (RTW) will be released as part of the Feature Pack update currently scheduled for release as part of SQL Server 2005 Service Pack 3 (SP3). SQL Server 2005 SP3 is targeted for calendar year 2008. The SQL Server 2005 Notification Services component package update will be subject to the SQL Server 2005 Product Support Lifecycle policies.

SQL Server 2005 SP3 Notification Services

Starting with SQL Server 2005 SP3, the updated Notification Services will support using either SQL Server 2005 or SQL Server 2008 to host Notification Services Instance and Application databases.

Changes introduced in the Updated Notification Services Components Package

We have not changed core functionality of Notification Services in the components package. We made limited interoperability fixes to enable Notification Services command line tools and service components to work correctly when using a SQL Server 2008 Database Engine to host the Notification Services Instance and Application databases.

No feature additions were made.

Phase 1: RC1 - Deploying SQL Server 2005 Notification Services Components Package

The RC1 package can be installed on the same computer as an existing SQL Server 2005 Notification Services deployment. The existing deployment will automatically use the new service components installed by the RC1 package. Any Notification Services instances running on the computer should be stopped prior to installing the RC1package.

Before installing the RC1 Package, you will need to install a SQL Server 2005 Cumulative Update to enable Notification Services to connect to a SQL Server 2008 database server.

For the purposes of testing the RC1 package, the following prerequisites are needed:

1) SQL Server 2005 Notification Services

2) SQL Server 2005 SP2

3) Cumulative update package 9 for SQL Server 2005 Service Pack 2, or later

If you do not have SQL Server 2005 installed and wish to test the RC1 Package, an option is to install the Evaluation Edition of SQL Server 2005 for the purposes of testing RC1. Please note that the Evaluation Edition does have a limited license term (please see the Evaluation Edition license terms for details).

The Future of Notification Services

SQL Server 2005 is the last planned release of Notification Services. Microsoft believes “alerting” scenarios are valuable to our customers and we are looking at ways to include them in future product offerings.

How is UtcOffset stored in NSTimeZones table?

Fri, 04 Sep 2009 05:58:07 Z

Hi!!

I wanted to know what is the unit of UtcOffset which are stored in the NSTimeZones table?

I want to convert some other timezones to UTC say for example:

I want to convert India Time to UTC but I am not sure that where should I add the UTCoffset value to other time zone.. for a while I assumed that in millisecond but it is giving me the wrong conversion result:

Like I queried the sql browser in this way:
select DateADD(millisecond, 5940000, GetDate()) 'LocalToUTC', GetUTCDate() 'UTC'

where 5940000 is the value for UtcOffset columne stored for India Time Timezone in NSTimeZones and my server timezone has set to India time so GetDate() will return me the datetime value in Indian Time and I am adding its UtcOffset to get it converted into UTC and so should get matched up with GetUTCDate() and show the same result. but it is showing me different .. see for ex

LocalToUTC = 2009-09-04 13:01:30.867
UTC = 2009-09-04 05:52:30.867

I am using this data in my application and we are giving the user to select their choice of timezone from drop-down(contain timezones from NSTimeZones table) irrespective of their local time zone set into the machine. And then we have to convert the selected timezone date time to UTC to save it in database. That's the reason i need to handle this scenario in my stored procedure while inserting it ...

Please help me and please try to treat this as an urgent.

Thank a lot for reading it!!
Saba
fksaba@gmail.com

Event/trigger/notification from the sql server 2005 to C# application

Mon, 31 Aug 2009 16:40:55 Z

Hi Experts,

I am new to sql stuff. Please if you could guide me, I have a table that gets the data about status of machines and its connected devices, continousouly (large chunk of data). All the data is in the table in binary form. Suppose if device is active its bit is set as 1 otherwise 0.

My problem is when 1 bit data is entered in the table for a particular device, i.e device is active, c# application should tell/notifies the user, device is active or vice versa.

So I am thinking to put trigger on my table that check after insert sql query if the particular bit is entered 1. If yes then tell the user. But how C# application will come to know the result of the trigger operation on table? Any code example would be helpful.

Thanks n regards,

Maverick

Subscription management page not opening in Remote Database Server Deployment model

Mon, 24 Aug 2009 06:54:40 Z

Hi All,

We have used SQL NS Remote Database Server Deployment model and has three different servers for each DB, Notification WinService and Subscription Management page. However, Notification WinService working fine but Subscription Management page (ASP.NET) throwing exception as below:

[NSException: Notification Services failed to get the metadata for the specified instance.
Instance Name: NSInstance
SqlServerError:
Source: .Net SqlClient Data Provider
Number: 18452
State: 1
Class: 14
Server: DBSERVER\DB
Message: Login failed for user ''. The user is not associated with a trusted SQL Server connection.
Procedure:
}

We have registered NS instance on Subscription Management machine as well as on Notification WinService machine also.

Please help

Regards,
Bharat

How to setup a mail notification

Sun, 23 Aug 2009 06:38:17 Z

Hi All,

I have schedule some job in sql server 2000 .Now i want to set up an email notification under scheduled jobs.

Kindly let me know in detail steps starting from first step that how can i configure email notification.

Odd Notification Requirement

Wed, 12 Aug 2009 23:28:24 Z

Hello,

Scenario: SERVER1 sends out an event that it has gone down ("Server Down" event), the subscriber only wants to receive a notification if SERVER1 doesn't send out a "Server Up" event within a certain amount of time, we'll just say 5 minutes.

How would you do this in SQL-NS?

See my previous post if you're interested in seeing the direction I've been heading with this.

I could really use some ideas.

Regards,
Trevor

Visual Studio (BI Tools - SSIS, SSRS) 2008 with database SQL Server 2005

Wed, 12 Aug 2009 11:26:30 Z

Hi,

We developed the BI application SSIS 2005 and SSRS 2005 with SQL server 2005. During production move plan to use SSIS and SSRS 2008 with SQL Server 2005 database at backend. Please let me know with this confiugration if any known issues are there or any specific measures need to be taken up.

Thanks in davance for quick help.
-Raks

NSExecuteRuleFiring returns Invalid Column Name

Wed, 12 Aug 2009 21:15:54 Z

Hello,

I'm getting the following errors when SQL-NS instance fires my rule:

Description: The running of the rule failed. Please check the rule.
EventParameters:
  Application Name: Messages
  Quantum ID: 30040
  Rule Firing ID: 21218
  Rule Name: MessageEventRule
  Notification Throttle: 1000
  Event Class ID: 1
  Subscription Class ID: 1
  Rule ID: 2
  Rule Action: EXEC stp_Insert_Message_Alerts
  Stored Procedure Name: [dbo].[NSFire2]

SqlServerError:
  Error Number: 0
  Source: .Net SqlClient Data Provider
  Number: 207
  State: 1
  Class: 16
  Server: NOCMON-DEV
  Message: Invalid column name 'Date'.
  Procedure: 
  Line Number: 16

  Error Number: 1
  Source: .Net SqlClient Data Provider
  Number: 207
  State: 1
  Class: 16
  Server: NOCMON-DEV
  Message: Invalid column name 'Date'.
  Procedure: 
  Line Number: 16

Description: Invalid column name 'Date'.
Invalid column name 'Date'.
InstanceName: NOCMon
ApplicationName: Messages
Component: Generator
Thread: 4


For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

My ADF looks like this:

<?xml version="1.0" encoding="utf-8" ?>
<Application xmlns:xsd="http://www.w3.org/2001/XMLSchema" 
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 
  xmlns="http://www.microsoft.com/MicrosoftNotificationServices/ApplicationDefinitionFileSchema">

  <!-- Version -->

  <!-- Database Definition -->

  <!-- Event Classes -->
  <EventClasses>
    <EventClass>
      <EventClassName>NOCMonMessageEvents</EventClassName>
      <Schema>
        <Field>
          <FieldName>SourceID</FieldName>
          <FieldType>int</FieldType>
        </Field>
		<Field>
		  <FieldName>ErrorCategoryID</FieldName>
		  <FieldType>int</FieldType>
		</Field>
        <Field>
          <FieldName>Date</FieldName>
          <FieldType>datetime</FieldType>
        </Field>
        <Field>
          <FieldName>Station</FieldName>
          <FieldType>nvarchar(50)</FieldType>
        </Field>
        <Field>
          <FieldName>Message</FieldName>
          <FieldType>nvarchar(max)</FieldType>
        </Field>
        <Field>
          <FieldName>StatusID</FieldName>
          <FieldType>int</FieldType>
        </Field>
		<Field>
		  <FieldName>nUser</FieldName>
		  <FieldType>nvarchar(50)</FieldType>
		</Field>
		<Field>
		  <FieldName>nSubject</FieldName>
		  <FieldType>nvarchar(max)</FieldType>
		</Field>
      </Schema>
      <IndexSqlSchema>
        <SqlStatement>
			CREATE INDEX myIndex
			ON NOCMonMessageEvents ( SourceID );
		</SqlStatement>
      </IndexSqlSchema>
		<Chronicles>
			<Chronicle>
				<ChronicleName>NOCMonMessageEventsChronicle</ChronicleName>
				<SqlSchema>
					<SqlStatement>
						IF EXISTS(SELECT name FROM dbo.sysobjects WHERE name = 'NOCMonMessageEventsChronicle')
						DROP TABLE dbo.NOCMonMessageEventsChronicle
						CREATE TABLE NOCMonMessageEventsChronicle
						( [SourceID] int,
						[ErrorCategoryID] int,
						[Date] DateTime,
						[Station] nvarchar(50),
						[Message] nvarchar(max),
						[StatusID] int,
						[nUser] nvarchar(50),
						[nSubject] nvarchar(max))
					</SqlStatement>
				</SqlSchema>
			</Chronicle>
		</Chronicles>
		<ChronicleRule>
			<RuleName>NOCMonMessageEventsChronicleRule</RuleName>
			<Action>
				INSERT INTO NOCMonMessageEventsChronicle (SourceID, ErrorCategoryID, Date, Station, Message, StatusID, [nUser], nSubject)
				SELECT	E.SourceID, E.ErrorCategoryID, E.Date, E.Station, E.Message, E.StatusID, E.[nUser], E.nSubject
				FROM	NOCMonMessageEvents E
			</Action>
			<ActionTimeout>PT10M</ActionTimeout>
		</ChronicleRule>
    </EventClass>
  </EventClasses>

  <!-- Subscription Classes -->
  <SubscriptionClasses>
    <SubscriptionClass>
      <SubscriptionClassName>NOCMonMessageEventSubscription</SubscriptionClassName>
      <Schema>
        <Field>
          <FieldName>DeviceName</FieldName>
          <FieldType>nvarchar(255)</FieldType>
        </Field>
        <Field>
          <FieldName>SubscriberLocale</FieldName>
          <FieldType>nvarchar(10)</FieldType>
        </Field>
		  <Field>
			  <FieldName>SourceID</FieldName>
			  <FieldType>int</FieldType>
		  </Field>
		  <Field>
			  <FieldName>ErrorCategoryID</FieldName>
			  <FieldType>int</FieldType>
		  </Field>
		  <Field>
			  <FieldName>Station</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		<Field>
		  <FieldName>Description</FieldName>
		  <FieldType>nvarchar(max)</FieldType>
		</Field>
		  <Field>
			  <FieldName>Threshold</FieldName>
			  <FieldType>int</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TimeOfDayRangeBegin</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TimeOfDayRangeEnd</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TimeBuffer</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>AlarmGrouping</FieldName>
			  <FieldType>bit</FieldType>
		  </Field>
		  <Field>
			  <FieldName>GroupingTime</FieldName>
			  <FieldType>nvarchar(50)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>ElementContainer</FieldName>
			  <FieldType>nvarchar(MAX)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>AcknowledgeNotification</FieldName>
			  <FieldType>bit</FieldType>
		  </Field>
		  <Field>
			  <FieldName>SecondaryNotification</FieldName>
			  <FieldType>nvarchar(MAX)</FieldType>
		  </Field>
		  <Field>
			  <FieldName>TertiaryNotification</FieldName>
			  <FieldType>nvarchar(MAX)</FieldType>
		  </Field>
      </Schema>
      <EventRules>
        <EventRule>
          <RuleName>MessageEventRule</RuleName>
          <EventClassName>NOCMonMessageEvents</EventClassName>
			<ConditionAction>
			  <SqlLogin>NSRulesEvaluator</SqlLogin>
			  <SqlUser>NSRulesEvaluator</SqlUser>
			  <InputName>NOCMonMessageEvents</InputName>
				<SqlExpression>
					EXEC stp_Insert_Message_Alerts
				</SqlExpression>
			</ConditionAction>
        </EventRule>
      </EventRules>
    </SubscriptionClass>
	  <SubscriptionClass>
		  <SubscriptionClassName>ScheduledSubscriptions</SubscriptionClassName>
		  <Schema>
			  <Field>
				  <FieldName>DeviceName</FieldName>
				  <FieldType>nvarchar(255)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>SubscriberLocale</FieldName>
				  <FieldType>nvarchar(10)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>SourceID</FieldName>
				  <FieldType>int</FieldType>
			  </Field>
			  <Field>
				  <FieldName>ErrorCategoryID</FieldName>
				  <FieldType>int</FieldType>
			  </Field>
			  <Field>
				  <FieldName>Station</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>Description</FieldName>
				  <FieldType>nvarchar(max)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>Threshold</FieldName>
				  <FieldType>int</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TimeOfDayRangeBegin</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TimeOfDayRangeEnd</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TimeBuffer</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>AlarmGrouping</FieldName>
				  <FieldType>bit</FieldType>
			  </Field>
			  <Field>
				  <FieldName>GroupingTime</FieldName>
				  <FieldType>nvarchar(50)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>ElementContainer</FieldName>
				  <FieldType>nvarchar(MAX)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>AcknowledgeNotification</FieldName>
				  <FieldType>bit</FieldType>
			  </Field>
			  <Field>
				  <FieldName>SecondaryNotification</FieldName>
				  <FieldType>nvarchar(MAX)</FieldType>
			  </Field>
			  <Field>
				  <FieldName>TertiaryNotification</FieldName>
				  <FieldType>nvarchar(MAX)</FieldType>
			  </Field>
		  </Schema>
		  <ScheduledRules>
			  <ScheduledRule>
				  <RuleName>ScheduledSubscriptionsRule</RuleName>
				  <ConditionAction>
					  <SqlLogin>NSRulesEvaluator</SqlLogin>
					  <SqlUser>NSRulesEvaluator</SqlUser>
					  <InputName>NOCMonMessageEventsChronicle</InputName>
					  <SqlExpression>
						  INSERT INTO ScheduledNotifications(
						  SubscriberId,
						  DeviceName,
						  SubscriberLocale,
						  Description,
						  SourceID,
						  ErrorCategoryID,
						  Date,
						  Station,
						  Message,
						  StatusID,
						  [nUser],
						  nSubject)
						  SELECT r.[Subscription.SubscriberId],
						  r.[Subscription.DeviceName],
						  r.[Subscription.SubscriberLocale],
						  r.[Subscription.Description],
						  r.[Input.SourceID],
						  r.[Input.ErrorCategoryID],
						  r.[Input.Date],
						  r.[Input.Station],
						  r.[Input.Message],
						  r.[Input.StatusID],
						  r.[Input.nUser],
						  r.[Input.nSubject]
						  FROM ScheduledSubscriptionsRule r;
					  </SqlExpression>
				  </ConditionAction>
			  </ScheduledRule>
		  </ScheduledRules>

	  </SubscriptionClass>
  </SubscriptionClasses>

  <!-- Notification Classes -->
  <NotificationClasses>
    <NotificationClass>
      <NotificationClassName>
        MessageAlerts
      </NotificationClassName>
      <Schema>
        <Fields>
          <Field>
            <FieldName>SourceID</FieldName>
            <FieldType>int</FieldType>
          </Field>
		  <Field>
			<FieldName>Source</FieldName>
			<FieldType>varchar(max)</FieldType>
		  </Field>
		<Field>
			<FieldName>ErrorCategoryID</FieldName>
			<FieldType>int</FieldType>
		</Field>
			<Field>
				<FieldName>ErrorText</FieldName>
				<FieldType>varchar(max)</FieldType>
			</Field>
          <Field>
            <FieldName>Date</FieldName>
            <FieldType>datetime</FieldType>
          </Field>
          <Field>
            <FieldName>Station</FieldName>
            <FieldType>nvarchar(50)</FieldType>
          </Field>
          <Field>
            <FieldName>Message</FieldName>
            <FieldType>nvarchar(max)</FieldType>
          </Field>
          <Field>
            <FieldName>StatusID</FieldName>
			  <FieldType>int</FieldType>
          </Field>
			<Field>
				<FieldName>Status</FieldName>
				<FieldType>varchar(max)</FieldType>
			</Field>
		  <Field>
			<FieldName>nUser</FieldName>
			<FieldType>nvarchar(50)</FieldType>
		  </Field>
			<Field>
				<FieldName>nSubject</FieldName>
				<FieldType>nvarchar(max)</FieldType>
			</Field>
		  <Field>
			<FieldName>Description</FieldName>
			<FieldType>nvarchar(max)</FieldType>
		  </Field>
        </Fields>
      </Schema>
      <ContentFormatter>
        <ClassName>XsltFormatter</ClassName>
        <Arguments>
          <Argument>
            <Name>XsltBaseDirectoryPath</Name>
            <Value>%_AppPath_%</Value>
          </Argument>
          <Argument>
            <Name>XsltFileName</Name>
            <Value>MessageTransform.xslt</Value>
          </Argument>
        </Arguments>
      </ContentFormatter>
      <Protocols>
        <Protocol>
          <ProtocolName>SMTP</ProtocolName>
          <Fields>
            <Field>
              <FieldName>Subject</FieldName>
              <SqlExpression>'NOCMon Notification: '+CONVERT (NVARCHAR(30), GETDATE())</SqlExpression>
            </Field>
            <Field>
              <FieldName>BodyFormat</FieldName>
              <SqlExpression>'html'</SqlExpression>
            </Field>
            <Field>
              <FieldName>From</FieldName>
              <SqlExpression>'noc@captelmail.com'</SqlExpression>
            </Field>
            <Field>
              <FieldName>Priority</FieldName>
              <SqlExpression>'Normal'</SqlExpression>
            </Field>
            <Field>
              <FieldName>To</FieldName>
              <SqlExpression>DeviceAddress</SqlExpression>
            </Field>
          </Fields>
        </Protocol>
      </Protocols>
    </NotificationClass>
	  <NotificationClass>
		  <NotificationClassName>ScheduledNotifications</NotificationClassName>
		  <Schema>
			  <Fields>
				  <Field>
					  <FieldName>SourceID</FieldName>
					  <FieldType>int</FieldType>
				  </Field>
				  <Field>
					  <FieldName>ErrorCategoryID</FieldName>
					  <FieldType>int</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Date</FieldName>
					  <FieldType>datetime</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Station</FieldName>
					  <FieldType>nvarchar(50)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Message</FieldName>
					  <FieldType>nvarchar(max)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>StatusID</FieldName>
					  <FieldType>int</FieldType>
				  </Field>
				  <Field>
					  <FieldName>nUser</FieldName>
					  <FieldType>nvarchar(50)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>nSubject</FieldName>
					  <FieldType>nvarchar(max)</FieldType>
				  </Field>
				  <Field>
					  <FieldName>Description</FieldName>
					  <FieldType>nvarchar(max)</FieldType>
				  </Field>
			  </Fields>
		  </Schema>
		  <ContentFormatter>
			  <ClassName>XsltFormatter</ClassName>
			  <Arguments>
				  <Argument>
					  <Name>XsltBaseDirectoryPath</Name>
					  <Value>%_AppPath_%</Value>
				  </Argument>
				  <Argument>
					  <Name>XsltFileName</Name>
					  <Value>MessageTransform.xslt</Value>
				  </Argument>
			  </Arguments>
		  </ContentFormatter>
		  <DigestDelivery>true</DigestDelivery>
		  <Protocols>
			  <Protocol>
				  <ProtocolName>SMTP</ProtocolName>
				  <Fields>
					  <Field>
						  <FieldName>Subject</FieldName>
						  <SqlExpression>'NOCMon Notification: '+CONVERT (NVARCHAR(30), GETDATE())</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>BodyFormat</FieldName>
						  <SqlExpression>'html'</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>From</FieldName>
						  <SqlExpression>'noc@captelmail.com'</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>Priority</FieldName>
						  <SqlExpression>'Normal'</SqlExpression>
					  </Field>
					  <Field>
						  <FieldName>To</FieldName>
						  <SqlExpression>DeviceAddress</SqlExpression>
					  </Field>
				  </Fields>
			  </Protocol>
		  </Protocols>
		  <ExpirationAge>PT2H</ExpirationAge>
	  </NotificationClass>
  </NotificationClasses>

  <!-- Event Providers -->
  <Providers>
    <NonHostedProvider>
      <ProviderName>MessageSPEventProvider</ProviderName>
    </NonHostedProvider>
    <NonHostedProvider>
      <ProviderName>SQLTriggerEventProvider</ProviderName>
    </NonHostedProvider>
  </Providers>

  <!-- Generator -->
  <Generator>
    <SystemName>%_NSServer_%</SystemName>
  </Generator>

  <!-- Distributors -->
  <Distributors>
    <Distributor>
      <SystemName>%_NSServer_%</SystemName>
      <QuantumDuration>PT15S</QuantumDuration>
    </Distributor>
  </Distributors>

  <!-- ApplicationExecutionSettings -->
  <ApplicationExecutionSettings>
    <QuantumDuration>PT15S</QuantumDuration>
    <DistributorLogging>
      <LogBeforeDeliveryAttempts>false</LogBeforeDeliveryAttempts>
      <LogStatusInfo>false</LogStatusInfo>
      <LogNotificationText>false</LogNotificationText>
    </DistributorLogging>
	  <PerformanceQueryInterval>PT5S</PerformanceQueryInterval>
	  <SubscriptionQuantumLimit>1</SubscriptionQuantumLimit>
	  <ChronicleQuantumLimit>1</ChronicleQuantumLimit>
    <Vacuum>
      <RetentionAge>P1D</RetentionAge>
      <VacuumSchedule>
        <Schedule>
          <StartTime>23:00:00</StartTime>
          <Duration>P0DT02H00M00S</Duration>
        </Schedule>
      </VacuumSchedule>
    </Vacuum>
  </ApplicationExecutionSettings>

</Application>

The NOCMonMessageEvents Condition Action stored procedure looks like this:

ALTER PROCEDURE [dbo].[stp_Insert_Message_Alerts]

AS

DECLARE @matchID int

BEGIN

	SET NOCOUNT ON;

	INSERT INTO MessageAlerts(SubscriberId, DeviceName, SubscriberLocale, [Description], SourceID, Source, ErrorCategoryID, ErrorText, Date, Station, [Message], StatusID, [Status], nUser, nSubject)
	SELECT r.[Subscription.SubscriberId],
	r.[Subscription.DeviceName],
	r.[Subscription.SubscriberLocale],
	r.[Subscription.Description],
	r.[Input.SourceID],
	SRC.SourceName,
	r.[Input.ErrorCategoryID],
	ERR.ErrText,
	r.[Input.Date],
	r.[Input.Station],
	r.[Input.Message],
	r.[Input.StatusID],
	STAT.[LongDesc],
	r.[Input.nUser],
	r.[Input.nSubject]
	FROM MessageEventRule r
	INNER JOIN tblErrCategory_Sup ERR
		ON ERR.ErrorCategoryID = r.[Input.ErrorCategoryID]
	INNER JOIN tblSource_Sup SRC
		ON SRC.SourceID = r.[Input.SourceID]
	INNER JOIN tblStatus_Sup STAT
		ON STAT.StatusID = r.[Input.StatusID]

	SELECT @matchID = ErrorCategoryID 
	FROM MessageEventRule MER
	INNER JOIN ErrorMatchClearings EMATCH
		ON EMATCH.errorCategoryID = MER.[Input.ErrorCategoryID]

	IF @matchID IS NOT NULL
		BEGIN

			INSERT INTO ErrorMatches(SubscriberId, DeviceName, SubscriberLocale, [Description], SourceID, ErrorCategoryID, Date, Station, [Message], StatusID, nUser, nSubject)
			SELECT r.[Subscription.SubscriberId],
			r.[Subscription.DeviceName],
			r.[Subscription.SubscriberLocale],
			r.[Subscription.Description],
			r.[Input.SourceID],
			r.[Input.ErrorCategoryID],
			r.[Input.Date],
			r.[Input.Station],
			r.[Input.Message],
			r.[Input.StatusID],
			r.[Input.nUser],
			r.[Input.nSubject]
			FROM MessageEventRule r
			WHERE r.[Input.ErrorCategoryID] = @matchID

		END


END

The vb.net I am using to create the subscription (and I suspect this is where I'm doing something wrong?):

        Private Function GetSubscriptionData(ByRef e As Telerik.Web.UI.GridCommandEventArgs) As EventSubscription

            Dim editedItem As GridEditableItem = CType(e.Item, GridEditableItem)
            Dim s As New EventSubscription(EventSubscription.UserName)


            Dim svr As sqlsmo.Server = New sqlsmo.Server("MyServer")
            svr.ConnectionContext.LoginSecure = False

            svr.ConnectionContext.Login = "mylogin"
            svr.ConnectionContext.Password = "mypassword"

            Dim nocmonDB As sqlsmo.Database = svr.Databases("NOCMonMessages")
            Dim errorMatchClearings As sqlsmo.Table = nocmonDB.Tables("ErrorMatchClearings")
            Dim errorMatches As sqlsmo.Table = nocmonDB.Tables("ErrorMatches")
            Dim eventView As sqlsmo.View = nocmonDB.Views("NOCMonMessageEvents")


            Dim sourceDropDown As DropDownList = e.Item.FindControl("sourceDropdown")
            Dim errorDropDown As DropDownList = e.Item.FindControl("errorDropdown")
            Dim stationDropDown As DropDownList = e.Item.FindControl("stationDropdown")
            Dim txtDescription As TextBox = e.Item.FindControl("txtDescription")
            Dim txtThreshold As TextBox = e.Item.FindControl("txtThreshold")
            Dim txtTimeOfDayRangeBegin As TextBox = e.Item.FindControl("txtTimeOfDayRangeBegin")
            Dim txtTimeOfDayRangeEnd As TextBox = e.Item.FindControl("txtTimeOfDayRangeEnd")
            Dim txtTimeBuffer As TextBox = e.Item.FindControl("txtTimeBuffer")
            Dim txtGroupingTime As TextBox = e.Item.FindControl("txtGroupingTime")
            Dim txtElementContainer As TextBox = e.Item.FindControl("txtElementContainer")
            Dim txtSecondaryNotification As TextBox = e.Item.FindControl("txtSecondaryNotification")
            Dim txtTertiaryNotification As TextBox = e.Item.FindControl("txtTertiaryNotification")

            Dim strSource As String = sourceDropDown.SelectedItem.Value
            Dim strErrorText As String = errorDropDown.SelectedItem.Value
            Dim strStation As String = stationDropDown.SelectedItem.Text

            s.Station = strStation
            s.ErrorCategoryID = strErrorText
            s.SourceID = strSource

            Dim sourceOperator As nsr.SimpleOperator = New nsr.SimpleOperator
            Dim errorOperator As nsr.SimpleOperator = New nsr.SimpleOperator
            Dim stationOperator As nsr.SimpleOperator = New nsr.SimpleOperator

            If Trim(strSource) = "ANY" Then
                strSource = ""
                sourceOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.NotEquals
            Else
                sourceOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.Equals
            End If

            If Trim(strErrorText) = "67" Then
                strErrorText = ""
                errorOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.NotEquals
            Else
                errorOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.Equals
            End If

            If Trim(strStation) = "ANY" Then
                strStation = ""
                stationOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.NotEquals
            Else
                stationOperator = Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.Equals
            End If




            If txtTimeBuffer.Text <> "00:00:00" Then

                Dim clearingFilter As nsr.FilterRule = New nsr.FilterRule( _
                    New nsr.TableInputType(nocmonDB.Tables("ErrorMatches")), _
                        New nsr.FilterStatement( _
                            New nsr.SimpleLeafCondition( _
                                New nsr.FieldValue("Date"), _
                                    Microsoft.SqlServer.NotificationServices.Rules.SimpleOperator.LessThan, _
                                        New nsr.FunctionValue(nocmonDB.UserDefinedFunctions("TIMEBUFFER", "dbo"), _
                                        txtTimeBuffer.Text, New nsr.FieldValue("Date"))), _
                                            Microsoft.SqlServer.NotificationServices.Rules.FilterAction.Exclude))


                s.UserCondition = New nsr.AndCondition( _
                                    New nsr.SimpleLeafCondition( _
                                        New nsr.FieldValue("SourceID"), _
                                            sourceOperator, strSource), _
                                    New nsr.SimpleLeafCondition( _
                                        New nsr.FieldValue("ErrorCategoryID"), _
                                            errorOperator, strErrorText), _
                                    New nsr.SimpleLeafCondition( _
                                        New nsr.FieldValue("Station"), _
                                            stationOperator, strStation), _
                                    New nsr.LinkLeafCondition( _
                                          Microsoft.SqlServer.NotificationServices.Rules.LinkLeafOperator.Any, _
                                          clearingFilter, _
                                          New nsr.JoinClause( _
                                            eventView.Columns("ErrorCategoryID"), _
                                            errorMatches.Columns("ErrorCategoryID")), _
                                          New nsr.JoinClause( _
                                            errorMatches.Columns("ErrorCategoryID"), _
                                            errorMatchClearings.Columns("clearingErrorCategoryID"))))

            End If

            s.DeviceName = "myDevice"
            s.Locale = "en-us"
            s.Description = txtDescription.Text
            s.Threshold = txtThreshold.Text
            s.TimeOfDayRangeBegin = txtTimeOfDayRangeBegin.Text
            s.TimeOfDayRangeEnd = txtTimeOfDayRangeEnd.Text
            s.TimeBuffer = txtTimeBuffer.Text
            s.GroupingTime = txtGroupingTime.Text
            s.ElementContainer = txtElementContainer.Text
            s.SecondaryNotification = txtSecondaryNotification.Text
            s.TertiaryNotification = txtTertiaryNotification.Text

            Return s

        End Function

Note that where I am creating the clearingFilter, I specify ErrorMatches as the input table, yes ErrorMatches contains a field called Date, I tried changing the name of the field to fooDate, still I got the error, but updated to say could not find 'fooDate'.

When I use the debugging stored procedures and fire the rule I get:

Msg 207, Level 16, State 1, Line 16
Invalid column name 'Date'.
Msg 207, Level 16, State 1, Line 16
Invalid column name 'Date'.

Here is the XML for the Condition:

<NSRulesObject xmlns="http://www.microsoft.com/MicrosoftNotificationServices/RulesSchema">
<Condition>
	<And>
		<SimpleLeaf Operator="=">
			<Left>
				<Field Name="SourceID" />
			</Left>
			<Right>
				<Constant Type="System.String" Value="2" />
			</Right>
		</SimpleLeaf>
		<SimpleLeaf Operator="=">
			<Left>
				<Field Name="ErrorCategoryID" />
			</Left>
			<Right>
				<Constant Type="System.String" Value="51" />
			</Right>
		</SimpleLeaf>
		<SimpleLeaf Operator="&lt;&gt;">
			<Left>
				<Field Name="Station" />
			</Left>
			<Right>
				<Constant Type="System.String" Value="" />
			</Right>
		</SimpleLeaf>
		<LinkLeaf Operator="Any">
			<FilterRule>
				<InputType>
					<Table Database="NOCMonMessages" Schema="dbo" Name="ErrorMatches" />
				</InputType>
				<Statements>
					<FilterStatement Action="Exclude">
					<Condition>
						<SimpleLeaf Operator="&lt;">
							<Left>
								<Field Name="Date" />
							</Left>
							<Right>
								<Function Db="NOCMonMessages" Schema="dbo" Name="TIMEBUFFER">
									<Parameters>
										<Constant Type="System.String" Value="5" />
										<Field Name="Date" />
									</Parameters>
								</Function>
							</Right>
						</SimpleLeaf>
					</Condition>
					</FilterStatement>
				</Statements>
			</FilterRule>
			<LinkChain>
				<JoinClause SourceDb="NOCMonMessages" SourceSchema="dbo" SourceView="NOCMonMessageEvents" SourceColumn="ErrorCategoryID" 						TargetDb="NOCMonMessages" TargetSchema="dbo" TargetView="ErrorMatches" TargetColumn="ErrorCategoryID" />
				<JoinClause SourceDb="NOCMonMessages" SourceSchema="dbo" SourceView="ErrorMatches" SourceColumn="ErrorCategoryID" 							TargetDb="NOCMonMessages" TargetSchema="dbo" TargetView="ErrorMatchClearings" TargetColumn="clearingErrorCategoryID" />
			</LinkChain>
		</LinkLeaf>
	</And>
</Condition>
</NSRulesObject>

You can see the Date field referenced in the FilterRule.

The subscription saves just fine, so this all really boils down to the rule firing error.

I hope someone can help me or point me in the right direction.

Regards,
Trevor

Failing Database mail in clustered environment.

Wed, 29 Jul 2009 15:53:49 Z

Hi,
we had set up database mail which used to work fine. But now its been failing giving this messages:

Message
1) Exception Information
===================
Exception Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
Data: System.Collections.ListDictionaryInternal
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)
HelpLink: NULL
Source: DatabaseMailEngine

StackTrace Information
===================
   at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateCommand(DBSession dbSession)
   at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db)
   at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

I am completely out of clue. Any help would be appreciated.

Thanks

Setting up alerts!! Urgent.....

Wed, 29 Jul 2009 14:28:37 Z

Hi
I have 2005 box and need to set up alerts that will send email with respsetive message. I know that I have to configure database mail that use SMTP. My problem is, we are using Outlook express that use MAPI, so I am not being able to configure database mail. Please help me out to make outlook express works on 2005 box.

Thanks

I want to create an operator alert on my SQL 2008 server

Mon, 27 Jul 2009 22:34:33 Z

I want to create a operator Alert custom message that executes a job

the job task is to backup the database will full/diagnostic/logistic backups...

No database mail on SQL 2005 SP2 64 bit EE cluster.

Mon, 07 Apr 2008 18:17:08 Z

I've got database mail working on all my other servers except my cluster machine (running Windows Server 2003 64 bit EE).

I'm up-to-date on my service packs. The setup of database mail seems to work fine. Outlook Express works on that machine with the same account. My other database can send mail.

I've add all relevant machine information to the hosts file. I've dropped and recreate the profile. I've restarted the SQL Server Agent.

I get the successful "Mail queued" message, but I never receive anything.

Here's the message I get in my mail log:

1) Exception Information =================== Exception Type: System.NullReferenceException Message: Object reference not set to an instance of an object. Data: System.Collections.ListDictionaryInternal TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32) HelpLink: NULL Source: DatabaseMailEngine StackTrace Information =================== at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.GetAccount(Int32 accountID) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandFactory.CreateSendMailCommand(DBSession dbSession) at Microsoft.SqlServer.Management.SqlIMail.Server.Controller.CommandRunner.Run(DBSession db) at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

Anyone seen anything like this? Again, this is my only machine where database mail doesn't work.

Log to file if a mail was sent

Wed, 06 May 2009 04:23:22 Z

Hi,
Can I somhow log to a file if a mail was finally sent or not sent by the notification services? I am using SQL 2005

How To Install Sql Server 2005 Entrire Components in silent Mode

Fri, 18 Apr 2008 11:40:41 Z

Hi guys..

I have Developed an Application in vb.net. It Works Well in My Local Machine.. I want to Check that application in my Client Machine.. Before That, I also Check Whether SQL Server 2005 is installed or not in a Client Machien.. If not, Then My application Automaticaly Install Sql Server in silent Mode. Without any user interventions... After Completing that installation , My Appplication Would start that Normal Process.
I tried..But What i Found is Only , Sql Server Native Client and Sql Server Supported Files Are Installed. Sql Server Configuration Manager is not installed.. How I Solve this Problem... instance name are not Created How To Create An Instance..

I need Answers Very Urgent..

Help me.

Thanks in Advance
Gowri,G

What happend with NS in 2008?

Tue, 14 Aug 2007 21:13:17 Z

The cuestion is because now i´m trying to implement NS for my aplicactions but i´m afraid it is not supported in 2008 (or newest version)... at this moment Technet talk only about NS 2005... someone have information about NS 2008?

This is the driagram form Sql Server 2008...

http://msdn2.microsoft.com/es-mx/library/ms159106(sql.100).aspx

Where is NS 2008?

Thanks

Checking Delivery Failure Reasons / SQL Server 2005

Mon, 29 Jun 2009 17:20:51 Z

How can I check the reasons for Delivery failures by Notification Services? (I have looked everywhere I can think of without much luck.)
Does anyone know where I can get a simple example to figure out how this service works ????

I have been trying an example in Step by Step Books and everything seemed fine until I ran it. I can see all the data that should be in the in various tables, so everything looks fine on the face of it. But when I look at example, it has created about 20-30 tables and about as many stored procedures which makes it very difficult to track down the problem, its way too complex for what should be a simple example (hint to the authors here...). Anyway after looking through various views I found some evidence of delivery failure but no reason is given. I would have thought there would be log somewhere to indicate what went wrong but I cannot find it. See info below:

1	FileChannel	PGDESKTOP	29/06/2009 16:42	29/06/2009 16:42	Delivery failed	Birder1	Email	en-us	BN	21/02/1962 13:00	Fish Eagle on Crystal Beach
2	FileChannel	PGDESKTOP	29/06/2009 16:42	29/06/2009 16:42	Delivery failed	Birder2	Email	en-us	BM	22/02/1962 11:01	Giant Heron at Birdinia Marshes
3	FileChannel	PGDESKTOP	29/06/2009 16:42	29/06/2009 16:42	Delivery failed	Birder3	Email	en-us	BSC	21/02/1962 02:00	Night Owl at Pine Valley, mating calls
4	FileChannel	PGDESKTOP	29/06/2009 16:42	29/06/2009 16:42	Delivery failed	Birder2	Phone	en-us	BM	22/02/1962 11:01	Giant Heron at Birdinia Marshes
5	FileChannel	PGDESKTOP	29/06/2009 16:43	29/06/2009 16:43	Delivery failed	Birder1	Email	en-us	BN	21/02/1962 13:00	Fish Eagle on Crystal Beach
6	FileChannel	PGDESKTOP	29/06/2009 16:43	29/06/2009 16:43	Delivery failed	Birder2	Email	en-us	BM	22/02/1962 11:01	Giant Heron at Birdinia Marshes
7	FileChannel	PGDESKTOP	29/06/2009 16:43	29/06/2009 16:43	Delivery failed	Birder3	Email	en-us	BSC	21/02/1962 02:00	Night Owl at Pine Valley, mating calls
8	FileChannel	PGDESKTOP	29/06/2009 16:43	29/06/2009 16:43	Delivery failed	Birder2	Phone	en-us	BM	22/02/1962 11:01	Giant Heron at Birdinia Marshes

PG001

Consuming WCF in custom Delivery Protocol

Wed, 01 Jul 2009 15:18:53 Z

Hi

I am writting custom delivery protocol to get it work as per my requirements. I have message template service which gives me required data.

I have a WCF service , where should i keep client config as custom delivery protocol is going to be dll? where is the client workspace to keep my consumer bindings config?

Regards,
Rashmi

Can I use my database transactional tables as event data

Wed, 17 Jun 2009 16:12:45 Z

Hi

Can I use my application database table as a events data to match with subscriptions instead of creating events schema separately while creating NS application?

Regards,
Rashmi

About designing SQL based SSNS service

Wed, 20 May 2009 06:01:26 Z

I am new to SSNS and trying to configure survey launch notification system on my database.

I have some questions

I have created SQL based Event rule and provider rules, also managed to use my db as application db and joined event rule with my survyparticipant table. but somewhat confused in subscriptions and subscribers. what exactly is the difference between these two?

also can I use my surveyparticipant table itself as a subscription table? because anywas each participant is going to be subscriber.

another question is there any event generated once notification is sent to the particular subscriber? I have to update participant stauts once he / she is notified for survey launch.

another one is how it handles schedulers? I mean i want to launch survey at 3 pm to all participants now if there are many of them will it send first notification at 3 pm and last one at 3.30 pm??

I am using NMO for creating the service.

Any advice in this regards will be really helpful.

Reagrds,

Rashmi

ADF file creation

Tue, 16 Jun 2009 11:30:48 Z

Hi all, how can i create an ADF (Applicaiton definition file) in SQL server 2005 management studio?

thx in advance