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.

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.

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.

For SQL Server, the easiest and most effective method for tracking server activity is the built-in Profiler application. It’s easy to set up SQL Profiler and you can maintain and run it from a ...

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 ...

A recently discovered vulnerability in Microsoft Corp.s SQL Server 2000 database allows users to mask their log-in names. The vulnerability was discovered by Imperva, a researcher and vendor of ...

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.

Microsoft has updated its SQL Server Management Studio to version 17.3, adding two features along with various minor enhancements and bug fixes. SSMS 17.3, made available for download earlier this ...

These were first introduced in SQL Server 2008, but didn't really catch on until SQL Server 2008 R2. The second is SQL Server profiler, which is available to every version of SQL Server starting ...