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 > june 2007

Rogue NS instance
Posted by Maria at 6/29/2007 2:57:44 AM
Hi folks, I created a new Notifiction Service, and stopped it halfway through creation as I realised I hadn't saved an ADF file. Now the NS databases appear to have been partially created, and I can't delete the instance because it doesn't appear in the list in Server Explorer. I tried to del...more >>


Can Event Batch ID be related to resulting Notification Batch ID(s)?
Posted by BigDave at 6/27/2007 10:49:52 AM
Hi all, We'd like to write a little web view showing events coming in, and the resulting notifications - in terms of their real-time status (via NSDistributorWorkItems table). But surprisingly, we're finding it difficult to tie an Event Batch ID to its resulting Notification Batch ID(s) wit...more >>

Accessing NS Instance on a Database Server from a Web Server
Posted by LegacySARK at 6/22/2007 9:43:35 PM
Hello. I'm new to SQL Server 2005 Notification Services. I'm trying to access an Instance of SQL 2005 NS on a remote Database Server from a Web Service on a different web server, using the following code: <C#> using Microsoft.SqlServer.NotificationServices;...more >>

Scheduling a job to run every 30 seconds...
Posted by Roz at 6/21/2007 11:20:01 AM
Hello, all. I need to schedule a SQL job to run every 30 seconds. However, it looks like the shortest frequency SQL will allow is every minute. Is what I want to do possible? Thnx in advance, Roz...more >>

SQL-NS Discontinued???
Posted by james at 6/20/2007 1:48:34 PM
I googled this and MSDN is stating that is is discontinued. I searched for SQL-SN in SQL Server 2008 and I cannot find anything. What gives? This almost seems like a hoax. JIM ...more >>

SQL-NS 2005 StockBroker Sample doesn't notify
Posted by James at 6/12/2007 11:31:51 AM
From Ch.3 of Shyam Pather's SQL-NS book, I have followed the instructions exactly as stated in the book, I get success on the TEST and setup_all and I get no errors when aI start the service as described on pg. 69-70. I run the Test.sql file that inserts records in the StockBroker database, ...more >>

SSNS Security using installation user acct not service acct
Posted by paulneth NO[at]SPAM gmail.com at 6/6/2007 9:31:58 PM
We have SSNS app that updates a different database from changes in another. After installing it always inserts data as my user acct but NOT the svc defined in ICF. we have custom SQL server del protocol and channels. I have added a runas to top of the Ourcreate.cmd but no difference. Is the...more >>

Notiification services Help Please
Posted by Saravana at 6/6/2007 2:16:00 PM
We are trying to use SQL server 2005 Notification services to alert an biztalk system that there is a changed data in the table.We have store proc which retrieves the result sets from multiple tables and if there is any change in the result set any update or modify we want NS to trigger an...more >>



User Notifications
Posted by Dominic at 6/5/2007 7:48:01 AM
As a newbie, I need help with an issue. Is it possible to set up a notification to myself that alerts myself whenever a specific user(s) logs onto a sql database? I hope someone can help! Many thanks, Dominic ...more >>


DevelopmentNow Blog