How to debugg a stored procedure.

Posted by Sahoo under Sql Server on 3/21/2012 | Points: 10 | Views : 2965 | Status : [Member] | Replies : 4
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.




Responses

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

Up
0
Down
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

Up
0
Down
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
Posted by: Sriramnandha on: 5/19/2012 [Member] Starter | Points: 25

Up
0
Down
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

Login to post response