Shawn
Reputation: 2366
.NET SQL connection with SQL Server account and user identity
I have an ASP.NET app which connects to SQL Server using a SQL Server account. For auditing purposes, we use temporal tables which requires us to manually pass in the users doing the updates (AD accounts).
Is there any way to pass the users identity through to the SQL connection so we can setup triggers and avoid having to manually update the user with every update?
Upvotes: 0
Views: 42
Answers (0)
Related Questions
- How to concatenate text from multiple rows into a single text string in SQL Server
- How to add a column with a default value to an existing table in SQL Server?
- What is the best way to auto-generate INSERT statements for a SQL Server table?
- Check if table exists in SQL Server
- Reset identity seed after deleting records in SQL Server
- How do I UPDATE from a SELECT in SQL Server?
- How to check if a column exists in a SQL Server table
- How can I do an UPDATE statement with JOIN in SQL Server?
- LEFT JOIN vs. LEFT OUTER JOIN in SQL Server
- How can I delete using INNER JOIN with SQL Server?