Debugging StoredProcedure Param in CSharp

[Sabari]

Hi,
I have a SQL Stored Procedure that has 20 to 25 parameters to be
passed.I run into problems when i assign wrong valuse to parameters.I
have heard that it is possible to debug SQL StoredProcedures in VS.Net
and im using VS.Net 2003.Can anyone explain that.
Thanks and Regards
R.Sabari

 

[Robert Hurlbut [MVP]]

Here are a couple of articles to get you started:

http://www.ftponline.com/vsm/2002_11/magazine/columns/databasedesign/default.aspx

http://techrepublic.com.com/5102-6313-5161626.html

Robert Hurlbut, MVP - Visual C#
http://weblogs.asp.net/rhurlbut
http://www.securedevelop.net

 

[Mohamoss]

Hi Sabari
Here is an article on how to debug stored procedures form within your
VB.net project . I believe it would help
http://www.ftponline.com/vsm/2002_11/magazine/columns/databasedesign/
Mohamed M .Mahfouz
Developer Support Engineer
ITWorx on behalf of Microsoft EMEA GTSC

 

[Sabari]

Hi,
Thanks for the replies.It helped me out a great deal.Thx a lot
Robert and Mohamoss