One feature that helps us quickly set up a trace on our current connection is new in SSMS 2008, namely “Trace Query in SQL Server Profiler”. Let’s take a look.

The flaw shows up in the use of SQL Profiler in Microsoft SQL Server 2000 to audit connections to SQL Server 2000 by using the Audit Login event class. When log-in names contain leading zero ...

As the CPU and memory architectures improved, new releases of SQL Server included new features to better instrument and troubleshoot those aspects of SQL Server processing. For example, SQL Profiler ...

Second, SQL Server 2000’s Profiler introduces template files, which replace both the Create Trace Wizard and the storage of trace definitions in the Registry.

Also, the Profiler captures only successful commands and logins; if a user issues a SQL command that is denied, for example, the SQL Server 7.0 Profiler will not report it.

Users simply: 1) connect to an SQL Server instance, 2) select a database, 3) select a table, 4) optionally adjust profiling settings, 5) press a button, and 6) view the results.

Idera, a leading provider of application and server management solutions, today announced the availability of SQL XEvent Profiler 1.0, a free tool that allows DBAs to create, run and view SQL ...

Brian Egler MCSE/MCT is a Microsoft SQL Server Course Director for Global Knowledge. He has more than 15 years' experience with SQL Server. Every year he runs the Boston Marathon for cancer research.