SQL Server Education (by the geeks, for the geeks)
Hi friends, today we will discuss about new performance monitoring system Extended Events which gets introduced in version SQL Server 2012.In previous versions we were using SQL Trace for capturing events …
Extended Events in SQL Server 2012 Read MoreHi 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 …
Sysmail_help_principalprofile_sp – Day 19 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_add_principalprofile_sp – Day 18 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_help_profileaccount_sp – Day 17 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_add_profileaccount_sp – Day 16 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_help_account_sp – Day 15 – SQL Server System Stored Procedure Read MoreHi 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 …
Sysmail_add_account_sp – Day 14 – SQL Server System Stored Procedure Read MoreHi 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 More