Sql 2005 Managed Stored Procedures

[rokitsalad]

A few questions, really:

Is anyone using this feature? Why?

Is anyone avoiding this feature? Why?

I'm doing some research to find some new technologies for a client's app.

Thanks in advance.

[Andrew Cushen]

Hmm.

I've seen a few articles on this new feature, but no one I know is using it.

I think it comes down to 2 things:

1) Stored Procedures in T-SQL work fine; we know them well, why learn yet ANOTHER new thing?

2) Questions about Security, debuggability, reliability - in short, questions about a new, unproven technology that replaces (in part, at least) a proven one.

It seems to me that they add more complexity to the situation, and I don't see a clear benefit.

Perhaps someone out there is using them, has seen a benefit, and can tell us??



-Andrew

[Wiseman82]

Managed SPs are not supposed to replace T-SQL SPs. Each are useful for different purposes...
I think for the most part, T-SQL will dominate.

http://www.lakesidesql.com/articles/?p=4
http://forums.microsoft.com/MSDN/Sho...20625&SiteID=1
http://blogs.msdn.com/hans_vb/archiv...22/162370.aspx