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

4 votes176 views1 answer
Add constraint fk
SQL
0 vote186 views1 answer
Update one column from another column in same table
SQL
0 vote194 views1 answer
Mysqli_connect using prepare statement
SQL
22 votes177 views3 answers
Join three tables sql
SQL
4 votes176 views3 answers
Order by value mysql
SQL
0 vote200 views1 answer
Warning: pdostatement::execute(): sqlstate[hy093]: invalid parameter number: number of bound variables does not match number of tokens
SQL
1 vote143 views1 answer
Enable mysql slow query log
SQL
1 vote198 views1 answer
Date in where on datetime column clause mysql
SQL
1 vote214 views1 answer
Mysql default port
SQL
0 vote260 views1 answer
Restart serial number for postgres
SQL