Thanks....

Thanks for your quick response Gail and Grant...!!

I understand and agree with you on a point that session should not be killed automatically unless we know what it is but...

Hi All,

I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join these...

Hi All,

I have used sys.dm_exec_query_stats and sys.sysprocesses to find long running queries particulary more than 60 minutes. But, as am not gud at sql scripting not able to join these...

Hi Paulino PP,

Could you please share information on how did you implement this solution using SSIS.

Thanks.!

Thanks a lot Dirk for your quick response..!!

Info provided is really good but am looking for a such a automating scripts that should be running on one server and retrieves...

Hi All,

Your the scripts is awesome..!!

Can you guide how this can be modified to get the same information for multiple servers i.e running this script in one server that will...

Where is the .sql File. Also, i do not see SP code for TableHTML