Psst! Did you know DevelopmentNow is a mobile web site design agency?

Contact us for help mobilizing your site, or to sign up for our beta Mobile Web SDK!


Archived Months
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
all groups > sql server notification services > july 2004

Dynamic SQL within Actions
Posted by Grant Davidson at 7/29/2004 4:56:33 AM
Bit of a newbie question, I have a requirement to allow a subscriber to subscribe to customer information based on variable criteria : E.g. They can say, let me know about any customer details if the customer has x forename, y surname, a customer id of z, dob of c etc. However not all (inf...more >>


Document IDeliveryProtocol Assembly
Posted by Scot NS Curry at 7/28/2004 11:02:47 PM
I am not clear on how to document the IDeliveryChannel assembly. With the Event classes, there is the very obvious AssemblyName and ClassName nodes that do the trick. Could someone please enlighten me on how to document that information. I am very tired of looking at the generic SMTP implemen...more >>

Commerce Server + SQL Server Notification Services ?
Posted by Jedi at 7/28/2004 7:16:07 PM
hi, i am wondering that how i can integrate Notification service with Commerce server to create more efficient B2C sites. Is there anyone worked on this? thanks in advance for any idea,help or leeding ...more >>

Cluste Server Configuration Failing
Posted by Mark Weiss at 7/28/2004 3:58:45 PM
We are deploying an existing NS application that has previously been deployed on single app server/single remote DB server configuration. We are deploying to two- node app server cluster using Cluster Server, with a valid virtual hostname in front of both nodes. On the active node, I ran ...more >>

Email Notification Error 22022 inSQL server Agent
Posted by vv at 7/27/2004 11:51:08 PM
>> Hi, >> I have SBS 2003 server and i have SQL 2000 , i have >> configured automate backup daily, problem is when the >> backup is not running some time i want to get mail alert >> for that i have treied to set the Mail agent the >> followingare the task i followed >> >> 1. Go...more >>

Alternatives?
Posted by Ian Diaz at 7/27/2004 1:39:06 PM
Notification services is a great add-on but it isn't available for MSDE. Are there other alternative engines/services (either a commercial or freeware product) for this? Thanks in advance. Ian ...more >>

How to Enable Mail Notification on SQL 2000 With SP3a in SBS 2003
Posted by vv at 7/27/2004 3:08:58 AM
Hi, I have SBS 2003 server and i have SQL 2000 , i have configured automate backup daily, problem is when the backup is not running some time i want to get mail alert for that i have treied to set the Mail agent the followingare the task i followed 1. Gone to administrative tools--> Se...more >>

NS service problem
Posted by masoud bayan at 7/25/2004 11:55:17 PM
I have NS service on a machine with Log on user set to NSUser (a windows domain user), also I have this user in my sql server users as db_owner and administrator for all databases (including Master DB). when I try to start service it does not start and if receive follwing error in event log: I e...more >>



IDeliveryProtocol
Posted by Alvin LeCount at 7/21/2004 11:27:03 AM
I have a custom delivery protocol much like the example in the online books that invokes a stored procedure. When I try to debug it, break points get hit just fine in the Initialize() method but I cant seem to get the debugger to stop in the DeliverNotification() method. Does this happen on a di...more >>

Passing parameters to store procedure...
Posted by Alvin LeCount at 7/20/2004 10:26:42 AM
How does one pass parameters to a stored procedure deliver channel? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

:WHAT IS THE PORT NO
Posted by jaggu at 7/20/2004 12:12:22 AM
Dear sir, I am connected my application for sql server thru the lan. After i removed the lan connection. if the database is there on same system what port no. i have to give for the again for reconnection. when i am lan connection my port no is 1433. what i have to give when i removed the...more >>

SQL Agent Mail Profile Greyed Out
Posted by bryan murtha at 7/17/2004 4:41:04 PM
I had Notifiication Services set up on a particular box. I looked and it's not sending me anymore alerts. When I stopped the Agent and Opened Outlook I was able to send email to myself no problem. However when I went under EM => Management => Sql Server Agent => Properties, the SQL Agent M...more >>

error in XML document NS (Urgent !)
Posted by Jedi at 7/15/2004 10:11:19 PM
hi, i am trying to create NS application independent to samples and sapmles installation, i did followings - create new web app - create win32 app in the same solution - i have copied and include some cmd files from realtor sample with configuring them to reala paths for example: if wr...more >>

Creating NEW APP
Posted by Jedi at 7/14/2004 3:07:19 PM
hi every one, i am new on NS, but i am more amazing when i get deeper inside the NS, i have allredy run all samples and i got how it works now i want to create my application that based on scenario that using SQLTriggerEventProvider to create notifications and mail as a delivery ...more >>

A Book on SQL-NS for developers
Posted by Shyam Pather [MS] at 7/14/2004 11:23:21 AM
Hello all, I want to let everyone know about my upcoming book on SQL Notification Services. The book is published by SAMS and is a developers guide to building applications with SQL-NS. It covers all aspects of notification application development, including design, authoring of the ADF/config ...more >>

RealtorDB URG!
Posted by Jedi at 7/13/2004 6:48:10 AM
i have compiled the realtor example, in the last step tell me to run sql that "INSERT INTO RealtorDB..Listings values (N'2828 28th Ave SE', N'BusyKids', 4, 3, 350000, N'A cute house with a great view. Contact Alfred E Neumann or attend during the open house on Sunday') " but it gives error "...more >>

SQL Mail Multiple recipients
Posted by Steven Zucker at 7/13/2004 5:24:07 AM
Any clue how to utlize SQL mail to multiple recipients? platform Win2K Server / SQL 2000 / Exchange 2000...more >>

Some Questions
Posted by Jedi at 7/12/2004 6:56:10 PM
hi everyone, i am new on NS, i have read all MSDN article about for my custom application, i also discused sapmles that i have run. now time to jump into code :), here is the scenario, i woul like to NS with my exist MS SQL Server Database (all ready created) to send notification as mail...more >>

