During the development phase of an application, any SQL scripts or stored procedures written will need to be tested to ensure they work as expected. By single-stepping through each line of SQL as it is executed by Microsoft® SQL Server™, Transact-SQL statements and stored procedures can be tested and debugged as necessary. This ensures more robust systems when the application is delivered and made available to users. SQL Server Profiler allows SQL statements or stored procedures executed by an application to be traced, line by line, as they are executed by SQL Server.
| Single-Stepping Traces | Replaying Traces |