Home Forums SQL Server 2008 SQL Server 2008 Administration How can I kill ad-hoc or long time running queries, safely? RE: How can I kill ad-hoc or long time running queries, safely?

  • May 9, 2013 at 10:20 am

    #1613910

    Neeraj Dwivedi (5/9/2013)

    SYS.PROCESSES or SYSPROCESSES?

    Sorry, there is no sys.processes. The system table sysprocessess mappes to the following:

    sys.dm_exec_connections

    sys.dm_exec_sessions

    sys.dm_exec_requests