Title: Using traces in SQL Server 2008 without the Profiler
Duration: 15:21 min.
Summary: One of the most important tasks that a DBA and a developer should be able to accomplish while using SQL Server is to capture the statements sent to the server in a trace file. The tool used to capture and manage trace files in SQL Server is the SQL Profiler. However, SQL Profiler is not the only way to capture trace files: it is possible to start a trace using only T-SQL commands. This video show two stored procedure that start and stop trace in SQL Server 2008 in order to capture the statements send by a user during a session with SQL Server. The video explain all the commands of the procedures and show how to use them.
Technologies: SQL Server.
Methodology: The video uses examples to explain how to create two stored procedure that start and stop a trace via T-SQL commands. The commands inside the stored procedures are explained step by step, showing how to use the system stored procedure to create, starts and stop traces.
Built Examples: The video show how to create two stored procedure that start and stop traces. Also, the video show a example of how to use them to catpure a trace.
Keywords: SQL Server, Trace, Profiler.