Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SamC
White Water Yakist
3467 Posts |
 Posted - 2003-03-26 : 16:58:44
|
| I may not remember this correctly, but I thought I saw a SQL stored procedure that would verify the existence of an email address against a remote SMTP server.Anyone heard of this? I'd like to be able to generate a report of questionable email addresses.Sam |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-26 : 17:04:58
|
| I have never heard of this. I am definitely curious to know if this exists because we've got a project that could really use something like this.Tara |
 |
|
|
darinh
Yak Posting Veteran
58 Posts |
Posted - 2003-03-26 : 17:34:05
|
| It's not SQL but try..[url]http://www.15seconds.com/issue/030203.htm[/url] |
|
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2003-03-27 : 10:41:21
|
| Tara,I hope to give this a try in the coming weeks. If you have any experience with this suggestion, please let me know.Sam |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-27 : 12:33:39
|
quote:
Tara,I hope to give this a try in the coming weeks. If you have any experience with this suggestion, please let me know.
I forwarded the document to two developers here at my work. They had come up with a different solution to their problem because they didn't know how to validate e-mail addresses. The solution is in production now, but maybe we can go back and put this one in instead.Tara |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2003-04-04 : 07:39:35
|
| I remember seeing a skeleton stored proc posted here to validate the structure of an email address....so that it conformed to acceptable naming conventions.however...rather than deal with ensuring an address is valid at point of entry...why not ignore how valid it is or not...and just deal with the results of the bad-addresses.....after all an email address may be valid today, but deleted tomorrow....and how is your application going to know about that change?dealing with the results of the bad addresses could be done simply by following this link....http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=22270I also remember seeing a sample proc to validate IP addresses for existance (or to translate a webname into an ip address (I can't remember which))...which be what you were thinking of....and which might be of some use to you.... |
|
|
|
|
|
|
Verifying E-mail addresses