Script removed as this is a plagiarism violation.
-- Removed by editor. 
Learn about new functions in SQL Server 2016 and 2017 to have more readable and compact code including STRING_AGG, TRIM, TRANSLATE and DROP... IF EXISTS.
2018-12-06
3,690 reads
Someone has dropped a table from your database and you want to track who did it. Or someone has deleted some data from a table, but no one will say who did. In this tip, we will look at how you can use the transaction log to track down some of this information.
2013-12-12
6,938 reads
2009-09-24 (first published: 2009-09-15)
691 reads
2012-09-04 (first published: 2008-04-24)
1,150 reads