获取运行中的SQL语句的详细信息

    SELECT[Spid]=[Database]=DB_NAME(sp.dbid),
    
     [User]=[Status]= er.status, 
     [Wait]= wait_type, 
     [Individual Query]=SUBSTRINGtext/2CASEWHEN=-1THENLENCONVERTNVARCHARMAXtext)) 
                      *2ELSEEND-/2),
                       [Parent Query]=text, 
                       Program = program_name, Hostname, 
                       nt_domain, start_time
    FROM    
     sys.dm_exec_requests er INNERJOINON= sp.spid 
     CROSSAS qt
    WHERE>50/* Ignore system spids.*/ANDNOTIN@@SPID