Hi, could somebody help me, I would like to fire an event schedule wise automatically to all users who subscribe in particular category. e.g. An event to fire hourly/daily at particular time to all subscriber automatically. how can it possible in SQL Server 200 notification server, ...more >>

Hi, I am able to generate event based notifications. But I am not getting mails from scheduled notification subscriptions. What could be the problem.? Here goes the ADF file......... <SubscriptionClass> <ScheduledRules> <ScheduledRule> <RuleName>CenterMetricsWeeklyReportRule</R...more >>

In the ADF where you define your event data and the associated data type, can event data be a BLOB data type? Does the custom context formatter support this data type ... that is to say does the BLOB work with Hashtable[] rawContent variable? How would you access/retrieve this data from the ...more >>

Can I have multiple custom hosted event providers per application that access a non-theadsafe DLL? I guess another way to ask the question is do each of the custom hosted event providers run as separate processes or just new threads in a single process? ...more >>

I am trying to set up automatic alerts on SQL 2000, SP 3a using Outlook 2000 and Exchange. I have created a profile which successfully sends and receives e-mails, but when I try to enter the profile name in the drop down menu in the SQL Menu configuration it does not appear. If I manually ty...more >>

Hi there, I know this may sound lame, but I'm having trouble getting started. I can't seem to install NS correctly. Here's some info about my system: Windows XP SP2 ..NET Framework 1.1 SQLXML 3.0 Microsoft Visual Studio .NET 3.0 Microsoft SQL Server 2000 - 8.00.818 (Intel X86) Ma...more >>

I have a ScheduledRule in my ADF call an SP in another database. This SP in turn calls the Notify function in my NS database. The call is generating a 60018 error, which indicates that the "Generator context" is not valid for the Notify call. The ADF Rule is s just a single exec to the ext...more >>

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1 rows have many duplicates col2 has unique values col3 can have 5 possible values: 5, 10, 15, 20, 25 Variable @V can be equal to 5 or 10 or 15 o...more >>

Good Morning, I am new to SQL Server 2000. I am trying to use the job scheduling feature of the sql server. I did schedule the jobs with notification feature of it. It successfully sent e-mails also. The e-mails it sent are of the following format: JOB RUN: 'TSQL_Job_1' was run on 4/14/2...more >>

Hello, I was trying to investigate Notification Services to check if it could be interesting in our business, so I downloaded the Setup for NS Version 2 SP1 as well as SQLXML 3 SP3 (installed SQLXML 3 before NS) and checked out the samples that came within NS (Weather). However, in the event lo...more >>

I have a scheduled rule that calls an SP in another database. When I run the Scheduled Rule code standalone it works and returns rows. But when I set up a scheduled subscription and verify that subscriber, subscriber device and subscription have been entered in the NS database, with a valid s...more >>

Hello all I wrote easy NS app, one subscription class, one event, one notification class, output to text file through the filechannel. Everything worked well, bulding registration and starting service, bullding application, adding subscribers and subscriptions and so on. But when I add xml ...more >>

I think an important part of quickly understanding a new application is knowing how the various entities in the application relate to one another. Is there relationship map for NS ? For example, it would show you the relationship between the various parameters in the instance and app config f...more >>

Can anyone tell me how to adjust the sentTime field in the notifications table to the proper time zone?...more >>

Hi guys, Thank you for help. With your help I went pretty much though the whole process. My NS App creates the emails in the Pickup folder, then Windows SMTP server picks up the emails and copies them into the Queue folder, then ... nothing happens. As I understand this issue has nothi...more >>

Hi, The NS API throws the following exeption: Microsoft.SqlServer.NotificationServices.NSException: The subscription object has not been initialized. InstanceName: ELSInstance ApplicationName: ELS SubscriptionClassName: ELS_Bin_Level_CSubscription SubscriberId: Oleksiy SubscriptionId: ...more >>

No, serios... How to create the NS Application? I mean: "how to start?". Literally, Which button I have to press to create NEW BLANK NS Application? Even before writing the ADF file etc etc. PS. :-((( Microsoft is always Microsoft. It creates overcomplicated products with insufficient ...more >>

Hi, In my application I want besides the normal Notification functionality, provide administrative tools to edit the Notification Rules and Content Formats. So, administartor has to be able (through the Web interface) create/modfy/delete the rules for Notification Generator and create/m...more >>

Could an update that modified the FieldTypeMods of one field in a Subscription Schema cause this to happen. It just did on my development machine. Unit test of inserting a subscription now fails because the SP has disappeared. I can document this and specify that all schema modifications ...more >>

Hi, In our notification scenario, we need to send a set of records at every hour. eg) All orders pending delivery for last one hour. (So no joining with event tables) There will be subscribers for this notification. When we configured the system, we notice that every subscriber is gett...more >>

Does the event data have to reside in a SQL Server table? We have a large proprietary database that contains the event data for our proposed SQL NS application. If possible I would like to not duplicate this data in the SQL Server table for the NS application. Does the event data have to be in...more >>

Does anyone have any ideas on setting up a unit testing application to test an EP assembly independently of running a full NS application end to end and seeing what comes out in the emails? Obviously, the EP can log to file to aid in debugging, but what I mean is a structured, reusable, indep...more >>

Would appreciate your comments. Here is my task to be done yesterday but... I am monitoring one or more tables in a SQL DB via .Net WinForm programs developed in C# in the same LAN. As soon as the insert/update events happen, I need to get the notification from the SQL Server so that I can run...more >>