I'm looking for user activity audit tables/views in Sql server 2005.
Do they already exist or do i have to custom create them?
On my server, I have already configured security to do login auditing.
Where does that data go to?
There are ways of looking at the transaction log, but that is fairly deep. If your application needs this on a fairly regular basis, I'd suggest that each table needs some of the following:
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…