Before starting, let me inform you that Microsoft itself, promotes no way (or supporting) of downgrading Windows Server versions. In my case, i wanted to downgrade several Windows Server Datacenter servers, to Standard Edition, during their in-place upgrade process. The initial plan was to create new VMs and reinstall everything but the heavy configuration and... » read more
Recently, i was invited by a senior developer to investigate an issue with the aforementioned result. User was receiving the below error when tried to execute a specific Stored Procedure by using xp_cmdshell: Msg 15121, Level 16, State 200, Procedure xp_cmdshell, Line 1 [Batch Start Line 338] An error occurred during the execution of xp_cmdshell.... » read more
An interesting request came up from one of our customers. They were unable to complete a process that was running until lately. During a mass update in a database from a Microsoft Excel file, the export process was not producing a file. This custom upload process is based on a Microsoft. ACE.OLEDB.12.0 SQL Server Linked... » read more
During a visit to a regular customer, a strange request came from the upper IT management. As I was told, they noticed that the global email profile in one of their core SQL servers was mysteriously removed, resulting to errors and delays sending emails to some thousand customers, hence, they wanted me to investigate the... » read more