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

  • +1 for the duckduckgo - I've been meaning to change over for a while. Basically, I think at this point Google knows more about me than my girlfriend and mother combined! – Vérace Nov 20 '15 at 19:57
  • undoubtedly! Use the Duck, Luke! – Max Vernon Nov 20 '15 at 20:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.