Archive for June 25, 2015

SQL Error – SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’

June 25, 2015 1 comment

Error Message:

Executed as user: DOMAIN\Account. SQL Server blocked access to procedure ‘dbo.sp_send_dbmail’ of component ‘Database Mail XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Database Mail XPs’ by using sp_configure. For more information about enabling ‘Database Mail XPs’, search for ‘Database Mail XPs’ in SQL Server Books Online. [SQLSTATE 42000] (Error 50000). The step failed.

–> Resolution:

-- show advanced options
EXEC sp_configure 'show advanced options', 1

-- enable Database Mail XPs
EXEC sp_configure 'Database Mail XPs', 1

-- check if it has been changed
EXEC sp_configure 'Database Mail XPs'

-- hide advanced options
EXEC sp_configure 'show advanced options', 0

Categories: SQL Errors Tags:

new CTP 2.1 update for SQL Server 2016 available for download

June 25, 2015 Leave a comment

Today Microsoft announced an update of the recently released Community Technology Preview (CTP) 2 version of SQL Server 2016, the CTP 2.1.

[Register and Download the CTP 2.1 Evaluation version (180 days) here]


Direct download link:

As per the Microsoft [SQL Server Blog], now people do not have to wait for several months for the release of next CTP versions. Now customers can experience the Rapid Preview models and bits for their dev & test purpose.

–> This rapid release includes some improvements and fixes to the new features added in SQL Server 2016 release, and as follows:

1. Stretch DatabaseDemo video

2. Query Store

3. Temporal Data, added support for computed columns and Period columns with HIDDEN flag – Demo video.

4. Columnstore Index, improved seek/scan performance – Demo video.

Check the [SQL Server blog] for all these updates in detail.


Check & Like my FB Page