Month: May 2019
-
SQL SERVER – Installation Failure Database engine services failed.
Sometimes when we install SQL Server or Add any new SQL Server Instance on Windows Machine, we can see the database errors listed below. To resolve these errors we are trying to repair existing installation or do something else. If nothing happens then we are trying to install it completely from control panel, but it…
-
Import CSV using “Microsoft Access Database Engine 2010” to SQL Server
[SQL] sp_configure ‘Ad Hoc Distributed Queries’, 1 reconfigure with override SET NOCOUNT ON EXEC master..xp_cmdshell ‘del C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo [Test.txt] > C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo ColNameHeader=True >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo Format=Delimited(^|) >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo MaxScanRows=50 >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo CharacterSet=OEM >> C:\Temp\Schema.ini’ EXEC master..xp_cmdshell ‘echo Col1=ID TEXT >> C:\Temp\Schema.ini’ EXEC…
-
Fix: SQL Server Management Studio 18.0 won’t open – only splash screen
Replace the “Microsoft.VisualStudio.Shell.Interop.8.0.dll” in “C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PublicAssemblies” with the copy from “C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PrivateAssemblies\Interop” and then try. It should work.