Main Content

Stored procedure tracing using the xml datatype

A talk by rloski at SQL Saturday #57

About the Talk

January 29, 2011 11:00 AM

Bammel Church of Christ, 2700 FM 1960 West, Houston, TX 77068

Bammel Church of Christ, 2700 FM 1960 West, Houston, TX 77068

When running a stored procedure it is difficult to record what is happening. In this session we will develop logger code in T-SQL to add to your stored procedures. We will use the xml datatype to record parameter values, variable values and debug statements. We will look at the "For xml" statement as well as the xml datatype methods, especially the modify method. Finally we will look at how to read the logs when finished.

Ratings and Recommendations

This Talk hasn't been rated yet. Sign In to rate Talks.

comments powered by Disqus