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
Coding Best Practices
Universal Windows Platform
VR and AR
Databases & DBA
Design Patterns & Practices
Internet & Web
Internet of Things
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
What's New In Visual Studio 2017
Learn MongoDB Step By Step
Experience The New Features In Visual Studio 2017
Visual Studio 2017 New Features
Basic Information And Overview Of Visual Studio 2017
Introduction To Azure Machine Learning Studio
Learn Basics Of MVC Using AngularJS
Basic Operations In SharePoint 2013 Using PowerShell