No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Who is a Microsoft Regional Director?
An Interview Question
Ask a Question
C, C++, MFC
Universal Windows Platform
Algorithms in C#
Coding Best Practices
Databases & DBA
Learn C# Corner
Reports using C#
Internet & Web
Internet of Things
Request a new Category
Steps to Debug a stored procedure of SQL server 2008 using Visual Studio 2010
Perform all these steps on a machine with SQL server installed.
Window key + R and Write: compmgmt.msc
That will open the Computer Management Console; in the left pane expand tree view from system tools >> local users and groups >> groups. Double click "Administrators" which appears in the right pane, as shown below.
On double clicking Administrators the following dialog appears, in which you have to add the user name from where you are going to connect to the server using Visual Studio 2010 and want to debug. So to add a user click the add button as shown below.
After the Add... button is clicked the following dialog appears, in which you give user name and click ok as shown in the dialog box below.
Now switch to Visual Studio 2010 and open the "Server Explorer" and then click the "connect to database" button as shown below.
Fill all the information in the "Add connection" dialog. As shown below.
You can click the "Test connection" button to test the connection as shown below.
Expand the stored procedure folder under the SQL server name and double click the stored procedure that you want to debug (for example "addimg"). Now double clicking it will result in displaying the script of the stored procedure. Then put the breakpoint in your desired location in the script, as shown below.
Now right click the same stored procedure and select "Step into Stored procedure" from the context menu which appears on the right click as shown below.
The "Run stored procedure" dialog will appear in which you need to fill in all the input parameters which are declared when the stored procedure is created.
Bingoâ€¦â€¦â€¦â€¦.Success in debugging the stored procedure
SQL server 2008
Visual Studio 2010
Factory Method Design Pattern In C#
ASP.NET MVC - Passing Data From Controller To View
Insert Data By Stored Procedure In MVC 5.0 With Data First Approach
SPA Using Angular 2, ASP.NET Core 1.1 And Entity Framework Core - Part One
Steps To Perform CRUD Operations Using AngularJS And Stored Procedure In An ASP.NET MVC
$q Service In AngularJS
CRUD Operation Using Single Stored Procedure In ASP.NET MVC Of Real-Time Project
Overview And Getting Started With AngularJS In ASP.NET Using Visual Studio 2017
Aggregate Function With LINQ In C#
ASP.NET Core Fundamentals Step By Step