Monday, August 27, 2018

Error message “Explorer.exe - No such interface supported” in Windows 7

1. Click Start. In the Search box, type CMD. At the top of the window, right-click the cmd icon and choose Run as Administrator.
2. At the prompt, type in FOR /R C:\ %G IN (*.dll) DO "%systemroot%\system32\regsvr32.exe" /s "%G" and press.

This will take several minutes to complete. There will be several C+ Runtime errors that will appear, as well as the system slowing down. Once complete, restart the system and test.

Wednesday, August 8, 2018

How to migrate a MS SQL Server database to a lower version

Solution 1
Generate a script of schema and data using ssms "generate scipts" option

Solution 2
Generate a script of schema using ssms "generate scipts" option
Use data compare wizard is data is too big