Sql to search who modified

SELECT DISTINCT
              StartTime
          ,hostname
       ,LoginName
          ,ObjectName
         
          ,CASE
                     WHEN EventClass = 46 THEN 'Created'
                     WHEN EventClass = 47 THEN 'Dropped'
                     WHEN EventClass = 164 THEN 'Altered'
              END as EventClass
       --,f.*
FROM   sys.traces t
       CROSS APPLY fn_trace_gettable(REVERSE(SUBSTRING(REVERSE(t.path),
                                                       CHARINDEX('\', REVERSE(t.path)),
                                                       260)
                                             ) + N'log.trc', DEFAULT) f
WHERE  t.is_default = 1
       AND ObjectName like 'stored_proc_name'
       AND EventClass IN (46, /*Object:Created*/
                          47, /*Object:Dropped*/
                          164 /*Object:Altered*/ )
ORDER BY StartTime DESC

Similar codes

0 vote143 views1 answer
Sql count null values in all columns
SQL
0 vote144 views1 answer
Sql pad left 0
SQL
8 votes157 views1 answer
Oracle search stored procedures for text
SQL
0 vote150 views1 answer
SQL Query to delete all the tables in a database
SQL
1 vote138 views1 answer
How to get the date diff on once field in sql server
SQL
-2 votes142 views1 answer
How to open database
SQL
0 vote139 views4 answers
Mysql desactivar trigger
SQL
0 vote170 views1 answer
Sql developer sql worksheet not showing
SQL
0 vote148 views1 answer
Implicit inner join table alias with id values
SQL
0 vote147 views1 answer
Enable Rabbitmq management plugin
SQL