I'm facing a situation today where it would be very beneficial to me and my company if we knew who had logged into SQL and performed some deletions.
We have a situation where at least 2 (sometimes 3) people login to SQL using SQL Server Management Studio, and perform various functions.
What we need is an audit trail. If someone deletes records (mistakenly or otherwise), I'd like to know what was done.
Is there any way to make this happen?