Can a stored proc check an email address?

[donutman]

Given an email address is there a way to check the string after the @ symbol to be sure that the DNS server can find the email's domain? In other words is there a way to have the SQL server do a DNS lookup?
Karl

[red] Cursors, triggers, user-defined functions and dynamic SQL are an axis of evil![/red]
[green]Life's uncertain...eat dessert first...www.deerfieldbakery.com[/green]

 

[vbkris]

not directly using SQL Server, but however it may be possible using extended SPs. just give it a try...

Known is handfull, Unknown is worldfull