GitHub

set-trace-display-defaults-sql-server-profiler.md

Explore the tool options that SQL Server Profiler uses by default in traces, such as the font type, size, and style, and learn how to adjust them. This topic describes how to set tool options, which ...
GitHub

set-a-maximum-file-size-for-a-trace-file-sql-server-profiler.md

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] Use the following procedure ...
Computerworld

Auditing in SQL Server 2000

In the past, the question of how to perform auditing under SQL Server has had a simple answer: Do it yourself. But now, SQL Server 2000 has eased the burden of auditing by introducing an extensive and ...
Network World

Don’t play the victim – use the SQL Profiler deadlock graph

One of the dreaded error codes we get in the SQL log is the “1205”. It represents the infamous deadlock where two transactions are locking each other out. No way ...