Can we call c#.net code from sql server.

Question

Hi All Here i want to create a job in sql server and after that i need to schedule it. In creation of job i am pulling mobile numbers in my stored procedure.After that i want send a SMS through internet.For this i need to run c#.net code for sending SMS. please help me how to call c#.net code in sql server jobs or schedules or in stored procedure. thank you.

Vijaya Kadiyala · Answer

Hi you can send SMS from T-SQL. check out the below link http://www.sqlservercentral.com/Forums/Topic607227-9-1.aspx#bm607718 Thanks - Vijaya Kadiyala

Mamta M · Answer

Please refer following links: http://msdn.microsoft.com/en-us/library/ms190790.aspx http://www.devx.com/dotnet/Article/21286 Hope that helps Regards Mamta