In previous versions of SQL Server, database administrators used to audit via a server-side trace or a with a profiler trace constantly running in a logged on user’s session. SQL Server 2008 however provides a new auditing feature called “SQL Server Audit”.
