Learn how to use SQL Server Profiler to capture and analyze the trace data of your stored procedures and compare and contrast their code, performance, and recompilation.

Learn how to troubleshoot and resolve permission issues in your T-SQL stored procedures using EXECUTE AS, SQL Server Profiler, sys.fn_my_permissions, sp_helprotect, and TRY/CATCH blocks.

Then I would select a Profiler template to use and select events that I wish to trace such as Logins, Logouts, Stored Procedures starting, finishing, T-SQL Batches starting etc.

Notifications You must be signed in to change notification settings The first script SP_ReplaceFileOrDirNames.sql has to be ran first in order for the main script to work This first Script creates a ...

Discover how to limit the size of the trace file in SQL Server Profiler and how to specify whether the file rolls over when it reaches maximum size. [!INCLUDE SQL Server Azure SQL Managed Instance] ...

It will even trace Stored Procedure and Trigger code if your application uses it. But it also can be used to find out what the management tools are doing under the hood, like SQL Server Management ...

xp_trace% extended stored procedures, which you need to learn to use in order to perform those tasks that are too complex for Profiler to handle. SQL Server 2000, however, has greatly simplified ...