beginner question
Posted by Björn at 7/9/2004 4:09:07 PM
Hi I´m developing an C# application where I need events when data in my database changes or new data is created. Someone told me to use Notification Services. Now I´m trying since monday with the MS examples. The samples works fine but I didn´t really understand the XML config files. My qu...more >>

Follow up - Does not return in timely manner
Posted by Mark Weiss at 7/9/2004 12:38:54 PM
I now found in the documentation that the Run() method must return in 5 minutes or this error will occur. Based on the log timestamps generated by our custom Event Provider, this is what happened. So my question is, what is Microsoft's (or anyone else who has run into this issue) recommen...more >>

Does not return in timely manner from Run
Posted by Mark Weiss at 7/9/2004 9:07:53 AM
What can cause this error to occur: "The application did not return in a timely manner from the Run method." The terribly unfortunate behavior in these circumstances is that NS shuts down the custom Event Provider that timed out. Even more unfortunate is that the process continues to run...more >>

help query
Posted by MC at 7/9/2004 8:30:34 AM
I have the tables SendController (controllerID int, date datetime, regionID int, mission ntext) i want to select all controllers that didn't go to the same region 10 times consecutively. How to do that??? *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...more >>

Errors or not?
Posted by JRC at 7/7/2004 3:41:30 PM
Can anyone give me an idea of what these mean?: 2004-07-06 22:00:01.95 spid12 Opening file e:\mssql7\data\GM_GtaxPrep_Log.LDF. 2004-07-06 22:00:02.57 backup Database backed up with following information: Database: GM_GtaxPrep, creation date and time: 2001/08/30(10:09:43), pages dumped: ...more >>

SQL 2005 Notification Services
Posted by Hendrik at 7/4/2004 5:25:02 PM
Hi I have read a lot about SQL notification services I would like to testdrive it to see if it will provide in my requirements We are developing on SQL Server 2005(Yukon), but I have no idea where to find notification services to install it. There is a notificatin service directory after insta...more >>


DevelopmentNow Blog