For anyone who faced a smilar situation, I went to 'Management' in the SQL Server (it is there at the same level the 'Databases', 'Security', etc) -> 'SQL Server Logs'...

Thanks Jeremy and Grant Fritchey for your reply!

Jeremy, when I tried to execute the select count(*) query, it kept on executing but did not finish execution. With select * query,...