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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|