I have several number of user login with my sql server 2008.
Can i able to track what are all the users transacting with sql server like selecting,inserting,deleting,updating etc. with corresponding date,user, database, tables ?
Is there any inbuilt functions for taking logs ?
I tried DBCC logs('db_name'). I am not sure whether i am getting correctly the one i need.