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 vote209 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
4 votes250 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
0 vote200 views1 answer
How get data from database if id not found then search another column
SQL
2 votes223 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote254 views1 answer
Pl sql round
SQL
0 vote267 views1 answer
Delete from IN subquery
SQL
1 vote221 views1 answer
Oracle select row max date
SQL
0 vote188 views1 answer
Forcefully delete a row in mysql which has references
SQL
0 vote287 views1 answer
Mysql select random rows large table
SQL
5 votes231 views2 answers
Postgresql insert select
SQL