• Interests: Fantasy, Science Fiction, Horses, Music

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 […]

2006-10-19 (first published: )

2,148 reads

Blogs

Daily Coping 21 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

It’s 2021, so why are you reading this?

By

If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....

Daily Coping 20 Jan 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

A Beginning Project

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Beginning Project

Amend a Commit

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Amend a Commit

Save results from Stored procedure to a CSV file.

By lee.hopkins

I have a SqlAgentJob calling a stored proc. that loops through a list of...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Amend a Commit

See possible answers