June 28, 2007 at 12:36 am
In that case what the previous caller says is right. One thing that strikes me is to do a check everyday for the integrity of your datastrucutre and mail to you if anything has changed so that you can track what has changed and then fire the customer.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 1:10 am
June 28, 2007 at 1:59 am
You are using SQL 2005 and its easy to use email functionality there with the new DBMAIL feature thats available with it. All you neeed to know is your smtp server name or the IP address. There are many documents/links that are available in the net for DBMAil.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 6:05 am
Thanks, but am using SQL Server 2000 at present.
Learning new technologies as I go along.
I do not want to rush things, rather to learn on a need-to-know basis, so I'll familiarise myself with DBMail now but do not know if I will implement it anytime soon.
Issue resolved.
Thanks to all the Good Guys (not me!) here.
June 28, 2007 at 6:27 am
You have posted in SQL 2005 forums thats why i said to use DB Mail feature. If 2000 you can get a procedure in this site the uses CDO messaging to send mails as said earlier that too will require only the SMTP server name.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
June 28, 2007 at 11:27 pm
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply