all groups > sql server notification services > january 2005
HTTPDeliveryProtocol
Posted by Mert Sakarya at 1/31/2005 4:54:41 PM
Is it logical to implement an "HTTPDeliveryProtocol" which makes thousands
of request to a web server - may be some server in the same network, which
can handle 200 requests per second ?
Or should I implement a "MQDeliveryProtocol" which makes HTTPRequests,
asynchronously (where I cannot keep... more >>
Email attachments via SMTP protocol
Posted by Trevor at 1/27/2005 6:53:49 PM
The SMTP delivery protocol that comes with Notification Services does
not allow you to send an email with an attachment.
I've looked into it and it seems that I'll need to write my own custom
delivery protocol to provide this functionality.
But..I'm hoping someone out there has already writt... more >>
Want to study and set up Notification Services
Posted by Hassan at 1/26/2005 9:20:36 PM
Is there any doc that i can follow step by step and be able to use
Notification Services ? What components do I need ? I have SQL 2000. I dont
know how to program.. But definitely want to basically get an idea ( the big
picture ) with examples.
... more >>
Stock sample and WebEventCreator.
Posted by Kevin Burton at 1/22/2005 12:11:01 PM
When I run the script to test the Stock sample some of the notifications go
to a file. I think I am getting those. Some are configured to use
HttpLoggerChannel. It is my understanding that this notifications go to the
http://localhost/NSSamples/Stock/HttpLogger.aspx URL. If I bring this URL up... more >>
Stock sample fails with permission problem.
Posted by Kevin Burton at 1/22/2005 7:33:03 AM
I searched and I could not see that anyone else had run into this problem. I
have a Windows 2003 Server. IIS, SQL, and .NET are all installed on my
development machine. This machine a member of a domain so I am logged in as a
domain user. When I try to run the Stock sample (adding subscription... more >>
Notification Service Instance update
Posted by JB at 1/20/2005 8:29:44 AM
Are there components like AMO (Analysis Services) for
Notification Services? Can I load a NS Instance through
code? Or does it have to be through NSControl.exe? Can an
NS Instance be updated through code say if I want to
change something about the Subscription?
... more >>
SQL Event Driven Application
Posted by yodatheyounger NO[at]SPAM gmail.com at 1/20/2005 2:30:48 AM
Hi
I've been charged with writing a service which needs to respond to
changes in data on an SQL 2000 database. For example a new row is
created in a certain table I want the service (which may not reside on
the same server) to be aware of this. Polling is not really an option
as potential... more >>
Notification Email Setup pt 2
Posted by John Mc at 1/18/2005 2:49:37 PM
Hi Guys,
I still can't find out whats wrong... Look slike I'm going
to have to implement the workaround.
If you guys spot anything in the two files I posted on the
other thread, can you let me know please?
Thanks,
John... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
NSControl Create ??
Posted by james at 1/18/2005 10:57:26 AM
The docs say to use NSControl Create to set up NS, and to use -in
configuration_filename but they dont say what that should contain.
nscontrol create
[-help] |
-in configuration_filename
[-sqlusername login_ID -sqlpassword password]
[-argumentkey key]
[parameter_name=value ... more >>
Notification Services failed to instantiate the event provider
Posted by BruceN at 1/14/2005 2:13:42 PM
The error I'm getting (it appears as soon as the NS service is started) is:
Method Initialize in type ProSite.RegisterEventProvider from assembly
Initialize does not have an implementation.
The class is a custom event provider I wrote and it works fine on a
different machine (my dev box) s... more >>
Notification Email Setup
Posted by John Mc at 1/13/2005 9:26:27 AM
Hi Everyone,
I was wondering if you could help me with an idiot proof
guide on how to configure NS to use SMTP.
I have performed the following steps:
1. Created a subscriber with a device of SMTP called
EmailChannel.
2. Included a SMTP Delivery Channel in the appConfig.xml file:
<Deli... more >>
Agent Mail
Posted by Michael at 1/13/2005 4:33:02 AM
Hi All,
I am having a problem setting up sql agent mail. I am running in with a
groupwise mail system but I have it running POP3 so I should be able to use
the agent mail.
The problem I am having is as follows.
I installed outlook 2000 sp3 onto the SQL Server.
I logged onto the sq... more >>
Is there a way to extend NotificationHeader, ReceipientInfo object?
Posted by sleepyjoe at 1/12/2005 9:14:11 AM
Is there a way to extend NotificationHeader, ReceipientInfo object?
I mean can I have some more information appended in ReceipientInfo
other then subscriberID and DeviceAddress? For example I would like to
add DeviceType, DeviceModelNumber etc. If yes, then how?
... more >>
licensing of SQL Notications Services
Posted by miriam healy at 1/7/2005 9:31:55 AM
Hi,
No where on the site can I find a definitve answer to
this faitrly basic licensing questoin:
Can I use the Enterprise Edition of SQL Notifiactions
Service on a single server with Standard SQL Server 2000,
or do I need Enterprise SQL Server 2000 on the server?
If someone coudl ans... more >>
Problem Transact-SQL Statement
Posted by Allen Yu at 1/7/2005 12:53:00 AM
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for u... more >>
need some help
Posted by Robert Smit at 1/5/2005 2:44:57 PM
hi,
tried several issues to solve this ploblem.
i want to install reporting service but during the install ill get " Error
1920. Service 'ReportServer' (ReportServer) failed to start. Verify that
you have sufficient privileges to start system services."
But im a domain admin. doing thi... more >>
Deployment of SQL NS in Cluster Environments.
Posted by Sezgin Rafed at 1/5/2005 10:11:05 AM
Hi everyone,
I need information about deploying SQL Server 2000 Notification Services in
Cluster Environments.
Any assistance will be appreciated.
Regards.
Sezgin Rafed
... more >>
CPU time at 100% after restart of an instance
Posted by Vince Sefcik at 1/5/2005 9:22:23 AM
I have both a production server and test workstation that I use for
application development. Simply to keep my test workstation from using CPU
time when not testing an application, I ususally stop the NS instance on
that machine. When I start up the NS instance at a later date, SQL Server
runs... more >>
MOM & NS
Posted by Hilda at 1/5/2005 8:39:08 AM
Hi!,
Is there some way to use MOM to monitor counters and events related to
notification services?
Thanks!... more >>
how to force retry
Posted by sleepyjoe at 1/3/2005 5:07:47 AM
My next retry schedule is after 5 hours, how can i force all of the
distributor work item run now? should not wait for next retry schedule.
... more >>
|