Stored Procedure

Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10

Hi friends, in this blog of SQL Server  database mail stored procedure we will continue with another database mail stored procedure sysmail_help_principalprofile_sp. Sysmail_help_principalprofile_sp stored procedure list the information about associations between database mail profile and database principals. When sysmail_help_principalprofile_sp stored procedure is executed without any parameters then it returned lists all of the associations in… Continue reading Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10

Stored Procedure

Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9

Hi friends, in this blog of SQL Server Database mail stored procedure we will continue with another database mail procedure sysmail_add_principalprofile_sp. Sysmail_add_principalprofile_sp stored procedure grants permission to a database user or role to use a database mail profile. Syntax sysmail_add_principalprofile_sp  { [ @principal_id = ] principal_id | [ @principal_name = ] ‘principal_name’ } , { [… Continue reading Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9

Stored Procedure

Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8

Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database mail profile. In this blog we will learn how to get information about the accounts associated with database mail profiles. Sysmail_help_profileaccount_sp stored procedure lists the database mail accounts associated with one or more database profile.… Continue reading Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8

Stored Procedure

Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7

Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will learn how to add database mail account to database mail profile using stored procedure sysmail_add_profileaccount_sp. Sysmail_add_profileaccount_sp stored procedure is used to add database mail account to a database mail profile. Both the mail account and… Continue reading Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7

Development · Stored Procedure

Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6

Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp. Sysmail_help_account_sp stored procedure displays information about database mail account. When the procedure executes without passing any parameters then it will display all database accounts information. Syntax of sysmail_help_account_Sp is as follows: sysmail_help_account_sp [ [ @account_id… Continue reading Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6

Development · Stored Procedure

Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5

Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account using stored procedure sysmail_add_account_sp. Sysmail_add_account_sp stored procedure is used to create database mail account which contains information about SMTP account. Syntax of sysmail_add_account_sp is as: sysmail_add_account_sp  [ @account_name = ] ‘account_name’,     [ @email_address =… Continue reading Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5

Development · Stored Procedure

Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4

Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored procedure provides information about the database mail profiles. This stored procedure is stored in msdb database and owned by dbo schema. The procedure must be executed with a three part name if current database is… Continue reading Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4