One of our databases changed to single_user mode. But we could not find the exact user, hostname etc. Is there is any way to find these details?
I had gone through the SQL Server Error logs and Windows event error logs. But could find the exact user who changed the database to single_user mode? Do database automatically changed to single user mode?