It's not correct to say that an extended stored procedure is needed, you can trigger a job (with active-x jobstep) that reads information about the email to be sent from the database and sends it (assuming SQL Server Agent is running). Or you can have a job that periodically polls the DB to see if there's anything to be sent.