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
Trackbacks & Pingbacks
doxycycline dose uti
doxycycline dose uti
ozempic costco reddit
ozempic costco reddit
fincar 5mg generic
fincar 5mg generic
compounded semaglutide dosage for weight loss
compounded semaglutide dosage for weight loss
tadalafil typical dosage
tadalafil typical dosage
cenforce 200 dosage
cenforce 200 dosage
vidalista 20 review
vidalista 20 review
lasix for dogs without vet prescription
lasix for dogs without vet prescription
fluconazole 100 mg
fluconazole 100 mg
vardenafil
vardenafil
antibiotics for pneumonia
antibiotics for pneumonia
diflucan pain medication
diflucan pain medication
Hinterlasse einen Kommentar
An der Diskussion beteiligen?Hinterlasse uns deinen Kommentar!