sp_help spid???

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

rocky SSCrazy Points: 2120 More actions · Answer 1

SSCrazy

Points: 2120

June 1, 2006 at 12:01 pm

I got it....

DBCC INPUTBUFFER (spid)

stax68 SSChampion Points: 11711 More actions · Answer 2

DBCC INPUTBUFFER( <spid> ) tells you the last command issued.

Tim Wilkinson

"If it doesn't work in practice, you're using the wrong theory"
- Immanuel Kant

Ally MacKenzie Right there with Babe Points: 799 More actions · Answer 3

With sql sp3 you have another option:

DECLARE @Handle binary(20)

SELECT @Handle = sql_handle FROM sysprocesses WHERE spid = 52

SELECT * FROM ::fn_get_sql(@Handle)

See BOL for details.

Maverick100877 SSCertifiable Points: 5240 More actions · Answer 4

Hi

cannot get anything in BOL. COuld you please explain a bit..