I need to get the history of all users that logged into a sql server database on a specific date . i already tried select * from sys,syslogins.
One way is
SELECT * FROM sys.database_principals
WHERE TYPE='S' --- SQL_user
or just use the top portion
SELECT * FROM sys.database_principals
another way if you have permission:
Write click on database...
Reports>Standard Report>user statistic