Sending Emails From Stored Procedures

  • Hai, iam having 1 problem

    i want to send emails via stored procedures,

    like birthday greetings, 

    iam using 3rd party webhosting services.

    http://www.webhost4life.com

    now all the users who registers onto mysite

    puts his information like name,address and birthdate.

    what i want to do is the day when his birthday comes, i want to send an email to him, saying "Happy Birthday"

    i can do that by making a job and firing a stored procedures which will check todays date and the candidates birthdate , if its the same it will fire an email.

    i cannot use cdonts, via stored procedure, any other way pls tell.

    i dont have sysadmin rights on the webhost4life. so i cannot use all the features in sqlserver.

    pls tell any way to fire an asp page?

    <a href="http://www.websolsoftware.com"> For IT jobs click here</a>

    *Sukhoi*[font="Arial Narrow"][/font]

  • If you're not allowed sysadminsrights, do you think that they would let you send emails out of their control?

    Why don't you ask the serverowners for their suggestion about what you want to do?

    /Kenneth

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply