I need to fetch the user activity log of all the database of a particular server through Code. I have two querries,
1. How to get a list of all the databases in a particular server ?
2. How to retrive the user activity details log ?
The user activity details log can be fetched manually from Database Properties -> Info Tab (2nd tab) -> User Detail
I need to retrieve this log through code.
If at all this is possible through code then it will be very helpful.
Thanks in advance to all of you for any help.