Downlaod updated version of Microsoft OLE DB Driver for Microsoft SQL
Helo Team, Please let me know how to get the updated version for "Microsoft OLE DB Driver for Microsoft SQL" Below are other SQL applications installed
always encrypted with secure enclave not working for DETERMINISTIC in JDBC
I'm using commercial Azure SQL, the database created via the portal, with secure enclaves enabled. I created the CMK and CEK using MSSQL_JAVA_KEYSTORE with keystore jks file. when using jdbc to test query for like and =, if the encrypted column is of…
What to do about "window.$RSjQuery is not a function" in Reserved.ReportViewerWebControl.axd
I inherited an ASP.NET Web Forms project that uses RDLC. It was using the Microsoft.ReportViewer 11.0.3366.16 NuGet package and my task has been to upgrade it to the Microsoft.ReportingServices.ReportViewerControl.WebForms 150.1652.0 NuGet. By…
How to fix sql server having a stuck ExportDatabase job at 1%, cancelling leads to stuck CancelInProgress instead
We were doing an ExportDatabase operation on our production database. This is part of our release pipeline, to do a backup before deploying new code. The github action timed out eventually since the export job got stuck at 1% and was stuck for 8 hours.…
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ?
How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ? I would like to write a query to get which CU is installed on my sql servers managed with Azure Arc. I don't find the exact product version. For instance,…
Execute TMSL in SSMS
I have a tmsl code which looks something like this: { "createOrReplace": { "object": { "database": "TabularProject1" }, "database": { "name":…
Fail to install sql 2022
FFail to install sql server2022 dev on my machine. I have install and reinstall for several times. It always said that error corrupted.
No drag and drop on SQL Server Management Studio on external display after installing update KB5051987
After installing the following update last Tuesday, I've lost the drag and drop feature in SQL Server Management Studio: 2025-02 Cumulative Update for Windows 11 Version 24H2 for x64-based Systems (KB5051987) The mouse drag'n'drop is completely disabled…
SQL Server 2022 error when downloading – taking more than 24 hours and still not resolved!
From my research, it seems that everyone is facing this issue, yet there is still no solution. I’m not sure what Microsoft is waiting for to fix this problem. I have completely uninstalled and reinstalled it, but I keep encountering the same issue. I…
SQL Migration Office 365: DAO missing
Hello What I want to do: Migrate a acessdata.accdb to SQL Database 2019 with SSMA 8.14. OS, Office and SSMA are 64 bit. The error I get when loading the database: Retrieving the COM class factory for component with CLSID…
What is the SSMA XML construct to convert TEXT to VARCHAR, not NVARCHAR - to set invalid SQL dates to NULL
I am using SSMA for ACCESS and I want to use the console.EXE so that I can automate the migration of ~25 separate databases all to the same SQL Server instance. I am able to use the GUI to achieve the results that I want but I do not want ot have to…
Unable to install SQL Server. Exit code (Decimal): -2147467259
I am trying to install SQL Server Express. [https://www.microsoft.com/en-ca/download/details.aspx?id=101064 I tried to install it, and then after a few minutes i get this error: Unable to install SQL Server. Exit code (Decimal): -2147467259 Im not sure…
Unable to Install SQL server 2022
Got this error while trying to install SQL Server 2022 Express edition. I restarted my laptop and tried again, still no luck. Also checked the summary log in the installation folder and the only info I can get from it is that I need a valid copy of the…
indic_general_90_ci_as was not found
I am trying to install SQL SERVER 2014 version but I am getting "indic_general_90_ci_as was not found" error. I have attached the screenshot of the error as well. Kindly help me how to fix this error. What does this error mean?
How to connect azure automation account to azure sql server which has private endpoint enabled
How to connect azure automation account to azure sql server which has private endpoint enabled
Region-specific drives for a VM located in Azure AU region
Hi Team, We have a requirement from clients to have the data in the respective data drives, for example - client from US wants to have their data in a drive which is physically located in the azure data centre in US region. We are looking at partitioning…
Function on Column used in Index - need optimization advice
First, is this the proper forum for MS SQL tsql questions? Why am I seeing only 114 questions? OK, so we have a table ods_DDAHIS which has a TransDate column that is numeric in format YYYYMMDD. There is an index on ods_DDAHIS.Transdate. Then view…
SSRS report with datetime parameter shown as text field
A client is complaining when he runs a report inside of the system where it runs inside of an iframe the two datetime pickers re rendered as textboxes, but running it directly works fine. Any idea?
SSIS An error occurred while attempting to perform a type cast.
The SQL Server has been updated to SQL 2022 (compatibility mode 150). The same file that works in production, now gives an error in Stage Error: 0xC0049064 at Load Flat File, Derived Column File [2]: An error occurred while attempting to perform a type…