Thank you!

Thank you, this is nice link. If a maintenance job rebuilds indexes, will it record as an user action?

But database might not being used by any application.

It was permission issue.

Everything works now.

Thank you all

Based on the article, I created table

Create Table dbo.DatabaseAudit

(

ServerNamevarchar(255) Not Null

,DBNamevarchar(255) Not Null

,LoginTimedatetime Not Null

,LastBatchdatetime Not Null

,[Status]varchar(55) Not Null

,HostNamevarchar(255) Not Null

,ProgramNamevarchar(255) Not Null

,NTUserNamevarchar(255) Not Null

,LogiNamevarchar(255) Not Null

,AuditDatedatetime...

Based on the article, I created table

Create Table dbo.DatabaseAudit

(

ServerNamevarchar(255) Not Null

,DBNamevarchar(255) Not Null

,LoginTimedatetime Not Null

,LastBatchdatetime Not Null

,[Status]varchar(55) Not Null

,HostNamevarchar(255) Not Null

,ProgramNamevarchar(255) Not Null

,NTUserNamevarchar(255) Not Null

,LogiNamevarchar(255) Not Null

,AuditDatedatetime...

Thank you, great article, will review.

I am not user 'test1'. I put it just for example. Of cause I used the real user name 🙂

I am not user 'test1'. I put it just for example. Of cause I used the real user name 🙂

Thank you, SSChampion.

But I cannot run the query because do not have permission on sys.dm_db_index_usage_stats .

This code below does not help

USE master;

GO

GRANT VIEW SERVER STATE TO [test1]

GO