all groups > sql server notification services > june 2004
SQL Authentication
Posted by Steve Youmans at 6/29/2004 10:06:03 AM
I have developed a subscription web site that will be
hosted on our web server which does not have SQL server
installed on it. I want to use SQL Authentication to
access the NS databases. I have registered the database
on the web server and set up the SQL account but when I
try and run t... more >>
Mail Attachment
Posted by m.frolov NO[at]SPAM sam-solutions.net at 6/29/2004 1:37:25 AM
Good day!
I wonder how I can attach some file to notification sent by SMTP
service configured like this
<DeliveryChannel>
<DeliveryChannelName>EmailChannel</DeliveryChannelName>
<ProtocolName>SMTP</ProtocolName>
<DeliveryChannel>
I use custom content formatter and can modify directl... more >>
SQL Stored Procedure in <Action> element of Subscription Class
Posted by Clint Jennings at 6/28/2004 10:08:56 AM
No one here has utilized a SQL stored proc for the action element of the
subscription class?
... more >>
Using Stored Procedure for <Action> element instead of Inline TSQL
Posted by Clint Jennings at 6/25/2004 9:25:44 AM
Has anyone successfully utilized a Stored Procedure to execute the <Action>
element instead of inline TSQL? I would like to utilize a stored proc
although not sure how to approach it. Would it be similiar to the Chronicle
table creation where it checks for existence, then creates it?
Clint
... more >>
Notification Upon Failure
Posted by Christine at 6/24/2004 1:23:13 PM
I have SQL 2000 (SP3a) set up to notify me only "Upon
Faiure" of a job. It was working fine until I made a
change to one of my maintenance plans. Now it is
notifying me upon successful completion of each job. We
have 2 SQL servers and it happens on both. It starts out
fine and with cha... more >>
Re: Notification Delay
Posted by jsmorris at 6/24/2004 7:29:40 AM
What is your quantum set at currently? Can you quantify how long this
delay is?
... more >>
Re: Event collection goes from weekly collecting of event to every minute!
Posted by jsmorris at 6/24/2004 7:26:47 AM
Thanks Joe. That is exactly the work around that I was thinking about
and I am sure that would work
I am still curious as to why this happens. In this instance the query
is not that expensive, but if it was, that would cause a tremendous
load on the source of the events' database.
If upgr... more >>
No Errors But No Notifications Being Generated
Posted by Steve Youmans at 6/23/2004 7:51:03 AM
I have a NS application that has an non-hosted event
generator that inserts information into the event tables.
I have defined my notification rules but they do not seem
to be invoked when the events are posted. I am not
getting any kind of error messages in the event log. (I
ran the sql... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SQL Mail
Posted by Mike Moore at 6/22/2004 1:19:17 PM
Is there any way to determine if an exchange server is
active before running sql mail?
We don't always no when maintenance is done on our
exchange servers.
The jobs run, but if the exchange server is down it does
no good. We show they ran, but it doesn't mean the email
went out. ... more >>
Event collection goes from weekly collecting of event to every minute!
Posted by jsmorris at 6/22/2004 12:40:39 PM
This is the second time this has happened to me in my production system
(SQL NS 2.0: v2.0.2114.0), so I hope someone here can help as I have
hit a wall to why this happens.
I have a hosted SQL event provider that is scheduled to run every seven
days. The configuration is this:
<HostedProvi... more >>
|