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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >> |
