Pages

Saturday, September 7, 2013

SQL SERVER – Get Last Running Query Based on SPID | Journey to SQL Authority with Pinal Dave

We often need to find the last running query or based on SPID need to know which query was executed. SPID is returns sessions ID of the current user process. The acronym SPID comes from the name of its earlier version, Server Process ID. To know which sessions are running currently, run the following command:… Continue Reading...

Source: SQL SERVER – Get Last Running Query Based on SPID | Journey to SQL Authority with Pinal Dave