Fantastic compilation. Thanks Taranov!

Sounds like SMTP issue. Have you checked with your messaging team for errors in their logs?

Hi Carlis,
Here are my 2 cents...Have you checked for any missing/corrupt MSI in your Installer folder?
Your log shows below:
"Error 1723. There is a problem with this Windows...

You can use something like this.....

SELECT 'BuildClrVersion' ColumnName, SERVERPROPERTY('BuildClrVersion') ColumnValue

UNION ALL

SELECT 'Collation', SERVERPROPERTY('Collation')

UNION ALL

SELECT 'CollationID', SERVERPROPERTY('CollationID')

UNION ALL

SELECT 'ComparisonStyle', SERVERPROPERTY('ComparisonStyle')

UNION ALL

SELECT 'ComputerNamePhysicalNetBIOS', SERVERPROPERTY('ComputerNamePhysicalNetBIOS')

UNION ALL

SELECT 'Edition', SERVERPROPERTY('Edition')

UNION ALL

SELECT 'EditionID', SERVERPROPERTY('EditionID')

.

.

.

.

.

.

.

As far as I am know(I could be wrong) Microsoft introduced downgrade rights with SQL server 2014. So if your SQL Server 2016 license has been purchased under volume licensing...

Yes, you can restore a database from 2005 to 2014 directly. Inplace Upgrade of an Instance beyond 2 versions might not work, but restoring a database from 2005 to any...

SSMS application by itself takes memory. I would rather use that memory on my local workstation than the actual server itself. SQL Server is a memory Pig. So.....

13.0.1800.00

Superb Report. Very helpful...Thanks Rudy!

sys.dm_server_services wont include Browser service...

So, you can use old school technique of pulling it from registry. Below query should do it...

DECLARE @DBEngineLogin ...

Can you check who is the job owner?...your account should be the job owner to be able to modify the respective job with these role assignments. If you want to...

I don't...but found this detailed white paper on setting up Windows server 2012 R2/SQL Server 2014 with the recommended settings on a HP Superdome X server.

I hope this helps.

If your Recovery model is set to FULL and you are taking only Full backups, then the log file will grow. A full backup won't truncate the T-log. So, if...

If this the first time you've enabled Mail profile in SQL Agent Alert system, You should restart SQL Agent service.

From SSMS, under your database, have you checked schema changes history report? It will show DDL changes occured on your database objects pulling from default trace. Hope you can find...