Sql 2005 Managed Stored Procedures


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Sql 2005 Managed Stored Procedures

  1. #1
    Join Date
    Sep 2006
    Posts
    1

    Question Sql 2005 Managed Stored Procedures

    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.

  2. #2
    Join Date
    Apr 2004
    Location
    New York City
    Posts
    538
    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

  3. #3
    Join Date
    Feb 2006
    Posts
    55
    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
    David Wiseman
    MCSE (2000/2003), MCSA (2003), MCDBA
    www.wisesoft.co.uk


Similar Threads

  1. Replies: 4
    Last Post: 05-19-2006, 04:58 PM
  2. Stored procedures and multiple databases
    By Col in forum VB Classic
    Replies: 0
    Last Post: 10-25-2001, 09:34 PM
  3. SQL Servere - stored procedures
    By Scott in forum VB Classic
    Replies: 3
    Last Post: 01-11-2001, 08:15 PM
  4. Dynamic SQL or Stored Procedures..your opinion
    By Jamie Cross in forum authorevents.mitchell
    Replies: 1
    Last Post: 10-17-2000, 06:07 PM
  5. Replies: 0
    Last Post: 07-28-2000, 11:42 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center