I'm trying to start a script in SQL Server 2014, but it can't find the object in question.

This is the query I am trying to initiate:

SELECT * FROM sys.dm_exec_input_buffer(@@SPID, NULL);

Error message:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.dm_exec_input_buffer'.

CodePudding user response：

You need to be on at least Service Pack 2. If you're on an earlier service pack, it's time to patch.

• Here's a link to Service Pack 3
• Here's a link to the most recent update for SP3

Please apply both, in that order.