I'm new to NS and SQLServer in general. How would I write a subscription that would trigger an event whenever any row(s) in a table have been updated/inserted/deleted and provide return those row(s) in the notification message? In other words, can I set up a subscription that triggers an...more >>

Hi there! Is there any GUI available for designing the instance and the ADF xml files? Is there something planned with SQL Server 2005 Notification Services? Thanks Klaus Aschenbrenner MVP Visual C# www.csharp.at, www.anecon.com http://weblogs.asp.net/klaus.aschenbrenner ...more >>

I'm converting SQL7 to SQL2K. The database scripts have an statement: DBCC TRACEON (8720) It's from third party vendor for previous database build or update. I'd like to know if the trace flag 8720 still is needed for SQL 2K or not. If not, I'm going to delete in the new database. Thank you in...more >>

Thank you, Shyam, for your answer to my question regarding the distributor and delivery protocol objects. Your explanation was very helpful to me. Now I have another question for you and the group. I've been given a rough sketch of a possible future notification application. I want to ...more >>

I am trying set up notfication so it emails when jobs fail etcc. I am using sql server 2000 service pack 3A i have set up a mail profile and when I go into enterprise manger and go to test sql mail it says it opens and closes my mapi connection fine. However when I go to an opertor type in an ...more >>

Hi I want to run my webapplication at machine1, which should access the notification instance created at machine2. I dont see any server configuration in notificationservices properties. How this can be done? Thanks...more >>

Hello all, I am currently using NET SEND in the notification services for sending network msgs to the various people who need to know when things go wrong. My problem is that I cannot get it to work for some people but it works with others. I am using the domain username that they use ...more >>

Hi, I am using scheduled customized event provider which looks for event every 2 minutes. Similarly i want to make notification to be scheduled, which will send notification every 2 or 3 minutes. One way is to add multiple subscription for multiple schedules. But that would increase t...more >>

In cases where you've set the NotificationBatchSize to a smaller number in order to get more parallel processing (specifically, to get a greater number of work items targeting a specific delivery channel), does the distributor instantiate more than one delivery protocol object that targets...more >>

I am running NS on a single desktop machine, which hosts NS, SQL Server and IIS for testing (I know this is not nice deployment environment). I created 10000 users who are subscribed to an event. I used HTTPDeliveryProtocol for the notifications created. The quantum time is 30 secs both for ...more >>

Is "Notification Services" used anywhere in Microsoft Applications (eg. the new downloads notifications)? ...more >>

When I try to turn on a notification on a DTS package, I get the error "Feature not implemented". I have an SMTP server using the Outlook Client running on this box and if I manually run a script that does the following: EXEC dbo.sendimail_sp @profile_name = 'PWHS2K3SQL', @recipie...more >>

Is there a way to stop a SQLNS application from being disabled if there is a SQLProvider defined and no batches get submitted? TIA Tony S. ...more >>

My simple problem occurs because of authentication. I'm setting the DataBase and the service on the same machine now everything goes smoothly i register the service, create DB and grant all the permissions to the user who will run the service (The user is connected online already - default user)...more >>

Hello, I 've the following issue, any help greatly appreciated I have SQL 2000 with service pack 3a: When I use xp_sendmail with a file attached, it doesn't save to the specified folder, SQL 7 does. Any help, would be great. Thanks Don ...more >>

Hi All, I've created a simple app based on the Stock App that has a NonHostedProvider named GenericProvider. I use this Provider reference when I am manually submitting sample/test events. The app successfully writes the notifications to a file but I don't understand how this nonhosted prov...more >>

I would like to use the BOL Scale-out Configuration for one of my applications. I just want to make sure that I can safely install the NS Database Components on a Sql Server 2000 running on Itanium2 64-bit processors. Has anybody actually done this? ...more >>

Is there an easy way to test scheduled events or I have to wait at least one day for them to fire? Modifyin time doesn't help much. I think it messes the Quantum time. I got this eventlog error when I did that... Message: 4016: The quantum end time is later than the current real clock tim...more >>

This is probably a really dumb question... I have an application server set up and running Notification services no problem. i can create subscriptions on this machine using modified versions of the sample scripts. Ok So far. Users of my application need to be able to create subscriptions ...more >>

I have two NS instances each with one application each. Each application uses a hosted event provider (custom). The hosted event provider is scheduled to run once a day shortly after midnight. Last night the event providers returned an error from the Run method due to a timeout trying to get...more >>