How to debugg a stored procedure.

Posted by Sahoo under Sql Server on 3/21/2012 | Points: 10 | Views : 3846 | Status : [Member] | Replies : 4

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Hi,

Is there is any way to debug a stored procedure In visual studio 10(Professional edition) and SQL SERVER .For ex.We are setting break point in code.Like that Can we set BREAKPOINT like thing in SQL SERVER to test it.

Many many thanks in advance 4 trick.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Gopinath on: 3/21/2012 [Member] Starter | Points: 25

0	hi, Please refer this link http://msdn.microsoft.com/en-us/library/yet1b7by%28VS.80%29.aspx,it might useful to you. C.Gopinath Sahoo, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Gopinath on: 3/21/2012 [Member] Starter | Points: 25

0	hi, And also refer this link http://www.mssqltips.com/sqlservertip/1695/sql-server-2008-tsql-debugger-is-back-in-ssms/. C.Gopinath Sahoo, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Patel28rajendra on: 3/22/2012 [Member] Starter | Points: 25

0	Hi visit this link http://www.4guysfromrolla.com/articles/051607-1.aspx http://tlchen.wordpress.com/2008/08/01/how-to-debug-stored-procedure-from-vs-2008/ R D Patel Sahoo, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sriramnandha on: 5/19/2012 [Member] Starter | Points: 25

0	HI, STEP 1: GO TO SQL SERVER MANAGEMENT STUDIO SELECT YOUR STORED PROCEDURE. STEP 2: RIGHT CLICK YOUR STORED PROCEDURE STEP 3: EXECUTE STORED PROCEDURE. STEP 4: PASSING THE VALUES. HOPE THIS WILL HELP REGARDS SRIRAM.R sriram Sahoo, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts