
	Home > SQL Server Tips > Database Development > How to debug T-SQL stored procedures

SQL Server Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE DEVELOPMENT

How to debug T-SQL stored procedures

Joe Toscano, Contributor
07.06.2006
Rating: -3.71- (out of 5)

Expert advice on database development

Digg This! StumbleUpon Del.icio.us

Continuing our series on how to tune and improve your Transact-SQL 2005 stored procedure code, this tip covers Visual Studio 2005 debugging capabilities.

I will execute -- or step into -- a sample T-SQL stored procedure and assign values to input parameters, inspect variable contents, follow the logical flow of the procedure during runtime, evaluate T-SQL expressions, view the procedure's output, set breakpoints and generally examine the state of the environment. (Future tips will continue along this same theme.) We will debug our procedure, not from Management Studio but from the Visual Studio 2005 development environment. I mention this because under SQL Server 2000 we are able to debug stored procedures using Query Analyzer. Per...

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL Server Stored Procedures
	SQL Server Mailbag: CALs, witnesses and unwanted changes
	SQL Server Mailbag: Stored procedures, triggers and SSRS reports
	Top tips and tricks for SQL Server database development
	Top 10 SQL Server development tips of 2008
	SQL Server trigger vs. stored procedure to receive data notification
	SQL Server errors, failures and other problems fixed from the trenches
	SQL Server and data manipulation in T-SQL
	How to use SQL Server 2008 hierarchyid data type
	SQL Server stored procedures tutorial: Write, tune and get examples
	Check SQL Server database and log file size with this stored procedure

SQL/Transact SQL (T-SQL)

Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server

SQL language crash course (just enough to be dangerous)

Working with IntelliSense in SQL Server 2008 Management Studio

SQL Server Mailbag: Stored procedures, triggers and SSRS reports

Working with sparse columns in SQL Server 2008

Determining the source of full transaction logs in SQL Server

New GROUP BY option provides better data control in SQL Server 2008

Using the OPENROWSET function in SQL Server

Loading data files with SQL Server's BULK INSERT statement

Importing and exporting bulk data with SQL Server's bcp utility

SQL/Transact SQL (T-SQL) Research

Database Development

Using DELETE and TRUNCATE TABLE statements to delete data in SQL Server

Speed up reports in SQL Server Reporting Services with caching

Data Transformation Services vs. SSIS: The key differences

Working with IntelliSense in SQL Server 2008 Management Studio

Top tips and tricks for SQL Server database development

Managing the development lifecycle with Visual Studio Team System 2008

Processing XML files with SQL Server functions

A first look at Visual Studio Team System 2008 Database Edition

How to create a SQL inner join and outer join: Basics to get started

New datetime data types in SQL Server 2008 offer flexibility

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

library (SearchSQLServer.com)

trigger (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

haps debugging capabilities will be added to Management Studio in the future.

ABOUT THE AUTHOR:

Joe Toscano
About the author: Joe Toscano is a SQL Server instructor, speaker and database consultant for Micro Endeavors Inc. He has worked extensively with SQL Server since version 6.5, as well as Sybase and Informix prior to that. Toscano's areas of expertise include Data Transformation Services (DTS), Integration Services (SSIS), Transact-SQL (T-SQL) programming, data warehousing, performance tuning, replication, high availability (mirroring), security, disaster recovery, upgrading, migration projects and lights-out DBA tasks.
Copyright 2006 TechTarget

Rate this Tip

To rate tips, you must be a member of SearchSQLServer.com.
Register now to start rating these tips. Log in if you are already a member.

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

SQL Server Development - .NET, C#, T-SQL, Visual Basic

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy