SqlServerKudos

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

faq »

1
kudos

Kudos

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

published 635 days, 4 hours, 3 minutes ago posted by

pinaldave 643 days, 12 hours, 52 minutes ago

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

In recent SQL Training I was asked, how can one figure out what was the last SQL Statement executed in sessions. The query for this is very simple. It uses two DMVs and created following quick script for the same. SELECT session_id, TEXT

FROM sys.dmexecconnections CROSS APPLY sys.dmexecsqltext(mostrecentsqlhandle) AS ST While working with DMVs if you ever find any DMV has column with name sqlhandle you can right away join that DMV with another DMV sys.dmexecsqltext and can get the tex...

category: Community | clicked: 0 | | source: blog.sqlauthority.com | show counter code

tags: pinaldave, SQL, SQLAuthority, SQLServer

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

update reset

SqlServerKudos

Welcome!

SQL SERVER – Get Latest SQL Query for Sessions – DMV « Journey to SQL Authority with Pinal Dave

No comments yet, be the first one to post comment.

Open ID Login

Standard Login

Forgot Password?

Sign up