Scott Hanselman

Extended Stored Procedures Considered Harmful?

January 13, '03 Comments [0] Posted in Web Services
Sponsored By

With Yukon on the horizon, I'm thinking about the "unmanaged Yukon equivalent" we have now - Extended Stored Procedures.  I've used them in the past for such cleverness as calling out to Ws Services from within SQL Server and calling back to other boxes in an asychronous Observer-Observable pattern to let folks know about Data Changing for cache clearing events.

Now, no doubt Yukon will be much more robust even hosting in-proc componentry via Application Domains or out of proc via an ASP_WP style worker process, but until then, are Extended Stored Procedures (in VB6 and C++) evil? See http://tinyurl.com/4er4 (Google Groups Post)

About Scott

Scott Hanselman is a former professor, former Chief Architect in finance, now speaker, consultant, father, diabetic, and Microsoft employee. He is a failed stand-up comic, a cornrower, and a book author.

facebook twitter subscribe
About   Newsletter
Sponsored By
Hosting By
Dedicated Windows Server Hosting by SherWeb
Comments are closed.

Disclaimer: The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.