How to find all processes running by specific login in SQL Server

preview_player
Показать описание
In this video you will learn the answer of SQL Server DBA Question "f you need to find all the processes running by specific login, How would you do that in SQL Server?"

Complete list of SQL Server DBA Interview Questions by Tech Brothers
Рекомендации по теме
Комментарии
Автор

Good demo. Here is another way someone might find useful.

select * from master.dbo.sysprocesses
where loginame = 'enteruser'

ericx