I am working on SQL Server 2008. I have created a trigger on a table which will send a notification mail if the records are updated. I have included what is getting updated in body of the mail. Along with that I also want to include who has updated the records. Some information like login name. Is it possible? And if yes, how can I do that? Please help.
How to include login information in an sql server mail?
111 views Asked by user2277333 At
2
There are 2 answers
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
Related Questions in SQL-SERVER-2008
- Why does the following script throw database still in use when selecting the master database first?
- Return Duplicate Rows
- SQL Data entry - finding sequence to enter info
- Why is this query in SSMS showing columns/tables as numbers?
- Query from multiple tables based on the table name?
- How to Let Python Connect to a SQL Server Database
- Need to fetch Minimum value for Each Id and make the BidSuccess column to 1
- Spring Boot Scheduled Annotation Job Issue
- Use different WHERE clause based on condition?
- Error when inserting special characters such as Ñ and accents á, é, í, ó, ú. using BULK OPENROWSET from python
- Delete all records except the max value of a group
- How to use SQL Server stored procedures in React js express server
- Loop through date in SQL Server and exclude the dates within a range of one week
- Find amount greater than the average amount
- Update trigger - both INSERTED and DELETE hold same value after update
Related Questions in SP-SEND-DBMAIL
- sp_send_dbmail fails with EXECUTE but succeeds with SELECT
- SQL Server Job alert
- Query not completely executed when used in DB job
- sp_send_dbmail resulting Excel attachment to include merged cells
- Change the server name in the HELO exchange in SQL Server Database Mail
- Column header with @query_no_truncate parameter
- SQL server DB mailbox can not send mail
- SVG element does not appear into body email
- HTML internal style not used when sent to email
- Calling HTTP API endpoint in Azure Managed SQL
- How to send json query as attachment using sp_send_dbmail
- Failed to execute msdb.dbo.sp_send_dbmail
- pyodbc Incorrect syntax near '.'
- Wrap select with union operator for dbmail in format HTML
- SQL 2019 Database Mail Setup to relay from an Office 365 Address
Related Questions in DBMAIL
- Send email on RazorSQL
- Failed to execute msdb.dbo.sp_send_dbmail
- How can I attach a file name containing a / with sp_send_mail?
- How do I diagnose and fix "Error formatting query, probably invalid parameters, incorrect syntax" error?
- Format msdb.dbo.sp_send_dbmail
- SSMS Database Mail not sending to multiple recipients anymore
- Why doesn't a SQL trigger have permissions to use e-mail?
- How to send an email on finding bad data in a table in sql server
- SQL Server Mail senging error using sp_send_dbmail on gmail server
- SQL Server: modifying how the email message is displayed
- How do I compile SQL email but not send?
- DB Mail is working with other carriers but not sprint
- SQL server stops sending db mails in sql server 2014
- Returning query to an HTML table alert email with TSQL dbmail
- DB Mail could not sent mail to the recipients because of the mail server failure in sql server 2012
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Are you familiar with the USER_NAME and SUSER_SNAME functions? Not sure how your trigger is configured, but in my triggers I use them to add entries to an audit table indicating who updated or inserted rows. So you should be able to add them to whatever SELECT statement is feeding your email.