SQL Server Performance Forum – Threads Archive

Merit & demerit of Stored Procedure

Hi Guys,
Recently I have faced an interview where I am asked about the merits and demerits of Stored Procedured. I am aware of merits of stored proceure but not know what are the demerits or pitfalls of stored procedure. Can you please update regarding this. Best Regards,
Papak Mondal

---

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=66365
http://www.frontbase.com/cgi-bin/We…1/wa/supportPage?currentPage=Faqs&faqKindId=1

---

http://databases.about.com/od/sqlserver/l/aastoredprocs.htm
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11611 Madhivanan Failing to plan is Planning to fail

---

Yes I got the answer. Thank you very much. Best Regards,
Papak Mondal

---

]]>