Sql Server活动监视器中的这个进程是什么？
SQL Server 2005 活动监视器中有一个进程似乎一直在运行。 双击它会产生以下查询：
CREATE TABLE #tmpDBCCinputbuffer ([EVENT TYPE] NVARCHAR(512), [参数] INT、[事件信息] NVARCHAR(512)) INSERT INTO #tmpDBCCinputbuffer EXEC ('DBCC INPUTBUFFER(58)') 从#tmpDBCCinputbuffer 中选择[事件信息]
知道它是什么吗？ 危险吗？
There is a process that seems to be running all the time in SQL Server 2005 activity monitor. Double clicking on it produces 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? Is it dangerous?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
具有讽刺意味的是，它是您用来查看连接上运行的最后一个查询的查询，这就是您要查看所有连接的最后一个查询是什么的操作。 包括您用来查看所有这些连接的连接。
当你需要的时候头晕的表情符号在哪里？
Ironically, its the query you use to see the last query run on a connection, which is what you are doing to see what all the connections' last queries were. Including the connection you use to look at all those connections.
where's the dizzy emoticon when you need it?
http://msdn.microsoft.com/en-us/library/ms187730。 aspx
引自 SQL Server 开发中心
http://msdn.microsoft.com/en-us/library/ms187730.aspx
Quote from SQL Server Developer Center
我只想分享另一个答案，进一步解释 Neil N 的答案。
作者：Chris Howarth https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6bbe405b-b7d8-4f97-9150-cf03c59d4fe3/process-wont-die?forum=sqldatabaseengine
数字 58是它总是会返回的，因为它是它的进程 ID，并且是您运行的最后一个进程！
I just want to share another answer which further explains Neil N's answer.
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 it will always return because it's its Process ID and it's the last process you run!