• 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,277 reads

Blogs

Using ThinOptics to Read Data

By

As I’ve aged, I find myself struggling to read many things in my life....

PostgreSQL Events – A Newbies Perspective: #PGSQLPhriday 014

By

For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...

Set-Based vs Row-Based Database Code

By

In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...

Read the latest Blogs

Forums

Need help on query - DATEDIFF

By Adelia

Hello, I want to have value Month ago Year ago So far, I've this...

The Fake Speakers

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Fake Speakers

Stairway to Database DevOps Level 3: Managing Code as a Team in Git

By Erin Dempster

Comments posted to this topic are about the item Stairway to Database DevOps Level...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers