how to Call registered DLL function from T-SQL?
Posted on 2008-10-20
I have created one DLL in .NET which has only one function in it which sends email with SMTP. Function name is SendMail which accepts parameters like to, from, subject, SMTP servername, UserName and other.
Now if i register that DLL on my SQL server then can i call that SendMail function from my T-SQL code and pass those parameters values from Query it self?
I know its possible but how to achieve that i do not know. So, please Experts do the needfull.
Thanks in Advance and Regards.