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



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


DevelopmentNow Blog