Comments ..... This SP creates trace file for auditing purpose. select row_number() over(order by start_time desc) as RowNumber, ID, start_time, path from sys.traces ...
This article gives an overview and offers a practical tips to detecting some suspicious activities in Microsoft SQL Server, from configuring audit policies to leveraging Elastic for effective ...
SQL Server 2008 has some great new features. One of them is the new auditing capability. Now we can audit at the server, database and table level according to specifications provided by the DBA. We ...
When setting a CustomColumn value as null the audit fails to save throwing an error complaining about a missing parameter. The audit table custom column is nullable ...
BANGALORE, INDIA: Developers and DBAs using Microsoft SQL Server always look for ways to log events of interest to them as they occur on the server. SQL Server '08 fulfills this need with the ...