What is this process on the Sql server activity monitor?

Question

There is a process that seems to be running all the time in the SQL Server 2005 activity monitor. Double-clicking on it brings up the following query:

CREATE TABLE #tmpDBCCinputbuffer ([EVENT TYPE] NVARCHAR(512), [PARAMETERS] INT, [EVENT Info] NVARCHAR(512)) INSERT INTO #tmpDBCCinputbuffer EXEC ('DBCC INPUTBUFFER(58)') SELECT [EVENT Info] FROM #tmpDBCCinputbuffer

Any idea what it is? This is dangerous?

Answer 1

Ironically, its request, which you use to view the last request, is launched in the connection, and this is what you do to find out what all the latest connection requests were. Including the connection that you use to view all of these connections.

where is the dizzying smiley when you need it?

Answer 2

http://msdn.microsoft.com/en-us/library/ms187730.aspx

Quote from SQL Server Developer Center

"DBCC INPUTBUFFER permissions by default to fixed administrator members are only the server role, who can see any COI. Other users can see any SPID they own. Permissions are not transfers." ( http://msdn.microsoft.com/en-us/library/aa258826(SQL.80).aspx )

Answer 3

I just want to share another answer that further explains Neil N.'s answer

The DBCC INPUTBUFFER (spid) command will return the text of the last batch executed against the specified SPID. When you double-click on a line in Activity Monitor (or right-click and select "Details"), under the covers SQL Server runs the command that you specified in your message above (replacing the SPID of the selected line - 61 in your example) to return the latest batch released against the compound. In your example, the actual party is CREATE TABLE, etc. Package that was released by Activity Monitor to return the most recent batch!

by Chris Howarth https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6bbe405b-b7d8-4f97-9150-cf03c59d4fe3/process-wont-die?forum=sqldatabaseengine

The number 58 is what he will always return, because this is his process identifier, and this is the last process that you start!