It looks like the Trace flags were turned on to check or change the SQL Server's activities.
Run the following command in your query analyzer. I hope in your case it will return you a line that will indicate that the Trace 1206 is turned on. The Trace 1206
prints the information of locks. But I am not sure what else it prints.
Run the TraceOff command to turn it off.
Note that these hold good for a single and current connection. If you are sure, that this is OK, and you want to do it at the server level, run the same commands with a -1 flag. .like,
DBCC TRACEOFF (1206, -1)
Needless to say, you need to be logged in with a SysAdmin role.