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

Development · Stored Procedure

Sysmail_add_profile_sp – SQL Server Database Mail Stored Procedure – Part 3

Hi friends, today 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 is stored in msdb database and owned… Continue reading Sysmail_add_profile_sp – SQL Server Database Mail Stored Procedure – Part 3

Development · Stored Procedure

Sysmail_help_configure_sp – SQL Server Database Mail Stored Procedure – Part 2

Hi friends, today 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 in database other than msdb. Syntax: sysmail_help_configure_sp … Continue reading Sysmail_help_configure_sp – SQL Server Database Mail Stored Procedure – Part 2

Uncategorized

Sysmail_configure_sp – SQL Server Database Mail Stored Procedure – Part 1

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 stored procedure sysmail_configure_sp. Sysmail_configuration_sp stored procedure… Continue reading Sysmail_configure_sp – SQL Server Database Mail Stored Procedure – Part 1

Stored Procedure

Sp_spaceused stored procedure in SQL Server

Hi folks, today you will learn about how to get information about allocated and unallocated space in database and database objects using stored procedure sp_spaceused. Sp_spaceused stored procedure displays the disk space used by database, disk space used by table, indexed view, number of rows in a table. If objectname is not specified then it… Continue reading Sp_spaceused stored procedure in SQL Server