May 1, 2012 at 10:39 am
Hi Everyone,
Do we have an option of enable verbose logging in MS SQL 2008 ?
To be honest, I don't think the the SQL Agent Log is quite detailed or gives me the information I am looking for.
For an instance, I am looking for a log entry when the SQL user is deleted or the password for any SQL user is reset or when a new user is created ?
Any help on this is highly appreciated.
May 1, 2012 at 11:45 am
A Trace (accessible via Profiler or server-side trace) can be thought of as a logging mechanism for SQL Server. Using SQL Trace
Since you're on SQL Server 2008 you could also evaluate using Extended Events. Note that not all Trace Events were available as Extended Events in SQL 2008, although they are in SQL 2012. SQL Server Extended Events
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply