April 7, 2015 at 3:04 pm
Hello,
I need to know how i can find information for the items listed below. I need to make a list.
Database Name
Log Start
Username
Account Status
Host
Lock Date
Module (client tool)
Trunc_Logon Date
April 8, 2015 at 4:43 am
If you mean that you need to track actions within the database, you should look to Trace or Extended Events to capture the queries that are performing actions that you're interested in capturing.
The list you have is not a generic list of SQL Server activities. It's something that is product or database specific. You'll need to clarify what's needed around that to understand specifically which actions you need to capture.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply