Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
find who deleted records from a table in SQL Server
#1
Unleash the potential of the SysTools SQL Log Analyzer Tool on your PC. With this advanced tool, you can easily track down the culprits behind deleted records from a SQL Server table (MDF/NDF) and recover lost database objects like triggers, tables, stored procedures, functions, and more.
We are pretty much sure that SQL users can easily get the perfect solution after reading this


Here are the steps to follow:

1. Download, install, and launch the software application on your computer.
2. Click the "open" button to add the .ldf/.mdf file to the software.
3. You'll be prompted to choose between two options for adding a file: Online DB Option and Offline DB Option.
4. After selecting the SQL database for monitoring user activities, click OK.
5. The scan process will start, displaying all transactions (Insert, Update, & Delete) performed on the SQL database tables.
6. Once the scan of SQL database transactions is complete, the preview panel will showcase the transactional activity.
7. Users can view the Login Name column, identifying the user involved in each specific transaction on the database table.
8. Finally, the software offers an export option to save transactions directly to the SQL Server Database in CSV format or as a SQL Server Compatible Script.
Reply




Users browsing this thread: 1 Guest(s)

About Ziuma

ziuma - forum diskusi dan komunitas online. disini kamu bisa berdiskusi, berbagi informasi dan membentuk komunitas secara online. Bisa juga berdiskusi dengan sesama webmaster/blogger. forum ini berbasis mybb

              Quick Links

              User Links

             powered by