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&t=ffsb