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

3 votes174 views4 answers
Stop MySQL
SQL
6 votes169 views2 answers
Join vs union
SQL
0 vote180 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote168 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote176 views2 answers
Test sqlsrv connection
SQL
10 votes170 views4 answers
Sql pagination
SQL
1 vote165 views1 answer
Check constraint to check if date greater than todays date
SQL
1 vote166 views1 answer
Size of all tables in a schema oracle
SQL
2 votes181 views1 answer
Mysql change data type of column
SQL
0 vote162 views1 answer
Microsoft word insert sql code
SQL