If you don't have any sort of auditing set up on your server, you won't be able to see who deleted data. You can set up Audit within SQL Server. There are also third party tools that do this. Finally you can look to setting up extended event[/url]s to monitor for delete statements against this one table. But, all that will have to be set up. Nothing monitors and audits SQL Server by default out of the box.