If you’re trying to send mail with SQL Server but it’s not being delivered, try checking the sysmail_faileditems view.
Category: SQL Server
Check Unsent Mail in SQL Server (T-SQL)
When sending emails from SQL Server, you can check for any unsent mail with the sysmail_unsentitems view.
SQL Server Error 109: There are more columns in the INSERT statement than values specified in the VALUES clause
This is a commonly encountered error in SQL Server when inserting data into a table. The full error goes like this:
Msg 109, Level 15, State 1, Line 1 There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
This happens when you specify more columns in the INSERT statement than the number of values that you’re trying to insert with the VALUES clause.
This will occur if you accidentally omit one or more values from the VALUES clause.
You’d get a similar (but technically different) error if you tried to do the opposite – specify fewer columns in the INSERT statement than you try to insert.
How EXCEPT Works in SQL Server
You can use the T-SQL EXCEPT operator in SQL Server to return distinct rows from the left input query that aren’t output by the right input query.
How INTERSECT Works in SQL Server
In SQL Server, you can use the T-SQL INTERSECT operator to return distinct rows that are output by both the left and right input queries.
Fix “profile name is not valid” When Sending Mail from SQL Server
If you try to send mail from SQL Server, but you get a “profile name is not valid” it’s probably because you haven’t specified a valid profile for the @profile_name argument.
How to Remove a Database Mail Account from a Profile in SQL Server (T-SQL)
In SQL Server, you can use the sysmail_delete_profileaccount_sp stored procedure to remove a Database Mail account from a profile.
You can remove the account from a specific profile, or you can remove it from all profiles. You can also remove all accounts from a given profile.
The way it works is, you provide two arguments; the account name or its ID, and the profile name or its ID. If you omit the argument for the profile, the account is removed from all profiles. If you omit the argument for the account, then all accounts are removed from the profile.
Continue readingDelete a Database Mail Profile in SQL Server (T-SQL)
In SQL Server, you can use the sysmail_delete_profile_sp stored procedure to delete an existing Database Mail profile.
You can delete a profile by providing either its name or its ID (but you must provide either one or the other).
Continue readingDelete a Database Mail Account in SQL Server (T-SQL)
In SQL Server, you can use the sysmail_delete_account_sp stored procedure to delete an existing Database Mail account.
You can delete an account by providing either its name or its ID (but you must provide either one or the other).
Continue readingUpdate a Database Mail Account in SQL Server (T-SQL)
In SQL Server, you can use the sysmail_update_account_sp stored procedure in the msdb database to update your existing Database Mail accounts with T-SQL.