Log in | Register

SQL Server System Stored Procedures Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education SQL Server System Stored Procedures Archives - SQL Server Blogs, Events, Webcasts, Videos, SQL Server learning & education

SQL Server System Stored Procedures

SQLServerGeeks Annual Summit 2016 IS HAPPENING IN BANGALORE. HAVE YOU REGISTERED?

Sysmail_help_principalprofile_sp – Day 19 – SQL Server System Stored Procedure

Hi friends, in this blog of SQL Server system 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 the instance […]

Sysmail_add_principalprofile_sp – Day 18 – SQL Server System Stored Procedure

Hi friends, in this blog of SQL Server system stored procedure series 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

Arguments

@principal_Id – ID of the database user or role in msdb database. A principal_id with 0 makes it […]

Sysmail_help_profileaccount_sp – Day 17 – SQL Server System Stored Procedure

Hi folks, in our previous blog of SQL Server system 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. When […]

Sysmail_add_profileaccount_sp – Day 16 – SQL Server System Stored Procedure

Hi friends, in last previous blogs of SQL Server system stored procedures 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 […]

Sysmail_help_account_sp – Day 15 – SQL Server System Stored Procedure

Hi friends, in previous blog of SQL Server system stored procedure we created database mail account. 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 […]

Sysmail_add_account_sp – Day 14 – SQL Server System Stored Procedure

Hi friends, today in SQL Server system stored procedure series we will continue with database mail 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:

Arguments

@account_name – Name of new database […]

Sysmail_help_profile_sp – Day 13 – SQL Server System Stored Procedure

Hi friends, today in SQL Server system stored procedure series 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 […]

Sysmail_add_profile_sp – Day 12 – SQL Server System Stored Procedure

Hi friends, today in SQL Server System stored procedure series we will continue with database mail stored procedure sysmail_add_profile_sp.

Sysmail_add_profile_Sp stored procedure is used to create database mail profile. A database mail profile can hold multiple database mail accounts. Database mail profile name must be unique for Microsoft SQL Server Database Engine. This stored procedure […]

Sysmail_help_configure_sp – Day 11 – SQL Server System Stored Procedure

Hi friends, today in SQL Server system stored procedure series we will continue with another database mail stored procedure sysmail_help_configure_sp.

Sysmail_help_configure_sp stored procedure is used to display current Database mail configuration settings. The stored procedure sysmail_help_configure_sp is stored in msdb database and owned by schema dbo. Three part name is required if it is used […]

Sysmail_configure_sp – Day 10 – SQL Server System Stored Procedure

Hi friends, from today we will discuss about database mail stored procedures. In next few days you will learn how to configure database mail, how to add mail accounts, how to add profile, and how to send mail.

Today, we will discuss about configuration setting for database mail using sql server system stored procedure sysmail_configure_sp.

Sysmail_configuration_sp […]

Newsletter_Footer