.net 3.5 - using code as a Stored Procedure to be triggered in SQL Server

Question

... here is my question (having searched the internet extensively).  Is it possible to have an ENTIRE solution (.net 3.5) as a stored procedure?  If so, have you got any example to share?  I currently trigger a SQL proc from one .net module, when it finishes I want it to trigger a SECOND .net module to analyze the data gathered.

I have successfully created a "StoredProcedures" class in a .net 3.5 SqlServerProject..... but only to do the mundane.  I need to trigger a multifaceted project with all of its components.

---

dexintx

Answer 1

You can create CLR Stored Procedures in SQL Server however it is hard to say based on the information above whether you can place all components of your project in CLR stored procs...

http://msdn.microsoft.com/en-us/library/ms131094.aspx

...you can also do things like call a web service from a CLR Stored Procedure/Function (once external access permission is set on your assembly) where other components can be implemented, i.e...

http://www.codeproject.com/Articles/86436/Executing-a-Web-Service-in-a-CLR-Based-Table-Value

...hopefully the above gives you some ideas on how you can design your solution.

Thanks

---

/Neil Moorthy - Senior SQL Server DBA/Developer (MCITP (2005/2008), MCAD, ITILv3, OCA 11g) Please click the Mark as Answer button if a post solves your problem