About the Talk
January 29, 2011 11:00 AM
Bammel Church of Christ, 2700 FM 1960 West, Houston, TX 77068Bammel 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.