Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10
Hi friends, in this blog of SQL Server database mail stored procedure we will continue with another database mail stored...
2015-06-15
407 reads
Kapil Singh
Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9
Hi friends, in this blog of SQL Server Database mail stored procedure we will continue with another database mail procedure sysmail_add_principalprofile_sp....
2015-06-13
483 reads
Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8
Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database...
2015-06-08
415 reads
Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7
Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will...
2015-06-04
490 reads
What is User Defined function in SQL Server?
User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be...
2015-06-01
364 reads
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....
2015-05-30
869 reads
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...
2015-05-28
965 reads
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...
2015-05-26
333 reads
Find blocking using sp_who in SQL Server
Hi friends, in this blog I will tell you how can we find blocking using sp_who system stored procedure. Also,...
2015-04-22
288 reads
How CONCAT_NULL_YIELDS_NULL behave with computed columns In Sql Server
Hi friends, in this blog I am going to tell you about effect of CONCAT_NULL_YIELDS_NULL for computed columns while creating...
2015-04-18
227 reads
Blogs
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers