Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server notification services > january 2006

Trouble with Notification Workflow Solution Accelerator
Posted by Pete Zerger at 1/31/2006 7:28:25 PM
I am working with the Notification Workflow Solution Accelerator (a solution accelerator for MOM), and I am not finding any official support statement or guidance on running the application on a clustered SQL instance, and have found conflicting claims of support in the MS newsgroups. Since ...more >>


error when loading ADF
Posted by unc27932 NO[at]SPAM yahoo.com at 1/30/2006 7:15:46 AM
I made a change in the EventProvider section of my ADF, now I'm getting errors when I go to update my NS application. When I click the ADF, I receive this error. Any ideas? An error occurred when parsing the XML file. File Name: C:\Program Files\Microsoft SQL Server\90\NotificationService...more >>

What's the lag time btwn EventsQuery & PostQuery?
Posted by unc27932 NO[at]SPAM yahoo.com at 1/30/2006 6:25:29 AM
In the DB where I'm storing my data, I have flags on which records need to be processed through Notification Services, to make it easy for my EventsQuery to go grab them. These flags are set up the chain by the application. After processing, using the PostQuery argument, I was going to reset t...more >>

Is this the right place?
Posted by Robby Tanner at 1/26/2006 4:03:40 PM
Hello, We are developing an application that requires some form of asynchronous callback to attached clients. Ideally, these events are user definable (well sysadmin definable) on the server and clients register interest in them when they connect. When such an event happens (table updat...more >>

Distributor slows to an imperceptable crawl (weekly or so)
Posted by David at 1/26/2006 1:21:03 PM
We have a notification services installation that stops performing (or slows to an imperceptable crawl) almost weekly. This week, the Distributor stops (or crawls at) generating work items. We are getting plenty of seemingly valid notifications, but no work items are assigned We're hours behi...more >>

Getting delivery confirmation
Posted by Bob at 1/25/2006 11:59:52 AM
I'm at the first stages of trying to use Notification services with sql server 2000 to deliver phone messages with an outbound phone calling application. So at this stage I'm doing a lot of reading and searching before I actually start coding. I do know one requirement of my project is that ...more >>

Something I don't understand.
Posted by Bob at 1/24/2006 5:41:52 PM
Well lots of things really but anyways ;-) I have an existing app using sql server 200 tables. One of the tables is DeliveriesToBeMade, in it I have all the information about a scheduled delivery (whoto, when, what, HowToNotify - phone or e-mail, phone number e-mail address etc.) I'm looking...more >>

API or stored procedures....which is better
Posted by unc27932 NO[at]SPAM yahoo.com at 1/24/2006 12:57:48 PM
I've read (or heard - can't remember) that we should use the API to handle subscription management. Why not just the Stored procedures? If we've got our data in other databases, why not just link to the NS server, and execute the SP to get the subscription data over? ...more >>



Is there any indicator that show that event generation is finished
Posted by R.D at 1/24/2006 6:01:02 AM
Hi all Can anyone tell me how to know that the events generation is finished and notification generation has started. or the ns is doing distribution of mails. I would like to know what exactly ns is doing(at what stage it is) programmatically is it possible. Thanks in advance -- Reg...more >>

Example Subscription Management App?
Posted by unc27932 NO[at]SPAM yahoo.com at 1/23/2006 6:47:58 PM
Are there any sample Subscription Management Apps out there that folks have done for NS 2005? Joe - I see that you've done one, but when I tried to build it, it told me that version 2.0 (I'm assuming the new NS stuff) wasn't compatible. Just was wondering if there were any other sample apps w...more >>

Odd errors with new Subscription Class
Posted by unc27932 NO[at]SPAM yahoo.com at 1/23/2006 6:57:01 AM
I am attempting to modify my existing Event Class, & add a subscription class. The basic summary is to send notifications to subscribers when a certain event happens within a user-specified radius of their subscribed address. So a user subscribes by inputting their address & desired radius - m...more >>

Stock walkthrough gives me an error
Posted by Bob at 1/22/2006 6:16:44 PM
On win Xp Pro Machine with sql server 2000 notification services sp1 and sql 2000 dev ed. I am at task 4, trying to run AddSubscribers.vbs The line nsInstance.Initialize "StockInstance" gives me error code 80131500 The registry entries for the specified instance of notification services ...more >>

Samples not working
Posted by Bob at 1/22/2006 12:04:31 PM
I installed notification services for sql 2000 on a win xp pro SP1 box with sql2000 developper edition. The installation went fine. Then I ran setupSamples SetupSamples MyComputerName\MyDomain\MyUser" "MyPassword" MyComputerName (Myuser on Mydomain is the way I normally logon to this machine...more >>

malevolent attacks
Posted by Imtiaz at 1/21/2006 3:44:59 PM
Is their any way to keep track of someone accessing our Database and also I need to get some notification when someone created any trigger, sp or tables in our db. Imtiaz ...more >>

