204k views
0 votes
How to check who inserted record in sql server

User Canis
by
8.3k points

1 Answer

3 votes

Final answer:

To check who inserted a record in SQL Server, you can use the Audit feature or create a trigger.

Step-by-step explanation:

To check who inserted a record in SQL Server, you can utilize the Audit feature or create a trigger. The Audit feature allows you to track data modifications and capture relevant information such as who made the change and when. Triggers, on the other hand, are database objects that automatically execute code when a specific table is modified. By creating an insert trigger, you can capture the user information and record it in a separate table.

User Steve Ellinger
by
7.9k points