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 […]

By |June 15th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , , |Comments Off on Sysmail_help_principalprofile_sp – Day 19 – SQL Server System Stored Procedure

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 […]

By |June 13th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , , |Comments Off on Sysmail_add_principalprofile_sp – Day 18 – SQL Server System Stored Procedure

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 […]

By |June 8th, 2015|Categories: SQL Server System Stored Procedures|Tags: , , , , |Comments Off on Sysmail_help_profileaccount_sp – Day 17 – SQL Server System Stored Procedure

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 […]

By |June 4th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , |Comments Off on Sysmail_add_profileaccount_sp – Day 16 – SQL Server System Stored Procedure

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 […]

By |May 30th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , |Comments Off on Sysmail_help_account_sp – Day 15 – SQL Server System Stored Procedure

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 […]

By |May 28th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , |Comments Off on Sysmail_add_account_sp – Day 14 – SQL Server System Stored Procedure

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 […]

By |May 26th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , |Comments Off on Sysmail_help_profile_sp – Day 13 – SQL Server System Stored Procedure

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 […]

By |May 24th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , , |Comments Off on Sysmail_add_profile_sp – Day 12 – SQL Server System 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 […]

By |May 21st, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , , |Comments Off on Sysmail_help_configure_sp – Day 11 – SQL Server System Stored Procedure

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 […]

By |May 19th, 2015|Categories: SQL Server, SQL Server System Stored Procedures|Tags: , , |Comments Off on Sysmail_configure_sp – Day 10 – SQL Server System Stored Procedure
Newsletter_Footer