Get Latest SQL Query for Sessions

Posted on By David Kittell 
SELECT session_id
	,TEXT
FROM sys.dm_exec_connections
CROSS APPLY sys.dm_exec_sql_text(most_recent_sql_handle) AS ST

Reference: http://blog.sqlauthority.com/2010/05/05/sql-server-get-latest-sql-query-for-sessions-dmv/

Originally Posted on April 29, 2013
Last Updated on October 26, 2015
All information on this site is shared with the intention to help. Before any source code or program is ran on a production (non-development) system it is suggested you test it and fully understand what it is doing not just what it appears it is doing. I accept no responsibility for any damage you may do with this code.
Code MSSQL - Audit

Related Posts

Batch File Replace Text In Text File

Posted on

del /q FileList.txt del /q CleanFileList.txt dir *.* /O:N /b /s /d /A:-D > filelist.txt ssr "C:TempFolder"= "" filelist.txt > filelist_new.txt ssr "filelist.txt"= "" filelist_new.txt > FileList.txt del Filelist_new.txt ssr "ListFiles.bat"= "" FileList.txt > CleanFileList.txt del FileList.txt Originally Posted on August 4, 2014Last Updated on October 26, 2015 All information…

Read More

PowerShell – Set DHCP DNS or Set Static DNS

Posted on

param( [string]$1, [string]$2, [string]$3 ) function Set-DNS([string]$EnableDHCP,[string]$dns1, [string]$dns2){ $saNetAdapters = Get-NetIPInterface | Where-Object {$_.ConnectionState -eq "Connected"} foreach ($sNetAdapter in $saNetAdapters.ifIndex) { if ($EnableDHCP -eq "eDHCP") { Set-DnsClientServerAddress -InterfaceIndex $sNetAdapter -ResetServerAddresses } else { Set-DnsClientServerAddress -InterfaceIndex $sNetAdapter -ServerAddresses ($dns1, $dns2) } } Clear-DnsClientCache } function Get-NetworkInformation(){ $computer = $env:computername try {…

Read More

Mac OS X – Terminal – FFMPEG – Convert Music Files FLAC to MP3 or MP4 to MP3

Posted on

Prerequisite: Homebrew Essentially you can convert just about anything but this script is specific to FLAC to MP3 <br> brew install ffmpeg –with-vpx –with-vorbis –with-libvorbis –with-vpx –with-vorbis –with-theora –with-libogg –with-libvorbis –with-gpl –with-version3 –with-nonfree –with-postproc –with-libaacplus –with-libass –with-libcelt –with-libfaac –with-libfdk-aac –with-libfreetype –with-libmp3lame –with-libopencore-amrnb –with-libopencore-amrwb –with-libopenjpeg –with-openssl –with-libopus –with-libschroedinger –with-libspeex –with-libtheora –with-libvo-aacenc…

Read More