SQL Server 2005 freezes (because of application), need logging

2018-06-05 07:16:50

This question already has an answer here:

How do I UPDATE from a SELECT in SQL Server? 27 answers

I guess you can use SQL Server Profiler traces to see which queries are the cause:

Save Trace Results to a File (SQL Server Profiler)

链接地址: http://www.djcxy.com/p/16864.html