Tuesday, January 15, 2008

How to Debug Your MS - SQL Server 2005 Stored Procedure ?

Let us start with this Example :


1.Open Visual Studio 2005


2.Select from View menu > Server Explorer then choose

Connect to databas

3. Enter Server name , Authentcation Mode and Select Your Database


4.Browse to select your Stored Procedure as Following :



then Right click > Step Into Stored Procedure
5.Now , Start Debugging with Your Stored Procedure and Have a nice Bugs :)

2 comments:

Anonymous said...

Thanks,
please note that you can debug using the following keys:
-F10 Step Next.
-F11 Step Into.
-F5 Run.

Anonymous said...

Sorry! You can also Apply the above steps with UDF of SQL Server.