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 vote206 views1 answer
Mysql check datetime equals date
SQL
0 vote271 views1 answer
Opensuse start MySQL
SQL
0 vote165 views1 answer
Sql runnignsum
SQL
0 vote201 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
0 vote202 views1 answer
Get the next column of a table in mysql
SQL
2 votes194 views1 answer
How to find constraints on a table in oracle
SQL
0 vote191 views1 answer
Equi joins in oracle
SQL
9 votes256 views3 answers
Postgres make sql dump
SQL
6 votes189 views2 answers
Mysql concatenate two columns into one
SQL
3 votes185 views1 answer
Start mysql server linux terminal
SQL