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