No new comments.
View All Comments
No new messages.
View All Messages
No new notifications.
View All Notifications
LEARN: Introduction to Entity Framework
An Interview Question
Ask a Question
How do I
Coding Best Practices
Internet & Web
Internet of Things
Universal Windows Platform
VR and AR
Databases & DBA
Design Patterns & Practices
C, C++, MFC
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
Introduction To Entity Framework
Exception Handling Mechanism In .NET
Creating ASP.NET Core, Angular2 Shopping Cart Using Web API And EF 1.0.1
Calculating Distance Using Google Maps In ASP.NET MVC
Learn Big Data With Me - Hive
Calling A C# Function With jQuery AJAX In ASP.NET MVC
AngularJS Login Form With ASP.NET
Getting Started With SQL Server 2016
Five Free Productivity Tools That Every Web Developer Should Use
HTTP Get, Put, Post And Delete Verbs In ASP.NET WEB API