I have an application that has run under NS 2.0 for over a year.  I updated
it many times using "nscontrol update" without a problem.  I recently
converted the application to NS 2005 ande SQL Server 2005.  After making the
necessary changes (e.g., change Notify function to Insert ...

I need to find out all the user tables in a database. For this purpose
I have written following query. NSBank is the name of the database.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
USE NSBank;

I have looked for other messages to help me track down my problem here.
Thanks to Joe, Kate, and others for posting good info. I used the verbose
logging feature to help me track this down.
Basically I modified the Newsletter sample app. I have the new instance and

I see that I can set the level of logging of a NS-SQL service thru the
NSService.Exe.config file
eg
<system.diagnostics>

I am trying to send notifications using SMTP protcol. I am using a
remote SQL server instance. There are 2 problems.
1. XSLT ContentFormatter
The remote server tries to find the XSLT File on server machine. But in

I am using SQL server event provider. The database that has the event
data is on remote machine. Can SQL server event provider query the
database on remote machine? Or do I have to link the servers?
Any help would be appreciated.

I Wonder to see a Notification Services application that does not use Notify
function.
The NotificationsGenerate sproc which is used by the sql provider direcly
inserts into another table and these notifications are sent using dbmail. I

Im just starting out with notification services and all the examples i find
seem to be for creating these standalone notification apps, they dont really
integrate with anything. For example, i already have a database with a users
table...the people who will be the subscribers. I ...

I am trying to set up an operator using SQL Server 2000 to send email alerts
when a certain job has failed.
When i go to the properties of the operator and click the three dots next to
the email name I get the error message below

OK - new guy here - following the tutorials, I've modified them to
reflect my application's basic needs, and the notifications are coming
to the htm file fine.  I've now added a delivery channel, and updated
myself (the only subscriber) and my device to be using the email

I am using the notification classes using c# to manage subscriibers,
subscriptions, etc. However, this application is on a different server than
the notifications database. How can i tell the c# program where to save the
subscribers to? The app works fine on the same machine, but ...

I need to flag some subscribers as default recipients for a specific
subscription class. In other words, they need to recieve all notifications
sent by a subscription class. Is this possible? What would be the best
strategy?

hi all expert.
i am implementing SQL NS(sp1) in clustereed environment..
first of all..at Test machine (not Clustered), it works well...
Subscriber and Subscription is created welll and Event is created well...

I have made some progress towards getting external activation setup for
a windows service we have. I am now encountering an error in the SQL
Server error log that occurs when the event notification for queue
activation should be created. The error is...

I am basically new to sql server 2000 within the last 6 months. At my small
company, I was told that they want me to sent out alerts for reasons like a
database has reached 80% of its maximum capacity. I am suppose to setup
backup and restore procedures.