I am developing my first Notification Services Application. I am using the book Microsoft SQL Server 2000 Notifications Services by Shyam Pather for my guidance in this first application. My application has 6 events that would fire a notification. Each subscriber could be affected by one or...more >>

Hi, Im sure Ive had this problem before but cant remember how to fix it. How do you get around the problem where NS wont install if you have .NET 1.1 installed? Thanks Ian...more >>

Hi I have a Notification service created and running on a remote server. I have a windows application for managing the subscriptions. I want to have this windows subscription application installed on different client machines for the different users. All the Client machines should acess t...more >>

For transaction log esixt "Log File(s) Used Size (KB)" or "Percent Log Used" events. Exists the same events for datafiles ?? Thanks ...more >>

Out of interest, I have had the following happen and wondered if anyone had an explanation for the strange result: I executed an 'Alter Proc' against one of the FireRule stored procedures in a SNS database. This stored procedure was an event rule. After executing the 'Alter Proc' in S...more >>

Hi, I am developing a custom delivery protocol to send email notification with attachment. When I submit an event, the notification is generated. But the email delivery is failed. I am getting the following error message in the event log. Event Type: Error Event Source: Notificati...more >>

I am trying to use a custom hosted event provider.I have implemeted all the methods of the interface "IScheduledEventProvider " in the new Provider. When I try to start the service it is failing to initialise the Provider. The error log is given belowplease. Please help me to resolve this. ...more >>

Hi, eMail Messages generated with xslt are not readable. It creates html output but we only get cryptic html. we think there is a problem with the character set. can anyone help us? thanks lot, Marco ...more >>

Most of my business knowledge for generating Notification conditions are currently residing on .NET components and SQL stored procedures. I would like to reuse it for the SQL notification services. is there any way to incorporate the Stored procedure calls or .NET component calls in the Ac...more >>

I need to insert subscriptions into an NS application on an app server from an ASP application on a Web server. The documentation describes deployment of ASP.NET remote machine Subscriptiont management app., but not COM-based app. from ASP, etc. Does the same deployment scenario apply? If no...more >>

Hi, When I add a subscription, I am getting the following error in the stock example. Cannot add subscription: Specified argument was out of the range of valid values. Parameter name: subscriptionClassName . I am able to run the Realtor, Weather samples. Any idea what could be the ...more >>

Whenever I try to run the Notification services from, the services is getting stopped immediatley after getting started. The error message I am geting is "The XYZ Service on Local Computer started and stopped. Some Services stop automatically if they have no work to do, for example, The p...more >>

My requirements are for a set of Subscribers to recieve notifications at a set time each day. But the ScheduledRule model as presented in NS BOL and examples doesn't work because it uses a model of a chronicle table periodically (presumably) populated by an EP in a manner disconnected from ...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

I am working through the example in the "A First Look at SQL Server 2005 for Developers" book, chapter 16. I have an instance called DBSERVER2005, and when I try to start the NS$DBSERVER2005 service, I get Error 1053 = The service did not respond to the start or control request in a timel...more >>

I have a notification services application that works on fine on different boxes, but recently on two boxes when I turn NS instance service on, CPU usage is getting around 90%, while these boxes have 1GB memory and P4 CPU. I ran sql profiler and found that sp_resest_connection is being call...more >>

Two Questions; 1) Are there any differences between MS Notification Services that will ship w/ SQL2005 as opposed to notification services that is available for SQL2K? 2) I'm interested to know the kind of performance, reliability and maximum throughput that can be expected in the current i...more >>

I need get data from source OLTP DB for NS DB. Putting NS DB and OLTP DB on the same server will decrease performance too much which Microsoft doesn’t suggest also. What’s the best way to seperate DB from OLTP DB for NS, linked server, replication or anything else? Hope someone can help me on it...more >>

I read in a MS chat session (http://www.microsoft.com/technet/community/chats/trans/office/off0908.mspx) that it is possible to send broadcast messages when used in conjunction with SQL NS. Does anyone actually know how to do this? Set it up? Any documentation to follow? Thanx...more >>

Hello I was wondering what the steps would be if you needed to change th domain account/password under which the windows service runs or th db accounts using which the windows service accesses the dbs Would I need to do a nscontron register Please help ...more >>

Hello I would like to know how I can change the event class schema withou loosing the events that have not been proccessed yet by futur scheduled subscriptions I.e: Event 1 (arriave at 6pm Event 2 (arrives at 7:10pm Subscription 1 is scheduled for 7p Subscription 2 is scheduled for 9p If...more >>

I have a procedure which is used to notify some users if a replication job failed. The way i am doing is querying on sysreplicationalert table for a given date and use xp_sendmail to notify users. since i am using a dynamic sql when getting the alert_error_text from the above table if there is a...more >>

can i change the mail suibject according to the data in the notification table <NotificationClass> <NotificationClassName>InstantMessageEmailNotifications</NotificationClassName> <Schema> <Fields> <Field> <FieldName>MessageBody</FieldName> <FieldType>nvarchar(4000)</FieldType> </Field>...more >>

Is there a way to check if any sql job failed on any server? Lets say we have 5 servers and of which 1 job failed on 2 servers. I am looking for some script that gives me details of servername followed by job name that failed on each server. Thanks -- Message posted via http://www.sqlmonst...more >>

Hi, I am not sure which news group to post this problem. This happens on a SQL Server system but the problem might be exchange. Anyway the problem is as follows: I have a CDO stored procedure which is exactly the same on two SQL Servers both running SQL Server 2000 on Windows 2003 OS. On...more >>

How to see if the service is running? (management console?)...more >>