How to use the new function fn_get_sql()

By Bill Graziano on 16 October 2003 | Tags: Administration

Narayana Vyas Kondreddi submitted "This article shows you how to use the new function fn_get_sql() and the 3 new columns of master.dbo.sysprocesses. These changes were introduced in SQL Server 2000 SP3/SP3A. In this article, you will find a general purpose stored procedure called ShowCodeLine. It makes use of these new features, to inspect a given spid, and display the currently executing line/query."

Link: How to use the new function fn_get_sql()

Related Articles

Advanced SQL Server 2008 Extended Events with Examples (25 May 2009)

Introduction to SQL Server 2008 Extended Events (19 May 2009)

Monitoring SQL Server Agent with Powershell (24 March 2009)

SQL Server Version (29 January 2009)

Scheduling Jobs in SQL Server Express - Part 2 (1 December 2008)

Alerts for when Login Failures Strike (14 July 2008)

Using xp_ReadErrorLog in SQL Server 2005 (12 May 2008)

Moving the tempdb database (5 November 2007)

Other Recent Forum Posts

Improving update statistics process for 6 big tables (4d)

Peer to Peer Replication is not working between 2 different machines (4d)

SQL HELP in SSMS: The query references an object that is not supported in distributed processing mode (38d)

Subscription sends report with data to one user but empty report to other users (40d)

Pivot Tables in SQL (47d)

Can't restore backup; SSMS says my user account directory is empty (48d)

REPL55012 error (74d)

SQL 2022 SSIS does not write data in Excel (82d)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site