Groups | Blog | Home


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



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


DevelopmentNow Blog