Hello All, I am running into an error in deploying my NS app into production. I have a separate Web Server and Database server. when registering my NS Instance, I am using a domain account to create the windows service ( specified in service logon) and using sql server authentication ...more >>

Hi everybody I have a problem with my SQL 2005 NS I have a script that insert XML values on a table when a database event happens (create, alter and drop tables, procedures and views). I have created a new empty DB called TEST, I ran the script against this DB and it works OK, it inserts th...more >>

My question is: in a scale out deployment, where the NS database will sit on an existing (and already-paid-for) clustered instance of SQL Enterprise edition 2005, and the distributor/generator Windows service (the NS engine) sits on a separate server with no SQL on it - does this scale-out fo...more >>

Hello All: When you define you subscription rule in the ADF file for a particular class it ultimately becomes part of a stored procedure (NSFire) that is called by the generator. This automatically created stored procedure encapsulates your rule in a transaction (Begin Transaction) I am ...more >>

What are the differences between 2000 and 2005, or are they relatively the same?...more >>

I am using the following code in my ICF file to try and set up email notifications. <DeliveryChannels> <DeliveryChannel> <DeliveryChannelName>SMTPServer01</DeliveryChannelName> <ProtocolName>SMTP</ProtocolName> <Arguments> <Argument> ...more >>

Hi, I've to implement a existing Notification Service Solution (ASP, C#) into our CMS (Livelink, Obtree 4). So far I know it is not possible to integrate the hole solution directly into this Content Management System. Because our client doesn't want to implement the solution with iframe, my i...more >>

Hello We have an issue with our SQL database, where when a Process ID locks and then starts to block other process id's. This then has a knock on affect then other process id's get block and in a couple of minutes we have a database that is un-useable due to the original user blocking the w...more >>

Hi all, I am using a stored procedure for my event subscription rule. This procedure essentially inserts data into Notifications view by selecting data from the chronicle tables. My code is now freezed including the ADF,ICF and stored procedure . The problem I am having is with my deployme...more >>

Hi, We're looking at developing a system in SQL 2000 utilising NS. It works fine in our development and QA setup which are both 32-bit environments. However, in a couple of months i'm going to need to migrate to our main production servers (clustered Itanium) and need to know that NS wont ...more >>

Hi, I am using SQL Server 2000 Notification Services. The notification instance that I created does not startup automatically when my machine restarts. I read in some previous posts that due to dependencies on the SQL Server, the instance might not start before SQL Server is running. My ...more >>

lots of guys are confused on this one and come to this forum with problems in Query Notifications. How can we pin a post that explains what is what and which forum to go to ... Any ideas Joe? kate ...more >>

Hello, I have been trying to implement the most simplest of WebService calls from Notification Services. NS hits the Webservice, but fails out with the a Request Format exception message. Does anyone know how to rewrite the content type generated by NS in the IHttpProtocolProvider The webserv...more >>

I could get Query Notification working for a windows forms client using the SQL Dependency object but the same code doesn't work from a simple windows service. The OnChange event doesn't seem to be raised up to the windows service. Looking at the SQL trace, it doesn't look like the a notificat...more >>

How much overhead is there when running Notification Services on sqlserver2005? Does it increase with more notification requests? I've noticed with one request that my cpu is constantly running at about 3 or 4 percent. Not sure if it is this or not but it looks like it is. thanks Peter Kell...more >>

Hi, Is it possible to specify 2 device addresses for same delivery channel in sql notification svcs 2005? In my application I am using SMTP delivery protocol. User may want to receive some notifications on gmail id and other notifications on yahoo id. Is this possible using same delivery ch...more >>

Hello, anybody know what this state mean ?? Error: 0, Severity: 19, State: 0 SqlDumpExceptionHandler: Process 767 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. Thanks to all ...more >>

Hello, I'm traying to migrate a Notification service solution from SQL Server 2000 to SQL Server 2005. The solution works fine on SQL Server 2000, but on 2005 I allways get the message: "The registry entries for the specified instance of Notification Services could not be found". This message...more >>

I'm just trying to understand better how SqlCacheDependency and notificaiton services work. I got it all setup and apparently working. When I run sqlserver2005 trace utility it shows the stored procedure SqlCachePolling constantly being executed. (kind of like it is polling). Is that how the...more >>

Experts, I am seeking a good resource where I can learn how to manipulate the e-mail format in a Notification Services application. I am working with the MOM Notification Workflow Solution Acclerator Application, which, stores this infromation in an .xml file. Are the elements in this fil...more >>

Hello, I'm new to NS and I'm trying to do a test project. I seem to have everything working but I saw I didn't I have any events defined in my ADF file so I'm trying to add one now. I have subscibers and subscriptions, at least there in the table. I scaled down the event to try to ...more >>

Hi, Any body tried out using a stored procedure to implement event rules? For my app, after fair bit of processing done in the sp, that I am using to implement event rule, I am trying to insert records into the notifications table. It did not work. I debugged the proc in SQL Mgmt studio t...more >>