Hello I have installed Windows 11 a month ago; everything works fine except for an application that I developed using Visual Studio and SQL Server Express. I uninstalled everything that concerns SQL, deleted the directories and registry keys. I…
Today I discovered that I also have a local VM on which VS2019 + SQL Server 2019 + SSIS extension 4.5 was installed. On this VM I could switch to target version 2016 without problems. So I started comparing the folder contents between the VM and my local PC. It appeared ...
However, we dont understand, why in MSSQL 2016 Developer version, it report Index created successfully. but in MSSQL 2019 standard version, it report error, it looks the table name is sensitive in some case. Can anyone explain when MSSQL sensitive the table name? Please sign...
FIX: Query results are not as expected when you run a particular query from Excel in SQL 2014 SP2 CU14 or later version (2016, 2017 or 2019)
However, the service account used by the SQL Reporting Services service was not properly configured to support these algorithms. Instead, SSRS was attempting to authenticate using the RC4 encryption type, which is no longer allowed on the server, resulting in the...
CPPSQLDatabase CPPStoredProcedure CPPTablet CPPTest CPPTestApplication CPPTestLibrary CPPWebService CPPWin32Application CPPWindowsFormsApplication CPPWindowsService CrashDumpFile CreateMessage CreatePropertyBrush CreatePullRequest CrossGroupLink 一般報表 CSApplication CSAssembyInfoFile CSBDCModel CSBlankApplicati...
FIX: Unable to execute sys.dm_exec_requests when you install SQL Server 2019 or when you upgrade from prior versions of SQL Server
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Resolution This issue is fixed in the following cumulative update for SQL Server: Cumulative Up...
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. Resolution This issue is fixed in the following cumulative update for SQL Server: Cumulative Upd...
Describe the bug I am having huge problems with the current SQL Server 2019 (15.0.2070.41) and native compiled stored procedures when calling them from the Microsoft.Data.SqlClient (1.1.0 and lower). It is working when either using SQL S...