StingyJack

sp_what

This is a replacement for SP_who and modification of sp_who2. It will always list only active, nonsystem processes, and will list the number of seconds a transaction has been running for. Some transactions do not report a last batch time, so I forced a large value to display so you can see any issue with […]

5 (1)

2006-10-02 (first published: )

2,006 reads

Blogs

Life Support 2008 – Audit Logons

By

Planning to upgrade/migrate requires a fair amount of prep work. Some of that prep...

All the signs were there, but we didn’t understand them: an essay on gatekeeping in IT

By

This is the first in a series of posts about gatekeeping in Information Technology...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

Convert smallint to Date

By PJ_SQL

Hello! I have column in SQL 2012 DB of datatype smallint. Could you please...

Managed Instance Error Creating Recurring Schedule - BUG???

By DBADave

When we try to create a SQL Server Agent job schedule that has a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers