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

2 votes103 views1 answer
How to add where command in update comand with joins
SQL
0 vote112 views1 answer
Postgresql regular expression special characters
SQL
0 vote121 views1 answer
Str_to_date sql server
SQL
0 vote117 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
0 vote115 views1 answer
Drop CHECK constraint sql
SQL
0 vote112 views1 answer
Inner join distinct
SQL
15 votes103 views2 answers
Install mysql 8 ubuntu 18.04
SQL
4 votes58 views1 answer
Generate class from sql table c#
SQL
2 votes155 views2 answers
Mysql date range
SQL
0 vote112 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL