Hi All

One of the production SQL Server 2000 sp1 running with Windows 2000 with SP 3.
Actually when some query is running at back end then server is going to hang and at same time it can not upload/download any image from the front end. Even if user
wants to issue any DML at that time he can not able to execute the same.

Trace doesn't show SQL Statement until timeout or query stop.

So my question is how can I find all the DYNAMIC SQL running at server end and
How can I stop a particular SQL from execution. Actually the problem is happening randomly.

Tx





---------------------------------
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
MS Sql Server LazyDBA home page