all groups > sql server notification services > november 2004
SQL-NS Sample setup
Posted by Jeff at 11/30/2004 1:42:13 PM
I'm trying to get the samples setup for SQL NS. The docs state that you
should install the VS.NET enviroment on your SQL box. We are using a
development SQL box with SQL NS installed. When I try and open the .NET
sample code and rebuild I get a reference error for the SQL Libraries. Are
there in... more >>
Error firing rule with SQL 2005 NS
Posted by Jeremy at 11/29/2004 7:25:25 PM
I have created my first NS application in SQL 2005 Beta 2
but am not receiving the notifications. I ran
NSQuantumFailures to see what the problem is and it says
'Failed during rule firing(s)'. NSGetRuleFiring returns an
error code of 4045. Below is my EventRules section. When
I run the quer... more >>
NS databases + original database
Posted by Mark Pevsner at 11/29/2004 12:03:04 PM
I started to learn NS. I've understood there are at least 2 databases created
by MS SQL NS: 1 is for NS instance and 1 is for application for the instance.
I didn't understand how is my existing production database (MyStocks, for
example) is connected to the InstanceNS_DB & ApplicationNS_DB.
I... more >>
Event Driven Pattern
Posted by Marco at 11/28/2004 9:53:02 PM
Hello
I would like to implement a Event Driven Architecture and i am thinking
about SQL NS. What are other implementations of this pattern?
Kind Regards
Marco... more >>
Sql NS and Webservices
Posted by Jim at 11/28/2004 9:47:01 PM
Hi
I am a newbie to Sql NS and i am wondering whether it's possible to call a
webservice from the Sql NS framework. Is possible/smart to do this with SOAP
and can you give me an example how to do this? thanks for any input!
ch Jim... more >>
I couldnt install it.
Posted by Murat YILMAZ at 11/26/2004 12:24:32 AM
Hi gurus.
I have try to install notification services.But At the
start , setup disable 3 object on the install list.
engine Components,Client components and Bulk event
Submission. when I click to GO i says "This components
are needed for .NEt framework". And my environment is
Wimdows 2003... more >>
How to FTP via VPN to sites with real adresses on different IP's ?
Posted by Jason Robertson at 11/25/2004 5:43:15 PM
Hi,
I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted. The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z. So when the VPN
comes up using a private IP, I can't connect to any of the FTP sites u... more >>
Internal Error 2869
Posted by DTG at 11/24/2004 9:46:45 AM
When I attempt to Install NS 2 SP1, I get
"Internal Error 2869. SetupError"
Any ideas? I have .net framework 1.0 sp3 installed
and .net framework 1.1 sp1 installed. Windows 2000
advance server with latest sp, SQL2000 with latest sp.
All other prerequisites satisfied to my knowledge. ... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Notification Emails...
Posted by John Mc at 11/22/2004 7:21:25 AM
Hi,
I'm trying to add Notification Emails to an existing MS
Notification Services setup.
I have followed the instructions in the SMTP Delivery
Protocol section of the documentation and nothing seems to
be happening!
I've added a new Delivery protocol to each of the
subscription classes ... more >>
Custom Delivery Protocol (Thanks)
Posted by Ilker Tunca at 11/22/2004 5:33:23 AM
I would like to thanks to Shyam Pather and Joe Webb for
their helps about developing Custom Delivery Protocol. I
implemented successfully myCustomDeliveryProtocol with my
VB project.
Thank you Shyam and Joe.
Ilker Tunca ... more >>
code sample for tableupdate
Posted by Jim at 11/21/2004 1:37:06 PM
Hi
I know that it's possible to provide events for table
updates/deletes/inserts with SQL NS. Does anyone have a code sample for
this? (btw i have the 'Stock' application)
ch Jim
... more >>
the service cannot run your command at this time
Posted by jim beam at 11/18/2004 10:20:56 PM
Hi all
I am installing the Stock Sample application. When i type: net start
ns$chapter3
then i get:
the service cannot run your command at this time
thanks for any feed back
ch JIM
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewa... more >>
sql notification installation problem
Posted by SqlJunkies User at 11/17/2004 4:32:51 PM
Hi All
When i try to install sql notification services the i get the error:
the engine components and client components features require MS .Net Framework. INstall the ms .net Framework and run setup again to install these features
I installed the .net framework but i still get this message... more >>
Help on notification email
Posted by 2StovesForSale at 11/16/2004 9:25:29 PM
Application I'm working on will potentially have thousands of subscribers.
Thing is that some subscribers will subscribe to many events.
Is there a possibility to send one email that contains all notifications
instead of each notification to be sent separately.
Thanks
... more >>
delivery errors
Posted by Bryan Farrell at 11/11/2004 12:44:09 PM
<NotificationServicesEvent>
<Description>
The e-mail address or SMTP server value is not valid.
</Description>
<Context>
<EventParameters>
<Smtp server></Smtp server>
<Message recipients>bfarre***l@cr****.ca</Message recipients>
</EventParameters>
</Context>
<Description>
Cou... more >>
Error 1053: The service did not respond to the start
Posted by laksprasad at 11/11/2004 1:05:32 AM
Hi all
I am getting
---------------------------
Microsoft Management Console
---------------------------
Could not start the NS$WMITestInstance service on Local Computer.
Error 1053: The service did not respond to the start or control
request in a timely fashion.
--------------------... more >>
Custom Delivery Protocol with .Net Remoting
Posted by Ilker at 11/11/2004 12:15:54 AM
Hello,
I posted a message about creating a custom delivery
protocol to send notifications to a VB application. Shyam
Patter advised to use .Net Remoting or RPC for such an
implementation. But I didn't find a way to create a
delivery protocol using .Net Remoting, etc. Which of these
interf... more >>
File or assembly name XXX.10, or one of its dependencies, was not found
Posted by Simon Brooks at 11/10/2004 6:52:40 AM
Hi,
I am calling my DLL, which is depended on 2 other DLL's
that are in the same directory, using Notification
service. I get an Error written to the event log saying
that the dependent DLLs were not found:
<NotificationServicesEvent>
<Description>
The delivery protocol could not be... more >>
Custom Delivery Protocol
Posted by Ilker at 11/10/2004 4:11:50 AM
Hi everyone,
is it possible to send notifications to a VB application
by implementing a custom delivery protocol. So how?
Thanx.... more >>
Multiple Subscription with Single a Single Event Class
Posted by John Mc at 11/10/2004 2:50:01 AM
Hi,
I've got some trouble with setting up multiple
subscriptions classes that both use the same Event Class.
The way my system works is that notifications events are
written to a table in my DB. The MS Notification Services
checks the table every n time period. The batch of new
events is... more >>
SetupSample question
Posted by Sam at 11/9/2004 7:32:11 PM
My environment is SQL 2K SP3a, on Windows 2003 with .NET 1.1.
When I run the SetupSample with "domain\user" "password" sqlserver\instance
parameters, it seems to go through fine until the granting of permission for
extended SProcs. It fails with a SQL Server does not exist or connection
refus... more >>
Service did not start due to logon failure
Posted by laksprasad at 11/8/2004 8:40:04 PM
Hi All
I have created an NSapplication in Windows 2000 server,before creating
this application i ran SetupSamples.cmd in Notification Services
Command prompt which has created four sample instances in windows
services. and i ran Stock Sample it executed sucessfully.my own
application is also ... more >>
Email Notification Failure
Posted by laksprasad at 11/4/2004 2:06:50 AM
Hi
NS is able to generate Notification in the Notifications Table but it
is not delivering to the given mail id,the deliverystatus code in
Notifications table is showing as 4(Delivery Failed) iam using SMTP
Delivery Protocol.
I am able to send the notification to File when i am using File
... more >>
How to Use Stored Procedure instead of SQL Query in NS
Posted by laksprasad at 11/4/2004 2:05:34 AM
Hi
How to pass input parameters and retrieve out put parameters from a
stored procedure with Notification Services.
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com... more >>
Refresh a web page with NS
Posted by Ilker Tunca at 11/3/2004 10:43:34 AM
Hi,
I have a web application (ASP.Net based) that show some
information about production line activities. I want to
refresh a web page when a critical stop event occurs in a
production line. Stop events collected in a SQL table and
my event provider recognize them. But I didn't find a
sol... more >>
How to Catch WMI events from Notification Services
Posted by laksprasad at 11/2/2004 1:23:20 PM
Hi
How to Catch WMI events from Notification Services,i want to catch the
WMI Enents and store them in NSEvents Table,how to do this,can any one
give a sample for doing the same.
Thanks
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually check... more >>
NS Delivery Failure
Posted by laksprasad at 11/2/2004 1:22:41 PM
I can’t get NS to even write to a simple text file.
I get the message below in my Notifications table:
"Delivery never attempted: first try pending"
or "Delivery failed ".
--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conform... more >>
Delivery Status Code is storing as 0 in Notifications Table
Posted by laksprasad at 11/1/2004 12:43:58 PM
I got a Problem in Notification Services .
the data is stored in Notifications Table but the Delivery status code
is showing as 0,that is why it is not displaying the the file,i am
using FileSystemWriter Protocol.
Thanks in Advance
--
http://www.dbForumz.com/ This article was posted by a... more >>
|