How to call .Net programs from sql stored procedures

May 13, 2010 at 11:13 AM
Edited May 13, 2010 at 11:15 AM
How to call .Net programs from sql stored procedures. Can you please help on the this. Thanks in advance.
May 13, 2010 at 3:06 PM

If you are using SQL 2005/2008 you can create managed stored procedures. Those procedures will run in a CLR hosted inside the SQL server.

May 14, 2010 at 5:20 AM

Thank you very much. Can you pls give an example that whould be helpfull for me.

Thanks in advance.

 

May 15, 2010 at 1:11 AM

check:

http://msdn.microsoft.com/en-us/library/5czye81z(VS.80).aspx

or

http://www.sqlteam.com/article/writing-clr-stored-procedures-in-charp-introduction-to-charp-part-1