Breaking News: Grepper is joining You.com. Read the official announcement!

Trace which machine is calling a stored proc

Fortune Mbulazi answered on June 20, 2023 Popularity 1/10 Helpfulness 1/10

answer Trace which machine is calling a stored proc

Trace which machine is calling a stored proc

Comment

DECLARE @TargetProcedureName NVARCHAR(128) = 'YourStoredProcedureName';

SELECT
    L.event_time AS [Execution Time],
    L.client_host_name AS [Client Host Name],
    L.client_net_address AS [Client IP Address],
    L.server_principal_name AS [Server Principal Name],
    L.database_name AS [Database Name],
    L.object_name AS [Object Name],
    L.statement AS [SQL Statement]
FROM
    sys.fn_trace_gettable('Path\to\Your\SQLServer\Log.trc', default) AS T
INNER JOIN
    sys.trace_events AS E ON T.EventClass = E.trace_event_id
LEFT JOIN
    sys.trace_subclass_values AS V ON T.EventClass = V.trace_event_id AND T.EventSubClass = V.subclass_value
WHERE
    E.name = 'RPC:Completed'
    AND V.subclass_name = 'RPC:Completed'
    AND T.ObjectName = @TargetProcedureName;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: chat.openai.com

Tags: proc sql trace

Link to this answer
Share Copy Link

Contributed on Jun 20 2023

Fortune Mbulazi

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Trace which machine is calling a stored proc

Contents

More Related Answers

Trace which machine is calling a stored proc

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.