Hello all: I will be dealing with Scheduled Subscriptions so have an Event log to keep track of when they come in. If my Event class has multiple fields, do I need to duplicate those fields in the Event log? Why not have just the following in the Event Log: EventID INT, DateAdded DATET...more >>

Hello all: I need to create a user-defined function that can be called by the match logic of a scheduled and event-driven subscription. The reason for the function is not important. Can I put in T-SQL statements in the application definition file to create the function? What section would...more >>

I am building a membership-based site and plan to use NS to send out various kinds of scheduled and triggered notifications. The first notification that will be sent out is a 'Welcome to the site!' message. Of course I could just send it out the old-fashioned way, but I am hoping to use NS...more >>

Does anyone know if the NS built-in SMTP Protocol supports custom SMTP headers, and if not, are there any 3rd party components out there that do? ...more >>

Hi, I need to build a notification system that will send notifications when a certain field changes in my database. Other data for the row may change, and that should not cause a notification to be sent. I'd also prefer not to create a column just to track when the field i'm interested in c...more >>

Hi, My database has a flag that indicates if our customers would like to receive notifications. Currently, our sales staff manages subscriptions on behalf of our customers. The settings for all customers is the same, so its only a matter of enabling or disabling a subscription (or creating ...more >>

Hi All, Can some pass on the URLs for learning NS step by step with a very small and easy example. I tried going through the NS tutorial (Weather) present in the BOL, but when i open "NSTutorial.ssmssln" it gives following error: Unhandled Exception has occurred in a component in your a...more >>

Hi, I have Windows Vista running with SQL Server 2005 and I need Notification Services running on that machine. I have a batch file which calls nscontrol with the appropriate parameters for the xml appADF.xml and appConfig.xml files. When I try to run this batch file it gives me an "Access ...more >>

Perhaps somebody can point me to good step-by-step guide to solve my very common task. There is table "SomeTable". There is field "Status" there. Some process need to process rows in that table when "Status"="Pending". Of course I want to do it without checking such rows every some period of ti...more >>

After scanning a document, can one load the resultant bitmap image into Reporting services and be able to edit it. eg. lets say a portion of the document was Name : _______________ Surname : _______________ ID No. : _______________ Now where the underlined parts are, can one...more >>

Hello All, I use notifcation services to send notices to my applications. With increasing load, I have concerns with scallability. In peak times, I predict that I will have 300+ new events and 300+ notices per second. This can be sustained for up to 10-15 minutes. Any insight in the perfrom...more >>

Hi, I installed Notification Services in our production SQL Server 2005 (SP1) cluster servers. But I am not using it; do I still need apply changes to following article ID: 931815? Regards! Chen ...more >>

Im glad I came across this group. I really need help on SSNS for a very important project. I need to use the xml data type for my notifications, but cannot find any resources on how I can use it, extract data from it or format it. Here is an example of an event xml structure i need to create a...more >>

I have verified that Notification Services is installed following the direction provided by KB931815. How do I stop the referenced NS Service instance names "event provider, the Notification Services generator service, and all the Notification Services distributor services". I cannot see these...more >>

My boss asked me about this one: We have an new application that stores documents (Word, PDF, etc) in a SQL field of appropriate type (varbinary(max), I think). I know I can get this data element into a Notification record and send it to the xslt formatter, but how can I make that field eleme...more >>