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,140 reads

Blogs

Getting Started with SQL Prompt 10

By

This week we released SQL Prompt 10, which is an exciting milestone for us....

Power Platform Quick Tips – Episode 01: Fixing Power BI Column Sorting

By

Check out this new series that I’ve started on Power Platform Quick Tips. This...

The curious case of CHAR(0)

By

Over the years I’ve seen quite a few strange things with SQL Server. This...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Learn from the Troubles of Others

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Learn from the Troubles of...

Help with determining formulas/processes for solving a problem?

By tacy.highland

Hello all, Looking for all the smart people out there who can hear a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers