I have a similar problem. We have a log shipping setup for DR. The transaction log file of the secondary database, which is in restoring mode, is 7 times...

Thank you! I tried it but it is not giving me the desired result. The whole purpose was to identify all databases not touched/accessed for the past six months, if...

It is BEFORE. The whole purpose was to identify all databases not touched/accessed for the past six months, if any, and then do something/research about them. I agree with what...

Many Thanks. That is what I was looking exactly. Do you know any script that lists all users with all their permissions in all databases on a particular server/instance.