Prob with rights on samples setup
Posted by g at 1/20/2006 7:47:41 AM
Hi, I am running the (SQL Server 2000 Notification) SetupSamples.cmd as follows: SetupSamples.cmd "myDomain\myUsername" "myPassword" myPCName and get this error: .... (preceding omitted as seemed to work ok) Granting rights... Running OSQL with the following flags: -SmyPCName -E "C:\Prog...more >>

SQL NS Books
Posted by j strate at 1/19/2006 9:35:30 AM
Does anyoen know how applicable are the books Microsoft SQL Server 2000 Notification Services and The Rational Guide to SQL Server Notification Services to SQL Server 2005? I am starting to dig into SQLNS, but would rather hobble on my own if a lot has changed between SQL2K and SQL2K5. Jaso...more >>

General Question
Posted by Robby Tanner at 1/18/2006 3:34:00 PM
Are notifications what I use to have the server notify attached clients of certain events? Essentially I want clients to register interest in certain DB events. When they happen, the server is to notify all registered clients. Regards, Rob ...more >>

Error Registering NS$Alerts Windows Service
Posted by j strate at 1/18/2006 1:59:23 PM
I have been attempting to register the windows service for notification services for the last few hours without success. The error message is always the same, show below. I've searched high and low through google groups and throughout the web to try and find a cause to this and have run out o...more >>

NS2005 does not work. What's wrong?
Posted by tarpan at 1/18/2006 12:07:30 PM
M$ SQL 2005 ASP.NET application on the same PC raises the exception: "The registry entries for the specified instance of Notification Services could not be found." ??? The "specified instance" is freshly created, registered, up and running. It worked fine on SQL 2000. ...more >>

Question about event generation on insert/update/delete
Posted by Franz at 1/18/2006 4:59:02 AM
Hi all, I've got some questions about using the Notification Services with Sql Server 2000. The problem is that I've to notify a remote Application about changes (insert, update, delete) in a certain set of database-tables via network. As far as I know, I've to use/implement IDeliveryPro...more >>

Where Get SQL Server 2000 Notification Services
Posted by g at 1/17/2006 2:23:43 PM
Hi, We have SQL Server 2000 but I am unable to locate the Notification Services for SQL Server 2000. Anyone know where I can get this? I've searched Microsoft and all I find is SQL Server 2005. thanks in advance...gary... ...more >>

How to access NS remotly?
Posted by tarpan at 1/17/2006 1:56:04 PM
Hi, It suppose to be real simple, but I can not find out how to do it. I have a SQL server and Web server on 2 separate PCs. When I create NSInstance object NS_Instance = New Microsoft.SqlServer.NotificationServices.NSInstance(NS_InstanceName) .Net tries to access NS right on the Web s...more >>

Stylesheet problem....help
Posted by unc27932 NO[at]SPAM yahoo.com at 1/17/2006 8:57:44 AM
My events are firing and my email alerts are arriving. But all that arrives in the body of my message is the "<" character. It's like it's not finding my stylesheet definition. I just used the one from the template and replaced the field names with my fieldnames from my ADF. Below is my style...more >>

Install issue SQL Server Notification Service
Posted by chriss3 [MVP] at 1/15/2006 4:12:49 PM
Hello, I have a install issue with the SQL Server Notification Service on Windows Server 2003 SP1, SQL Server 2000 SP4. During install it tells me I don't have the .NET Framework installed, How ever I'm sure I have the .NET Framework 1.1 running on the server. Is this a known issue? -- ...more >>

Agent alert not firing?
Posted by C_Hudson at 1/10/2006 6:55:03 AM
I have been working on SQL replication in a test environment, and after establishing a push subscription successfully, I turned my attention to notifications. I established and tested a MAPI inteface for SQL Mail. I created operators, enabled alerts, enabled email notification to the opera...more >>

Installation Error - "The database components require a qualified.
Posted by Cat Wakefield at 1/10/2006 3:13:03 AM
Hi, I'm attempting to install Notifcation services database components on our SQL server, in preparation for installing Business Scorecard Manager. The server is Windows Server 2003 SP1 with SQL 2000 SP4. When i try to install the database components of Notification services i get the erro...more >>

Email Notification with Custom Attachments using Notification Services 2005
Posted by Amby at 1/6/2006 1:57:26 AM
Hi all, I am now using Notification Services 2005.I have done with the configuration and deployment of Notification Services 2005.Now i wanted to know how to send notifications via email with custom attachments. Please help me out in this issue too as earliest as possible. Joe,Thnx fo...more >>

Problems getting NS project to run
Posted by Gary Rynearson at 1/5/2006 4:31:38 PM
Here is what I did to get an instance up and running (successful). Notice I have two groups of errors identified, both are in Step 3 and are preceded by lines I added in the format of "***** HERE IS THE <number> PROBLEM *******". (I included steps 1 and 2 just so you could see how I set thi...more >>

Any way to configure ns not to run again to avaoid dupes
Posted by R.D at 1/2/2006 11:29:03 PM
Hi we received duplicate notifications not because of maching rules but because of a strange proble. The Ns started events generation. But it was stopped before the notifications are generated. Again It was restarted resulting NS to generate events again.Now It has processed all the event...more >>


DevelopmentNow Blog