Menu
I'm preferably looking for a SQL query to accomplish this, but other options might be useful too.
268
Accessing the log file in SQL Server ProfilerOpen the desired log file with SQL Server Profiler. You can see the stored procedure name in the ObjectName column and the name of the user who modified the stored procedure name in the LoginName column.
Hi, Here's one way: SELECT owner , object_name , last_ddl_time FROM all_objects -- or dba_objects, if you have privileges WHERE object_type IN ('PROCEDURE') ORDER BY last_ddl_time ; You can't modify procedures; all you can do is CREATE or REPLACE them.
If you want to find, when a table was last modified like insert,update ,delete, then use the dictionary table dba_tab_modifications.
SELECT LAST_DDL_TIME, TIMESTAMP FROM USER_OBJECTS WHERE OBJECT_TYPE = 'PROCEDURE' AND OBJECT_NAME = 'MY_PROC'; LAST_DDL_TIME is the last time it was compiled. TIMESTAMP is the last time it was changed.
Procedures may need to be recompiled even if they have not changed when a dependency changes.
171
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
