kill processes from one user

DECLARE @sql NVARCHAR(MAX) = N”;

 

SELECT @sql += N’KILL ‘ + CONVERT(VARCHAR(11), session_id) + N’;’

FROM sys.dm_exec_sessions

  WHERE 

   login_name = N’hapecservice’

  AND database_id = 27

  –AND last_request_start_time < DATEADD(HOUR, -5, SYSDATETIME());

 

EXEC sys.sp_executesql @sql;

 

vorher exec sp_who2

19 Kommentare

Trackbacks & Pingbacks

  1. tadalafil interaction overview

    tadalafil interaction overview

  2. Absorption Rate Reference

    Absorption Rate Reference

  3. Understanding Sildenafil Duration

    Understanding Sildenafil Duration

  4. avanafil food interaction evaluation

    avanafil food interaction evaluation

  5. terbinafine product overview

    terbinafine product overview

  6. bupropion hcl er (xl) (generic)

    bupropion hcl er (xl) (generic)

  7. flagyl in third trimester

    flagyl in third trimester

  8. doxycycline dose uti

    doxycycline dose uti

  9. ozempic costco reddit

    ozempic costco reddit

  10. fincar 5mg generic

    fincar 5mg generic

  11. compounded semaglutide dosage for weight loss

    compounded semaglutide dosage for weight loss

  12. tadalafil typical dosage

    tadalafil typical dosage

  13. cenforce 200 dosage

    cenforce 200 dosage

  14. vidalista 20 review

    vidalista 20 review

  15. lasix for dogs without vet prescription

    lasix for dogs without vet prescription

  16. fluconazole 100 mg

    fluconazole 100 mg

  17. antibiotics for pneumonia

    antibiotics for pneumonia

  18. diflucan pain medication

    diflucan pain medication

Hinterlasse einen Kommentar

An der Diskussion beteiligen?
Hinterlasse uns deinen Kommentar!

Schreibe einen Kommentar