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 > september 2006

Receiving notifications from SQL Server 2000 that data changed?
Posted by MobileMan at 9/27/2006 3:19:01 PM
What is the best way to be notified, from SQL Server 2000, that a row was added, deleted, or modified in another application? I'm a competent C# developer, but a "babe in the woods" when it comes to SQL Server. I have been reading about the Notification "engine" in SQL Server 2005 and am l...more >>

Disabled subscriptions still send messages....Help!
Posted by corey_bunch NO[at]SPAM yahoo.com at 9/22/2006 12:16:20 PM
Our app goes through & disables some subscriptions using the NS views nightly based on some business rules. UPDATE Notify.dbo.NSSubscriptionClassView SET Enabled = 'Disabled' WHERE blah, blah, blah AND Enabled = 'Enabled' My problem is that these "disabled" subscriptions still se...more >>

Companies/projects using NS?
Posted by Shaul Dar at 9/21/2006 6:48:24 AM
Is there a list somewhere, from Microsoft or elsewhere, of companies or projects based on NS (2.0 / 3.0)? -- Shaul ...more >>

SQL 2000 NS SP1 on SQL 2000 SP4
Posted by Pete Zerger at 9/15/2006 3:50:18 AM
I have a client attempting to install SQL 2000 NS on a SQL 2000 SP4 server, and receiving the following error message: "The database components require a qualified version of SQL Server on the machine". I can via my memory or google find any issues with SQL 2000 NS installation on SP4...more >>

Troubleshooting Creation of an SQL-NS Instance
Posted by Isadore Schwartz at 9/13/2006 11:42:02 AM
Hi all, I am attempting to create an instance of an SQL-NS service, and that creation has failed because it was found that there was a compatibility issue with the DB. That has since been corrected. I attempted to create the instance again, and am running into this error every time I mak...more >>

sql 2000 notification services - moving the database to a new server
Posted by JR at 9/12/2006 3:31:17 PM
Is this possible? If so, are there are tools or special steps we need to take? We have restored the db to a new server and registered the services using the new server and sql name but it does not work. I still see refs to the old sql instance name in the NS db though. ...more >>

Multicast & SMTP question
Posted by CoreyB at 9/11/2006 8:47:57 AM
I have a question that needs clearing up. I know that I do want to use the multicast feature. Our app is such that we may have thousands of users subscribed to one specific event, so clearly we don't want to format thousands of times. We want to format just once, to save resources. We are ...more >>

MS SQL 2005 caching dependancy....
Posted by Dave at 9/11/2006 12:00:00 AM
Is it possible to build an MS sql 2005 caching dependancy stucture similar to what is offered by the SqlCacheDependency class for use with non asp.net applications using MS sql 2005 notification services and C# ? Cheers Ollie ...more >>



Subscriber Schedules
Posted by tafpin at 9/7/2006 11:37:26 AM
I configured an NS application some time ago. I am trying to expand the functionality to allow subscribers to be able to specify which days and times they should receive alerts. I am a little confused with the ScheduleRecurrence and schedulestart properties of the subscription class in that I ge...more >>

Sending SMS from SQL 2005
Posted by Don at 9/5/2006 9:33:03 PM
Hi, I need to make use of the notfication services for notifications in my application. The delivery method is either EMail or SMS. According to the documentation, SQL supports SMS as a delivery method. However, I can't find any sample or documentation which corroborates the above. Plea...more >>


DevelopmentNow Blog