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

sql server job or alert to send out email
Posted by TRACEY at 11/28/2006 11:50:02 AM
i am trying to get sql to send alert job email using 64 bit I keep reading it can work Even if i click on sql server agent mail session mail profile i get 18038 sql mail does not work with 64 bit version of SQL Server So how do you send email when using a job or an alert. I set up the ...more >>


Variable in SMTP Protocol
Posted by Kevin Eckart at 11/21/2006 2:12:26 PM
I would like to include a variable in the Subject field of an email sent from Notification Services. Is there a way to do this? What is the limitation of the <SQLExpression></SQLExpression> tag in the Protocol? Is this where I would grab my variable? Below is the protocol portion of my ADF ...more >>

Scheduled Subscriptions
Posted by Avi at 11/17/2006 12:22:03 AM
Hi I have created an application that sends SMS messages to subscribers on tourism packages. In the Subscriptions iv'e added 2 subscriptionson on a daily basis for the user - The first one is 3 minutes after the first subscription and the pther is in the user requested subscription hour. The p...more >>

How to verify if subscriber exists?
Posted by Aleksey at 11/10/2006 4:16:01 PM
What is the right way to check if a subscriber exists already? Subscriber.Add() raises an error if the ID is already there, and SubscriberEnumeration raises an error if it is not there. How can I do that without errors? I cannot find a method or property for that... ...more >>

Notification to SMS message
Posted by robin9876 NO[at]SPAM hotmail.com at 11/10/2006 7:51:48 AM
Can SQL 2005 notification services be configured to send a SMS message? If it is possible what additional hardware/software is required? ...more >>



DevelopmentNow Blog