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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi everyone, I need information about deploying SQL Server 2000 Notification Services in Cluster Environments. Any assistance will be appreciated. Regards. Sezgin Rafed ...more >>

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

Hi!, Is there some way to use MOM to monitor counters and events related to notification services? Thanks!...more >>

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