all groups > sql server notification services > july 2004
Dynamic SQL within Actions
Posted by Grant Davidson at 7/29/2004 4:56:33 AM
Bit of a newbie question,
I have a requirement to allow a subscriber to subscribe to
customer information based on variable criteria :
E.g. They can say, let me know about any customer details
if the customer has x forename, y surname, a customer id
of z, dob of c etc.
However not all (inf... more >>
Document IDeliveryProtocol Assembly
Posted by Scot NS Curry at 7/28/2004 11:02:47 PM
I am not clear on how to document the IDeliveryChannel assembly. With the
Event classes, there is the very obvious AssemblyName and ClassName nodes
that do the trick. Could someone please enlighten me on how to document
that information. I am very tired of looking at the generic SMTP
implemen... more >>
Commerce Server + SQL Server Notification Services ?
Posted by Jedi at 7/28/2004 7:16:07 PM
hi, i am wondering that how i can integrate Notification service with
Commerce server to create more efficient B2C sites. Is there anyone worked
on this?
thanks in advance for any idea,help or leeding
... more >>
Cluste Server Configuration Failing
Posted by Mark Weiss at 7/28/2004 3:58:45 PM
We are deploying an existing NS application that has
previously been deployed on single app server/single
remote DB server configuration. We are deploying to two-
node app server cluster using Cluster Server, with a valid
virtual hostname in front of both nodes.
On the active node, I ran ... more >>
Email Notification Error 22022 inSQL server Agent
Posted by vv at 7/27/2004 11:51:08 PM
>> Hi,
>> I have SBS 2003 server and i have SQL 2000 , i have
>> configured automate backup daily, problem is when the
>> backup is not running some time i want to get mail
alert
>> for that i have treied to set the Mail agent the
>> followingare the task i followed
>>
>> 1. Go... more >>
Alternatives?
Posted by Ian Diaz at 7/27/2004 1:39:06 PM
Notification services is a great add-on but it isn't available for MSDE.
Are there other alternative engines/services (either a commercial or
freeware product) for this?
Thanks in advance.
Ian
... more >>
How to Enable Mail Notification on SQL 2000 With SP3a in SBS 2003
Posted by vv at 7/27/2004 3:08:58 AM
Hi,
I have SBS 2003 server and i have SQL 2000 , i have
configured automate backup daily, problem is when the
backup is not running some time i want to get mail alert
for that i have treied to set the Mail agent the
followingare the task i followed
1. Gone to administrative tools--> Se... more >>
NS service problem
Posted by masoud bayan at 7/25/2004 11:55:17 PM
I have NS service on a machine with Log on user set to NSUser (a windows
domain user), also I have this user in my sql server users as db_owner and
administrator for all databases (including Master DB). when I try to start
service it does not start and if receive follwing error in event log:
I e... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
IDeliveryProtocol
Posted by Alvin LeCount at 7/21/2004 11:27:03 AM
I have a custom delivery protocol much like the example in the online
books that invokes a stored procedure. When I try to debug it, break
points get hit just fine in the Initialize() method but I cant seem to
get the debugger to stop in the DeliverNotification() method. Does this
happen on a di... more >>
Passing parameters to store procedure...
Posted by Alvin LeCount at 7/20/2004 10:26:42 AM
How does one pass parameters to a stored procedure deliver channel?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!... more >>
:WHAT IS THE PORT NO
Posted by jaggu at 7/20/2004 12:12:22 AM
Dear sir,
I am connected my application for sql server thru the lan.
After i removed the lan connection. if the database is
there on same system what port no. i have to give for the
again for reconnection. when i am lan connection my port
no is 1433. what i have to give when i removed the... more >>
SQL Agent Mail Profile Greyed Out
Posted by bryan murtha at 7/17/2004 4:41:04 PM
I had Notifiication Services set up on a particular box. I
looked and it's not sending me anymore alerts. When I
stopped the Agent and Opened Outlook I was able to send
email to myself no problem. However when I went under EM
=> Management => Sql Server Agent => Properties, the SQL
Agent M... more >>
error in XML document NS (Urgent !)
Posted by Jedi at 7/15/2004 10:11:19 PM
hi, i am trying to create NS application independent to samples and
sapmles installation,
i did followings
- create new web app
- create win32 app in the same solution
- i have copied and include some cmd files from realtor sample with
configuring them to reala paths for example: if wr... more >>
Creating NEW APP
Posted by Jedi at 7/14/2004 3:07:19 PM
hi every one,
i am new on NS, but i am more amazing when i get deeper inside the
NS, i have allredy run all samples and i got how it works now i want to
create my application that based on scenario that using
SQLTriggerEventProvider to create notifications and mail as a delivery
... more >>
A Book on SQL-NS for developers
Posted by Shyam Pather [MS] at 7/14/2004 11:23:21 AM
Hello all,
I want to let everyone know about my upcoming book on SQL Notification
Services. The book is published by SAMS and is a developers guide to
building applications with SQL-NS. It covers all aspects of notification
application development, including design, authoring of the ADF/config
... more >>
RealtorDB URG!
Posted by Jedi at 7/13/2004 6:48:10 AM
i have compiled the realtor example, in the last step tell me to run sql
that "INSERT INTO RealtorDB..Listings values (N'2828 28th Ave SE',
N'BusyKids', 4, 3, 350000, N'A cute house with a great view. Contact Alfred
E Neumann or attend during the open house on Sunday') " but it gives error
"... more >>
SQL Mail Multiple recipients
Posted by Steven Zucker at 7/13/2004 5:24:07 AM
Any clue how to utlize SQL mail to multiple recipients?
platform Win2K Server / SQL 2000 / Exchange 2000... more >>
Some Questions
Posted by Jedi at 7/12/2004 6:56:10 PM
hi everyone,
i am new on NS, i have read all MSDN article about for my custom
application, i also discused sapmles that i have run. now time to jump into
code :), here is the scenario, i woul like to NS with my exist MS SQL Server
Database (all ready created) to send notification as mail... more >>
beginner question
Posted by Björn at 7/9/2004 4:09:07 PM
Hi
I´m developing an C# application where I need events when data in my
database changes or new data is created.
Someone told me to use Notification Services. Now I´m trying since monday
with the MS examples. The samples works fine but I didn´t really understand
the XML config files.
My qu... more >>
Follow up - Does not return in timely manner
Posted by Mark Weiss at 7/9/2004 12:38:54 PM
I now found in the documentation that the Run() method
must return in 5 minutes or this error will occur. Based
on the log timestamps generated by our custom Event
Provider, this is what happened. So my question is, what
is Microsoft's (or anyone else who has run into this
issue) recommen... more >>
Does not return in timely manner from Run
Posted by Mark Weiss at 7/9/2004 9:07:53 AM
What can cause this error to occur: "The application did
not return in a timely manner from the Run method." The
terribly unfortunate behavior in these circumstances is
that NS shuts down the custom Event Provider that timed
out. Even more unfortunate is that the process continues
to run... more >>
help query
Posted by MC at 7/9/2004 8:30:34 AM
I have the tables SendController (controllerID int, date datetime,
regionID int, mission ntext)
i want to select all controllers that didn't go to the same region 10
times consecutively.
How to do that???
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET... more >>
Errors or not?
Posted by JRC at 7/7/2004 3:41:30 PM
Can anyone give me an idea of what these mean?:
2004-07-06 22:00:01.95 spid12 Opening file
e:\mssql7\data\GM_GtaxPrep_Log.LDF.
2004-07-06 22:00:02.57 backup Database backed up with following
information: Database: GM_GtaxPrep, creation date and time:
2001/08/30(10:09:43), pages dumped: ... more >>
SQL 2005 Notification Services
Posted by Hendrik at 7/4/2004 5:25:02 PM
Hi
I have read a lot about SQL notification services
I would like to testdrive it to see if it will provide in my requirements
We are developing on SQL Server 2005(Yukon), but I have no idea where to find notification services to install it. There is a notificatin service directory after insta... more >>
|