Track User Activity
Track the User activity on a SQL machine by using the following command and you can check theType of Command the user used
- The Login Time and the When the last batch got executed
- From which program the server got invoked
- CPU and Memory using
- DB Usage
select * from master.dbo.sysprocesses where nt_username = 'Author'