below two sps are participating in the deadlock • NSAssignNextWorkItemToDistributor (Exclusive lock) • NSMarkWorkItemDistributionStart (Update lock) on the below indexes indid name ------ ----------------------------- 1 NSDistributorWorkItemsPK 10 st...more >>

hi Mert, I am developing the same kind of application that notifies using sms. can you help me out with some sample code for the custom delivery protocol? From http://www.developmentnow.com/g/110_2005_1_0_0_403482/HTTPDeliveryProtocol.htm Posted via DevelopmentNow.com Groups http://www.developme...more >>

Reinstalling Notification Services fixed the problem. "JussiS" wrote: > Registering instance fails and gives the following message: "Required > information could not be retrieved from the registry". I have defined an > instance and when trying to register it and creating a windows service,...more >>

I'm getting this message on SqlCacheDependencyAdmin.EnableTableForNotifications and aspnet_regsql.exe -C connstr -lt Yet, the following execution has finished successfully: ALTER DATABASE dbname SET ENABLE_BROKER ...more >>

Registering instance fails and gives the following message: "Required information could not be retrieved from the registry". I have defined an instance and when trying to register it and creating a windows service, it fails. Registering the instance succeeds in the first task "Updating registr...more >>

Bev: SQL Server Notification Services is pretty far removed from plain old DbMail in SQL Server 2005. Sounds like you don't need SSNS at all. Right Click on SQL Agent and select Properties. Go through the tabs. There is one about Notifications. use the DbMail profile you have setup on the ...more >>

I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com ...more >>

Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/s...more >>

Watch NFL Games Online! For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has basically every game covered. Its perfect if you have afford a monthly $70 direct tv nfl access subscription. they got a bunch of channels The s...more >>

This just occurred to me: Could the failure in email notification have any relation to the fact that I can't set up a linked server to the Sql 2000 Server on my PC? Like maybe fixing one problem will fix both? I was really surprised when I failed in this simple exercise, since I had no probl...more >>

I have been given the job of database administrator. I very good at SQL programming, but am just learning about things like backups, replication, etc. and am VERY shaky on anything involving network administration. I am not the one who installed Sql 2005 database, so I don't know if any ste...more >>

Hi, I am trying to set up the notification services on SQL 2005 by following http://msdn2.microsoft.com/en-us/library/ms172597.aspx At step 2, the command: net localgroup users DOMAIN\NSService /add , I got "There is no such global user or group: ad.vsd.vansd.org\nsservice." What was I s...more >>

On 7 , 13:19, entrodus <Babisi...@yahoo.com> wrote: > Hi all > > First of all i would like to say that i am a newbie in SSNS, > For some reason i am stuck with a pre-build SSNS application that > doesn't seem to work. > > After hours (days) of struggle i have managed to make it produce >...more >>

Hi all First of all i would like to say that i am a newbie in SSNS, For some reason i am stuck with a pre-build SSNS application that doesn't seem to work. After hours (days) of struggle i have managed to make it produce notifications (i can see data in both NSMyNotificationClassNotificati...more >>

From the brief description, it appears that the instance has not been properly registered. If you have, then I'd try unregistering it and then re-registering the instance on that computer. HTH... Joe -- Joe Webb SQL Server MVP http://weblogs.sqlteam.com/joew/ On Thu, 3...more >>

Found answer in past topics, I link it here just to push up if someone needs http://groups.google.com/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/715e6351f6969c29/8de344f2fb1205c8?lnk=gst&q=SQL-NS+Subscription+Management+API&rnum=6&hl=en#8de344f2fb1205c8 Mauro On ...more >>

Dear Group can you please help me resolve this issue Thanks, Prabhukiran D:\DatabaseSQLServer2005\90\NotificationServices>cd 9.0.242\bin D:\DatabaseSQLServer2005\90\NotificationServices\9.0.242\bin>nsservice -alerts - a Microsoft SQL Server Notification Services service executable 9.0...more >>

Hi Wellington. There is a quantumn for Vaccuming the Events Table and Notifications table. You can find it in the Application Settings part of the NS- ADF File. If it occours before the Notification is delivered ( not created) a duplicate Notification can be created, please send a snippet of t...more >>

Hi all, before posting a possible implementation of the scenario I depicted in http://groups.google.it/group/microsoft.public.sqlserver.notificationsvcs/browse_thread/thread/5cd542c0591058be?hl=it I was facing another problem related to NS, about SQL-NS SMI. Reading materials through the web, it...more >>

Thanks Joe, I think I will investigate the first and the third solution you gave and I will try to use the fourth too. I don't know if it can be useful to post code for each solution, but if someone needs help on the subject I can post the skeleton of a possible implementation. Thanks a lot ...more >>

Hi Joe, There were 2 notifications in the notifications table and they were associated with the same Notification Batch Id. Pat "Joe Webb" wrote: > When you say that there were 2 notifications produced - were there 2 > notifications in the notifications table? Or was there 1 notificat...more >>

Hi Mauro - A couple of thoughts along these lines: 1) If you control the table that is the source of the events, you can add a column to it that indicates the last time the row was modified (or inserted). Then you can create a chronicles table that keeps track of the last time the generat...more >>

When you say that there were 2 notifications produced - were there 2 notifications in the notifications table? Or was there 1 notification in the notification table, yet 2 were delivered to the subscriber? -- Joe Webb SQL Server MVP http://weblogs.sqlteam.com/joew/ On Mon, 27 Au...more >>

I installed SQL Server Experess edition initially. After I uninstalled Express I tried to install the Developer edition. The install is failing for Notification Services, Integration Services and Client Components (or Workstation Components). Each fails with the message: "A component that y...more >>

Hi all, I am wondering what's the best practice for the problem I'm facing. I'd like to use a scheduled provider that checks if a field is changed in a table, but looking at examples it seems that there's no other way but keeping a chronicle table with previous values. Due to the large amount o...more >>

Hi, We are experiencing a transient problem wherein duplication notifications are occaisionally generated for no dicernible reason. It happened twice in the last week in period where a several notifications were generated with no problem. Probing the data tables revealed the following: ...more >>

> If this is a new project, you should know that Microsoft has quietly > stated in the July CTP ReadMe file that SSNS will not be part of SQL > Server 2008. I would not consider using it for new development projects. This is really disappointing. I hope there is some clue on how to migrate. ...more >>

Hi Joe, I am using SSNS 2005, but I was trying to merge information from different sources. Now I'll have a look at the resources you posted. By the way, I am quite confused by the double chance XML and NMO. Which are the differences? Which one is "better"? In order to learn the second tech...more >>

Hi Mauro - Are you using SSNS 2000 or SSNS 2005. The match rule that you included as part of your post was for SSNS 2000. Although the basic concepts, terminology, and premise of SSNS 2005 is the the same as the prior version, there are number of improvements that prevent it from working exac...more >>

Hi guys, I am completely new to Notification Services and I was having a look at the example given in msdn2 and in the Microsoft book "Microsoft SQL 2005 NS" but I got problems to understand errors given in Event Viewer. After one day I was able to let the istance respond to the event, but now ...more >>