Member Avatar for coollife

In every asp.net webpage i am using more than one sql commands to get the data and store it in data set.

after the execution of the front end asp.net is it possible to go back and open sql server and see in a window which all statements got executed and their value.

My sir was saying that there is some query window which displays all the information

Please let me know the correct answer . Thank u

  • 2 Contributors
  • 1 Reply
  • 79 Views
  • 13 Hours Discussion Span
  • Latest Post Latest Post by sknake
Member Avatar for sknake

You want a tool called the "SQL Server Profiler" which catches query and transaction information. It is a available as a "Performance Tool" for the full installations of SQL.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.