I have an application that has run under NS 2.0 for over a year. I updated it many times using "nscontrol update" without a problem. I recently converted the application to NS 2005 ande SQL Server 2005. After making the necessary changes (e.g., change Notify function to Insert Into), I was ...more >>

I have some clarifications on Notification services. Following is the scenario when a record is updated by a user, the same record needs to be sent to all the other online users. And here we are using notification services for pushing data from the server to the client machines. I have to s...more >>

I am adding a subscription using NMO. When following line is executed I get ArgumentOutOfRange Exception Subscription subscription = new Subscription(m_NSApplication, subscriptionClassName); The exception is as follows ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Mon...more >>

Hi I have downloaded the file: MSSQLNS20SP1.Std.en.exe from Microsoft site reg MSSQL SERVER NOtification Services 2000 I need help regarding:How to configure the notification services on SQL SERVER 2000. Also how to setup the samples in it. I am also pasting the trace of our file: C:...more >>

Dear All , I want to build a system that contains one Windows Service,and host multiple NS Application, the problem is that each application has its Events/Subsribstion class Fields... I think that i first create a service then every time i update the ADF i update the service,but what abou...more >>

I've been cruising the information on NS and I cannot figure this out. I guess it's a custom deliverychannel because MS only supports smtp and file as built in delivery channels. What resources are necessary in order to set up a channel like this to deliver, say, text messages to mobiles? Do...more >>

We have a notification service application, working in our development and testing environments. Our application uses different protocols, including SMTP for sending notifications. Some days ago, we detected an error in the development environment, like this: Event Type: Error Event ...more >>

Hi, I need to find out all the user tables in a database. For this purpose I have written following query. NSBank is the name of the database. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ USE NSBank; select name, type_desc from sys.objects where type='u'; ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~...more >>

I have looked for other messages to help me track down my problem here. Thanks to Joe, Kate, and others for posting good info. I used the verbose logging feature to help me track this down. Basically I modified the Newsletter sample app. I have the new instance and app config files working ...more >>

Hi, I am trying to send notifications using SMTP protcol. I am using a remote SQL server instance. There are 2 problems. 1. XSLT ContentFormatter The remote server tries to find the XSLT File on server machine. But in In my case, XSLT file resides on client machine. Hence in the Applicatio...more >>

Hi, I am using SQL server event provider. The database that has the event data is on remote machine. Can SQL server event provider query the database on remote machine? Or do I have to link the servers? Any help would be appreciated. ...more >>

Is there any functionality to allow users to... A) sign up for a subscription B) receive an initial email describing what they've signed up for, with a confirmation link C) they click to confirm - AT THIS POINT they are added as a subscriber instead of all the samples...where they just add th...more >>

I have made some progress towards getting external activation setup for a windows service we have. I am now encountering an error in the SQL Server error log that occurs when the event notification for queue activation should be created. The error is... Closed event notification conversation e...more >>

I am using the notification classes using c# to manage subscriibers, subscriptions, etc. However, this application is on a different server than the notifications database. How can i tell the c# program where to save the subscribers to? The app works fine on the same machine, but obviously on di...more >>

I need to flag some subscribers as default recipients for a specific subscription class. In other words, they need to recieve all notifications sent by a subscription class. Is this possible? What would be the best strategy? Thanks Matt...more >>

Im just starting out with notification services and all the examples i find seem to be for creating these standalone notification apps, they dont really integrate with anything. For example, i already have a database with a users table...the people who will be the subscribers. I dont see the poin...more >>

Hi, I am trying to set up an operator using SQL Server 2000 to send email alerts when a certain job has failed. When i go to the properties of the operator and click the three dots next to the email name I get the error message below "unable to logon to mail system. you should open a mail...more >>

hi all expert. i am implementing SQL NS(sp1) in clustereed environment.. first of all..at Test machine (not Clustered), it works well... Subscriber and Subscription is created welll and Event is created well... but notfication (rule) is never issued.. Event log show me one Warning messa...more >>

Hi NG, We have a development database and from time to time some user or users will issue a drop table and I would like to know the user who drop the table. Is there a way to determine who and when the user issues the drop table DDL without running the profiler? If it can't be done withou...more >>

I am basically new to sql server 2000 within the last 6 months. At my small company, I was told that they want me to sent out alerts for reasons like a database has reached 80% of its maximum capacity. I am suppose to setup backup and restore procedures. To do this work using enterprise mana...more >>

OK - new guy here - following the tutorials, I've modified them to reflect my application's basic needs, and the notifications are coming to the htm file fine. I've now added a delivery channel, and updated myself (the only subscriber) and my device to be using the email delivery channel. When...more >>

How do I go about creating a notification for unscheduled SQL Server shutdowns?...more >>

Dear all, I am not sure if I am posting my question at the right place. Anyway, I hope someone can help me out. I have a scheduled job in SQL server agent and I would like to configure the email notification if the job fails. When I tried to create a new email operator name, I clicked on t...more >>

I am a programmer in a small company that uses sql server 2000 and visual studio.net 1.1. We will not have the sql server 2005/visual studio.net 2005 until the end of year 2006. I need to do the following general sql server 2000 notifications when: 1. Setup notifications when the disk s...more >>

Hi All I Wonder to see a Notification Services application that does not use Notify function. The NotificationsGenerate sproc which is used by the sql provider direcly inserts into another table and these notifications are sent using dbmail. I am new here and the reason that is given by my p...more >>

Hi, I am attempting to build the Stock_VB solution file but I get the error: Error 1 Error creating assembly manifest: Error reading key file 'C:\Program Files\Microsoft SQL Server\90\Samples\Notification Services\Stock\samplekey.snk' -- The system cannot find the file specified. I have...more >>

I thought I had tested and validated that if a Subscriber is disabled, then none of their subscriptions would be matched without having to disable the subscription. I am using SQL 2005 NS. I believe we tested this on June CTP and it was working, but now with RTM it is not. Can someone te...more >>

Hi, Anyone know what you have to do to make this work? I need this in order to complete an implementation of Business Socrecard Manager who supports SQL 2005 but says for Notification Services you need to use version 2.0. When I run the installation routine for Notification Services I can...more >>

I see that I can set the level of logging of a NS-SQL service thru the NSService.Exe.config file eg <system.diagnostics> <switches> <add name="LogAdministrative" value="2"/> <add name="LogService" value="4"/> ........ But I am doing some domain specific logging on my own and I ...more >>