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

15 Kommentare

Trackbacks & Pingbacks

  1. terbinafine product overview

    terbinafine product overview

  2. bupropion hcl er (xl) (generic)

    bupropion hcl er (xl) (generic)

  3. flagyl in third trimester

    flagyl in third trimester

  4. doxycycline dose uti

    doxycycline dose uti

  5. ozempic costco reddit

    ozempic costco reddit

  6. fincar 5mg generic

    fincar 5mg generic

  7. compounded semaglutide dosage for weight loss

    compounded semaglutide dosage for weight loss

  8. tadalafil typical dosage

    tadalafil typical dosage

  9. cenforce 200 dosage

    cenforce 200 dosage

  10. vidalista 20 review

    vidalista 20 review

  11. lasix for dogs without vet prescription

    lasix for dogs without vet prescription

  12. fluconazole 100 mg

    fluconazole 100 mg

  13. antibiotics for pneumonia

    antibiotics for pneumonia

  14. diflucan pain medication

    diflucan pain medication

Hinterlasse einen Kommentar

An der Diskussion beteiligen?
Hinterlasse uns deinen Kommentar!

Schreibe einen Kommentar