Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Insert Matching Events to SQL Table

 
   Database Help (Home) -> Notification Services RSS
Next:  Using a Browser Front End to Print Reports  
Author Message
Rolando

External


Since: Feb 28, 2008
Posts: 1



(Msg. 1) Posted: Thu Feb 28, 2008 8:34 am
Post subject: Insert Matching Events to SQL Table
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

I have setup a few applications with NS, but always with SMTP as the
delivery protocol. I need to build another instance were the result
ends up as inserts to a SQL table. Can I accomplish this within the
ADF or do I need to build a custom delivery proctocol to insert the
rows?

Thanks
Rolando

 >> Stay informed about: Insert Matching Events to SQL Table 
Back to top
Login to vote
Joe Webb1

External


Since: Apr 28, 2004
Posts: 118



(Msg. 2) Posted: Tue Apr 01, 2008 1:42 pm
Post subject: Re: Insert Matching Events to SQL Table [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

You'll need to create a custom delivery protocol for that.
It's not difficult or even time consuming to do.

Once it's done, then you'll add a reference to the dll in the
application.

HTH..

Joe

--
Joe Webb
SQL Server MVP
http://weblogs.sqlteam.com/joew/





On Thu, 28 Feb 2008 08:34:13 -0800, Rolando wrote:

> I have setup a few applications with NS, but always with SMTP as the
> delivery protocol. I need to build another instance were the result ends
> up as inserts to a SQL table. Can I accomplish this within the ADF or do
> I need to build a custom delivery proctocol to insert the rows?
>
> Thanks
> Rolando

 >> Stay informed about: Insert Matching Events to SQL Table 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Event View does not return Events while NSEvent Table has .. - Dear group , my subscription rule uses View Names for both the Subscription and Event Tables. Even though the NSSubscription and NSEventClass tables have data, the rule does not find any rows using the views. After looking at the NSCurrentTables there..

How to send .NET events to applications - Hello All, I am new to NS, with some experience in using Files and email as the main mechanism for notifying applications. In my current scenario, I have a 2 tiered client-server system (.NET) and I would like to leverage SQL Notification Services to..

Is the trace flag (8720) needed? - I'm converting SQL7 to SQL2K. The database scripts have an statement: DBCC TRACEON (8720) It's from third party vendor for previous database build or update. I'd like to know if the trace flag 8720 still is needed for SQL 2K or not. If not, I'm going to....

High-level requirement for a pub-sub app - Thank you, Shyam, for your answer to my question regarding the distributor and delivery protocol objects. Your explanation was very helpful to me. Now I have another question for you and the group. I've been given a rough sketch of a possible futur...

Mapi error - I am trying set up notfication so it emails when jobs fail etcc. I am using sql server 2000 service pack 3A i have set up a mail profile and when I go into enterprise manger and go to test sql mail it says it opens and closes my mapi connection fine.....
   Database Help (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]