How to Debug Stored Procedure in Sql Server 2008

Posted by Nandkishorre under Sql Server on 8/24/2012 | Points: 10 | Views : 2661 | Status : [Member] | Replies : 2
Hi,
I am using Stored Procedure to retrive the data from database instead of SQL Query.

How to debug step by step the Stored Procedure in Sql Server 2008 ?

If any one About this tell me.

Regards
Nanda Kishore.CH




Responses

Posted by: Pandians on: 8/24/2012 [Member] [MVP] Silver | Points: 25

Up
0
Down
Check It Out!

1. You should have windows authentication in sql server (In which login you have used for Windows login)
2. Port: 135 has to be included in Firewall exception
3. Add sql server management studio (SSMS.exe) in Firewall exception list

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Nandkishorre, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ranjeet_8 on: 8/24/2012 [Member] [MVP] Gold | Points: 25

Up
0
Down
Refer this url.
this will help u
http://www.codeproject.com/Articles/20140/SQL-Stored-Procedure-Debugging-from-SQL-Query-Anal

.

Nandkishorre, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response