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

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

Stored Procedure

Drop user-defined message from sys.messages table using stored procedure sp_dropmessage

Hi friends, today you will learn about how to drop user-defined message from sys.messages table using stored procedure sp_dropmessage. Sp_dropmessage stored procedure is used to drop user-defined error message. It requires membership in sysadmin and serveradmin server roles. Syntax of sp_dropmessage  is as follows: Sp_dropmessage [@msgnum =] msgid, [@lang =] ‘language’ Arguments @msgnum is the… Continue reading Drop user-defined message from sys.messages table using stored procedure sp_dropmessage

Stored Procedure

Add user-defined message in sys.message table using stored procedure sp_addmessage

Hi friends, today you will learn about how to add user-defined message in sys.messages table using stored procedure sp_addmessage. Sp_addmessage stored procedure is used to add user-defined error message  which can be viewed using sys.messages table. It requires membership in sysadmin and serveradmin server roles. Syntax of sp_Addmessage is as follows: sp_addmessage [ @msgnum= ]… Continue reading Add user-defined message in sys.message table using stored procedure sp_addmessage

Stored Procedure

Create user-defined datatype using sp_addtype Stored procedure in SQL Server

Hi friends, today in SQL Server System Stored procedure you will learn how to create user-defined datatype using stored procedure sp_addtype. Sp_addtype is used to provide an alias to datatype. You can find the find the information of the newly created user-defined datatype in sys.types table for a specific database. To get enable user-defined datatype… Continue reading Create user-defined datatype using sp_addtype Stored procedure in SQL Server

Stored Procedure

sp_helpconstraint Stored Procedure in SQL Server

Hi friends, today in SQL Server system stored procedure you will learn how to get information about constraints defined on a table using stored procedure sp_helpconstraint. Sp_helpconstraint stored procedure lists all constraints defined on a table along with their user_defined or system-supplied name. It also lists all columns on which constraints are defined and expressions… Continue reading sp_helpconstraint Stored Procedure in SQL Server