This chapter started by investigating the software requirements necessary to set up SQL debugging and how to navigate the treacherous security waters that can surround your SQL debugging preparations . Then it looked at debugging a stored procedure directly from Visual Studio before examining how to debug an application that uses SQL Server. It finished with an analysis of the limitations of SQL debugging.
The ability to debug SQL means that the last major obstacle in end-to-end application debugging has been overcome . Although many developers veer away from delving into stored procedures, I would advise that you become accustomed to at least the fundamentals of SQL debugging. It makes understanding your applications much easier when you don't have to treat your database as a black box.