• Interests: Fantasy, Science Fiction, Horses, Music

Technical Article

Script to output dbcc inputbuffer adding spid info

The following script will allow the user to get information from all spids that have a program name associated with them. That is event info out of dbcc inputbuffer. Additional columns may be added and used in the table through simple modifications of the script. I just found it useful for troubleshooting and setting up […]

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-10-19 (first published: )

2,381 reads

Blogs

dataMinds Connect 2026 – Slides & Scripts

By

You can find the slides and SQL scripts for my session “Spice up your...

How to Clear the SSMS Cache (SSMS 21 and Later)

By

How to Clear the SSMS Cache (SSMS 21 and Later) Updated...

The flight recorder: Replaying what an AI agent did on my SQL Server

By

“What exactly did it do on my server?” is the first question a DBA...

Read the latest Blogs

Forums

Alamat BCA KCP Thamrin Nine Telp:0821°7555°651

By layanan_Bca88

Telp/Wa 628217555651 Thamrin Nine Podium Area - UG Unit A, Jl. MH Thamrin No.10,...

Alamat BCA KCP Samanhudi Telp:08218200203

By R4nt4u

Telp/Wa 628218200203 Jl. Samanhudi No.57 B, RT.5/RW.3, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...

Alamat BCA KCP AM Sangaji Telp:08218200233

By m4rt1n4

Telp/Wa 628218200233 Jl. A.M Sangaji No.020 A, RT.3/RW.04, Petojo Utara, Kecamatan Gambir, Kota Jakarta...

Visit the forum

Question of the Day

Checking the Error Log III

If I want to run sp_readerrorlog on SQL Server 2025, what permissions do I need?

See possible answers