Monitor SQL TCP traffic on the client I have a Windows 7 client that has a data driven application that connects to our SQL Server 2008 R2.
How can I view all the traffic between this software and the DB?
I would mainly like to see queries and responses.
Probably the simplest would be to run a server-side or client-side trace using SQL Server Profiler.

Another option might be to use a protocol analyzer, such as WireShark, or one of the many mentioned in this search result: https://duckduckgo.com/?q=tcp+protocol+analyzer&amp;t=ffsb