Hi everyone, We have to solve a problem and I need expert help. The situation is as follows: We have an ASP.NET Web Application running on IIS 6.0 NLB Cluster. It connects to clustered(Virtual) SQL Server 2000. There are a number of production lines and users at each line. The user start...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

I keep getting these messages. Not sure what to do! Event Type: Error Event Source: NotificationServices Event Category: None Event ID: 4020 Date: 10/29/2004 Time: 12:35:48 AM User: N/A Computer: NTF Description: <NotificationServicesEvent> <Description> The generator faile...more >>

Does anybody know to configure SQL Agent Alert to trap events from performance monitor such as free space in the Hard Disks, and notify the operators? Thank very much. Rose...more >>

Hi Thanx Joe and Shyam. Working in XML is not a issue for me, Iam comfortable in XML\XSL\XPATH. Just that when I was working with the samples, the samples just keep asking you to run the DOS cmd scripts, without explaining what they do in detail. When I run the samples all we do is keep cha...more >>

My application quantum clock shows 6 hours a head of real time. How do I fix this? ...more >>

Hi, Can i send notifications to an application or can i define such a variable "Protected WithEvents...." in .Net project to collect notifications? Thanx...more >>

Hi Can anybody tell me which template to choose in VS.NET 2003, to make a Notification project. Can anybody explain how to make a project from scratch in VS.NET 2003. I actually couldnt find any such information, I want to know how are the Rebuild scripts and other such scripts wanted for, ...more >>

Hi, I have set up an Active Directory, Certificate Services on Windows 2003 Server. I am running SQL 2000 Server. AD and Certificate Services were installed correctly. My goal is to be able to use SSL when connecting to SQL Server via Query Analyzer. I also want to keep the SQL Server insta...more >>

Hai when i am going to start my services in local machine i am getting error 1053.. i dodn't know that what actually problem. please help me in that problem --- Posted using Wimdows.net NntpNews Component - Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supp...more >>

I'm looking for a way to send out notification to users using MSN/Yahoo/AOL messenger. I heard of that Live Communication Server can do that (version 2003 to MSN, upcoming version 2005 to all 3 kinds of clients). Can anyone confirm that? What is Connetor Service? Do I need it or all I need jus...more >>

Can anyone point me in the direction of a custom filesystem watcher that watches for files other than XML? The situation I have is files coming into folders where they then have to be loaded in SQL Server. The files will not be XML files (and I can't specify that they should be). I need a w...more >>

Hi Iam new to the Sql Notification Services, Iam working with the Stock sample. The ADF and Config file Concept is clear to me, but I cant understand how the eniviornment variables in the cmd file are picked up, where are these cmd files usage explained in the SDK. Kindly reply asap. Th...more >>

Hello, I read a recommendation that it’s preferable to encode event rules in stored procedures rather than encoding SQL directly into the configuration and application definition files. How can I add my own stored procedure to the Notification Services application so it gets generated ev...more >>

As happy as I am with notificaiton services, one of the big lacks I've found is in the tools available to integrate it with existing applications. Specifically, the XML and dynamic table approach is great for creating applications, subscriptions, and events... but there's no real way to manage ...more >>

Hi, I've a requirement to create a Single Use Subsciption, a subscription that is created and once it has been used to create a notification is removed. I've been looking through the NS documentation, and cannot find anything about such Subscriptions. So I've been trying to figure out...more >>

I'm trying my best to avoid doing any direct access to the NS tables, but I'm really finding it difficult to maintain that practice. The particular problem I'm having right now is that I can't seem to gracefully update a field in a subscription from classic ASP using COM interop. The followin...more >>

Hi, I've got a problem with my Notification Services installation that has completely foxxed me... Notification Services as running absolutley fine, until the database had to be taken offline for maintence. When the database was restarted, everything appeared to run up ok again, no er...more >>

Hi, everyone. I'm getting started with notification services and so far it's been a blast. I've got a question about best practices: is it generally better to define events using the minimum of columns, and then join those columns against application tables in the notification rule, or to ju...more >>

I would like to know how any of you are handling the returned email from a message sent via CDOSYS on SQL server. We are using it to send out subscription renewals nightly in mass and if the email account we are sending it to is no longer valid, we want to be notified. We would like to be not...more >>

the field name in /NotificationClasses/NotificationClass/Protocols/Protocol/Fields/Field/FieldName section, when passed over to custom delivery module, lost its original case, become all small case. For example, if I put <FieldName>LeavingFrom</FieldName> in ADF, I see smallcase"leavingfrom...more >>

I have table order(orderid (identity), orderdate) and table orderDetail (orderDetailID(identity),orderid, productID, qty) and trace tables: Table TOrder(orderid, orderdate, actionid, actionDate, actionUser) Table TOrderDetail(orderdetailID, orderID, productID, qty, actionid, actionDate...more >>

Hello, I'm working through the Stock Symbol example in Shyam Pather's book, and I'm having a difficult time locating the notify function, StockAlertNotify() which is referred to in the NSFire1 stored procedure. I've looked under every Programmability tab under the generated databases an...more >>

This problem only happends on my office machine with NTFS partition and domain. No problem in all other win2003/w2k/xp machines with FAT32 partition and workgroup. Error message: Error: 6009: The assembly does not contain the required delivery protocol class. InstanceName: samplesinstance ...more >>

Hi, I'm trying to run Notification Services on local machine. First time I have installed it all samples worked correctly. Then for some reason I have stopped NS$RealtorINstance and I couldn't get it work ever since. Stock instance working just fine so I don't think this is a permission i...more >>

Hi, I've just moved my Notification Services installation to a new directory with a space in the name. Previously the Notification Services were installed on C:\, they've now moved to C:\Program Files. The problem is this, when I try running the command: nccontrol create -in "%BaseDi...more >>

hi, I have a dts package on sql server 2000 server, that populate an excel file and send it out to users as attachment. lately, users were able to received the file through email, and when I try to modified the user list in 'send mail task', I receive this error: 'error source: micr...more >>

hi all, i am into a project which need bounce mangement of mails,my client will be using exchange server. how i can manage the bounce mails as i have to log all the mails which have bounce backinto database and then provide the facilty to send them again. i was thinking of using "o...more >>

Hi, I have a windows setup program (framework 1.1), this setup program calls one util.exe with parameters. util.exe opens the connection (SQL Server 2000, windows authentication only) and does some db updations. when i run thru setup exe fails throwing "Login failed for user '(null)'. Reason: ...more >>

I have two different deployments of an NS an application. One is working and the other isn't. The failing application is generating Events, but they stay in the EventsEvents table and never make it to the NotificationsNotificatiosn table. AFAICT the two applications are "identically" co...more >>