How:Debugging SQL With the Visual Studio .NET debugger

 You can debug SQL Server stored procedures, functions, and triggers in much the same way that you debug other kinds of scripts or programs from Visual Studio .Net IDE.
Note   SQL debugging with Microsoft SQL Server 7.0 or SQL Server 2000 requires Visual Studio .NET Enterprise Developer or Visual Studio .NET Enterprise Architect Edition.

In This Section

Debugging SQL Stored Procedures
Provides instructions on debugging stored procedures from Server Explorer or from a source window.
Debugging Extended Stored Procedures
Defines an extended stored procedures and provides steps for debugging one.
Walkthrough: Debugging Hello World, a SQL Stored Procedure
Demonstrates how to debug stored procedures on a SQL Server. Information includes connecting to a database, creating a stored procedure, stepping into a stored procedure, setting breakpoints, viewing parameters and local variables in the Locals window, and dragging variables from the Text editor into the Watch window.
SQL and Mixed-Language Debugging
Describes debugging mixed-language applications, supported technologies, debugging remote applications, component requirements, enable SQL debugging, SQL debugging and running applications, and T-SQL and managed or unmanaged code.
Monitoring the Flow of SQL Debugging Information
Suggests using the Network Monitor (NetMon) or a similar tool to monitor the flow of SQL debugging information and provides a pointer to the Network Monitor documentation.
SQL Debugging Limitations
List the limitations that apply to debugging SQL source code.
Setting Up SQL Debugging
Lists software requirements for SQL debugging (for the server and workstation), instructions for enabling SQL debugging, installing, configuring, and troubleshooting setup.
SQL Debugging Setup Errors and Troubleshooting
List issues you may encounter when setting up SQL debugging and solutions to those problems.

Related Sections

Overview of Visual Database Tools
Describes Microsoft Visual Database Tools and provides links to: what's new in Visual Database Tools, Visual Database Tools components, work you can do with the Visual Database Tools, relationship between Visual Database Tools and databases, and database connections and references.
SQLExecDirect
Provides reference material for SQLExecDirect, which executes a preparable statement, using the current values of the parameter marker variables if any parameters exist in the statement. SQLExecDirect is the fastest way to submit an SQL statement for one-time execution.
SQLExecute
Provides reference material for SQLExecute, which executes a prepared statement, using the current values of the parameter marker variables if any parameter markers exist in the statement.
System Stored Procedures
List system stored procedures (Transact-SQL Reference).
Debugging Home Page
Provides links to the larger sections of the debugging documentation. Information includes what's new in the debugger, settings and preparation, breakpoints, handling exceptions, edit and continue, debugging managed code, debugging Visual C++ projects, debugging COM and ActiveX, debugging DLLs, debugging SQL, and the user interface references.

Wann More...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vsdebug/html/_core_debugging_sql.asp

More More...

Troubleshooting tips for T-SQL Debugger in Visual Studio .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;817178

HOW TO: Debug Stored Procedures in Visual Studio .NET
http://support.microsoft.com/kb/316549/

Cheers..

Suresh Behera

 

No Comments