To audit SQL Server 7.0 activity on a deeper level, you could use the Profiler to capture both successful logins and SQL statements issued by users.

Using SQL Server Profiler SQL Server Profiler is a separate application that lets you view the queries being run on the SQL Server database engine in real time as they complete.

SQL DBAs (database administrators) are always looking for ways they can optimise their datasets. Even a small increase in performance can deliver dividends that translate into cost savings and ...

First, where Profiler under SQL Server 7.0 used the Registry to store connection information and sample trace definitions, SQL Profiler on Server 2000 does not.

SQL Profiler and SQL Trace: These two features are the graphic and textual interface to trace SQL Server performance data by capturing and saving details about a given set of trig­gering “events.” SQL ...

The SQL Profiler has a neat Deadlock Graph feature which is very useful. Let’s take a look…. When SQL Server detects a deadlock, it has to do something about it.

SQL Server Profiler has always been a great tool for tracing activity “under the hood” on a SQL Server and assessing its performance. One feature that helps us quickly set up a trace on our ...