Monitor database activity I would like to see what queries are being sent to a DB and what is returned. Is this possible with MsSQL Server Management Studio or a third party application?
 Is there anything i can use that is free?
You can as a minimum execute sp_who2 that will show session information, but more advanced and detailed methods are available, plenty of scripts available, it depends what you are after specifically. 

Great set of tools available at Brent Ozar: First Responder Kit

If you want a better tool to just look at  queries that are currently running, try sp_WhoIsActive, by Adam Machanic.