I cam across a situation where as a SQL DBA, i needed to know what a process is doing. I could get the SQL fired using DBCC inputbuffe. but i could not get the execution plan for the same. HOw do i get execution plan of a process ????? I know that it can be done from SQL Query Analyzer but it works for current process only. i want it for other users processes.