How can I tell when a SQL Server stored procedure was last updated?

How can I tell when a stored procedure was last run?

Last Execution Date Time of a Stored Procedure

  1. USE DBName.
  2. GO.
  3. SELECT., PS.last_execution_time.
  4. FROM. sys.dm_exec_procedure_stats PS.
  5. INNER JOIN sys.objects O.
  6. ON O.[object_id] = PS.[object_id]

How can check stored procedure history modification in SQL Server?

You can use the SQL Server Profiler to access the log information. You can also find the user who created the stored procedure using the Schema Changes History in the SQL Server Management Studio. You can find the name of the user in the LoginName column of the log files.

How can I see who modified a stored procedure in SQL Server?

In SSMS, right click on Server Name, choose Reports / Standard Reports / Schema Changes History. The list is in time order with most recent at the top.

How do I view a stored procedure history in SQL Server?

To view the results you can use 2 methods:

  1. Right click on Server Audit object and click on “View Audit Log”:
  2. Query the audit files directly to limit the number of columns/rows or to filter by the stored procedure name:

How do I find the last executed procedure in SQL Server?

Fortunately there is an easy way to query this information. Procedural statistics are stored in the sys. dm_exec_procedure_stats Dynamic Management View (DMV). Querying this will return aggregate performance stats for cached stored procedures.

IT IS INTERESTING:  What does sum distinct do in SQL?

How do you check when a stored procedure was last called executed in Oracle?

SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE = ‘PROCEDURE’ AND OBJECT_NAME = ‘MY_PROC_NAME’; In an ideal world I was hoping to find a table showing me the last x executions of stored procedures with execution time and what triggered them.

How can I tell when a SQL Server table was modified?

If a user wants to find out when was the last table updated he can query dynamic management view (DMV) – sys. dm_db_index_usage_stats and easily figure out when was the table updated last.

Categories SQL