Hi, I am using notification services for SQL Server 2000 My notification service instance and database exist in one machine whereas I am developing a windows based client for subscription which may exist in other machines. What format do I use to specify the server name + instance name w...more >>

Hi, How do I set up a globle email operator profile for sql2005 notification to work? Thanks ...more >>

Hi, I am using SQL Server 2005 Notification Services. I have written an application which uses a standard delivery protocol (FILE) and a few custom delivery protocols. I want to display the log of notifications sent. This information can be found in NSMyEventClassNotificationDistribution ...more >>

Hi, I think I want to use a custom content formatter in my app. The reason is that I will probably want to access external data from my own database... The problem is that I need to be able to specify to my custom content formatter the connection string that will allow me to access the dat...more >>

Hi all, I would like to know whether it is possible to have a "subscription" and yet "not send a notification" to a "subscriber". I so, how do I achieve the same. Thanks in advance. Shashidhara K ...more >>

Is it possible to use CC: and BCC: functionality in SQL Server 2005 Notification Services when sending e-mail notifications? ...more >>

Hi, I am looking at the documentation for the notification services and it is mentioned that after creating the ADF and configuration files, when I run the NSControl utility, it creates a new instance and application database. In my application we are planning to have several notification ...more >>

Hi, If I try to create a notification service instance where the SQL 2005 instance is having (\) in the name, it gives error saying that \ are not allowed. GS ...more >>

I've been reading Shyam's most recent book and have a question regarding scaling-out with muliple distributors. How does the SQL-NS engine partition out the work to the different distributors? Does it use round-robinning or some other method? There was no mention of how this was performed in ...more >>

Hi All, I'm helping one of our developers with a NS application, and during testing he asked me what the various values of the DeliveryStatusCode field reflected.. Now, I know that a value of 6 is successfully delivered, and a value of 4 means that it failed, but I was wondering if anyo...more >>

How can I setup an alert on SQL7 and SQL2K for sending me an alert (email) when the amount of available disk space on a certain drive crosses a defined threshold? I do know how to setup email. I wanted to also setup a similar alert for transaction log growth. Thanks in advance. Adam...more >>

Hi All, I would like to know if we can have multiple "HostedProvider"(s) for a single "Events" Class in the Notification Services 2005. If so, how do I implement the same. Also How can execute a stored procedure residing in a different Database, in my Notification Services Application, I...more >>

Hi, Is it possible to have subscription fields that hold "multiple values". I want to allow subscriptions for "records" of a certain category, but I need to let my subscriber choose one or more categories. Is this supported in SSNS? They may even choose not to filter the category (in which ...more >>

Hi, I am hoping this is a really simple queastion. I haven't come accross it yet in Shyam's book... I want to make sure that people don't get duplicate notifications. For example, if you can subscribe to recieve notifications when records of a certain category are added to the system, I ...more >>

Hi all, I have set up a notification services using MSSQL Notification Service 2005. The events are firing properly, and even the notification to the corresponding subscriber is populated, but the delivery status shows "Delivery failed". Can anyone tell me what could be the possi...more >>

I have a server with follow configuration: OS: Windows Server 2003 SP1 Installed software: - SQL server 2000 SP4 (default instance) - SharePoint Services 2.0 SP2 (that install SQL Desktop Engine with instance name 'SHAREPOINT') - SQL XML 3.0 SP2 When I install SQL Notification Servi...more >>

Hello, I installed Notification Services, but from reading Microsoft Walkthrough, I can't figure out where to start and how to actually create a project. The Walkthrough says in the part "design your application" that I have to decide this and determine that; then the next step is "build yo...more >>

Hi There I know it's a simple one but I have tried many variations and can't find where the SMTP protocol arguments are documented. How do I specify the username and password for this protocol? Here's the relevant part from my ICF file. Any help greatfully appreciated! <DeliveryChannel...more >>

Hi, If for some reason the notification instance is to be re-registed, it gives error that performance counter is already exiting. How to overcome this? GS ...more >>

Hi, Just wanted to check whether we can specify multiple SMTP server names for the same deliverychannelname and Protocol? The idea is to have a backup server specified if the primary is not working for some reason. Will this work? This is how my deliverychannels section would look like for ...more >>

i am finding the notification is triggered only once when the field changes first time. Its not triggered second time. How can i have it trigger everytime there is a change in the field. Here is code snippet. thx .... ...static void Main() { SqlCommand cmd = new SqlCommand("SELECT...more >>

Hi all, I'm starting designing a SSNS application to support our own web based app. I've just got the Shyam book for SSNS 2005, which looks pretty good so far. Anyway, I have a specific requirement that is making me nervous, and I would appreciate any responses: In our web app, we have u...more >>

Hi, I am building a prototype NS app for scheduled notifications. I specified a stored proc in my schedule event rule. To start with I put in a 1 liner insert statement in this sp to insert a record into schedule notifications view with hard coded values ( just to see whether things work). Th...more >>

1. When you update an instance and tables get new columns, etc. - say for example you update a subscription class. Is any data lost? Are tables dropped & readded? I had a situation where I updated my instance, and some new tables were created called NS<subscriptionclass>Old. Then they weren...more >>

Hi, we're currently designing a notification system for our document management product, and we're thinking about using SQL NS instead of developing a home-brewn subscription engine. SQL NS looks very promising to us. However, one of the critical requirements for our subscription system is ...more >>