SQL Server Education (by the geeks, for the geeks)
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 …
Sysmail_help_profile_sp – Day 13 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_add_profile_sp – Day 12 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_help_configure_sp – Day 11 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_configure_sp – Day 10 – SQL Server System Stored Procedure Read MoreHi folks, today in SQL Server system stored procedure series you will learn about how to get information about allocated and unallocated space in database and database objects using stored procedure …
Sp_spaceused – Day 9 – SQL Server System Stored Procedure Read MoreHi friends, today in SQL Server system stored procedure series 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 …
Sp_dropmessage – Day 8 – SQL Server System Stored Procedure Read MoreHi friends, today in SQL Server system stored procedure series 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 …
Sp_addmessage – Day 7 – SQL Server System Stored Procedure Read MoreHi friends, today in SQL Server System Stored procedure series you will learn how to create user-defined datatype using stored procedure sp_addtype. Sp_addtype is used to provide an alias to datatype. …
sp_addtype – Day 6 – SQL Server System Stored Procedure Read MoreHi friends, today in SQL Server system stored procedure series we will learn how to get information about constraints defined on a table using stored procedure sp_helpconstraint. Sp_helpconstraint stored procedure lists all …
sp_helpconstraint – Day 5 – SQL Server System Stored Procedure Read MoreHi friends, today in SQL server system stored procedure series we will continue with another extended properties related stored procedure sp_dropextendedproperty. Sp_dropextendedproperty is used to drop an existing extended property. Syntax of …
sp_dropextendedproperty – Day 4 – SQL Server System Stored Procedure Read More