20,057 questions with SQL Server-related tags

Sort by: Updated
1 answer

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

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,316 questions
asked 2025-02-24T09:42:05.1833333+00:00
Boopathi S 3,666 Reputation points
answered 2025-02-24T13:19:00.87+00:00
Olaf Helper 46,036 Reputation points
0 answers

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,651 questions
asked 2025-02-24T12:03:24.69+00:00
John Woo 0 Reputation points
0 answers

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…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,998 questions
asked 2024-07-24T15:34:12.08+00:00
Kevin Lipscomb 0 Reputation points
commented 2025-02-24T11:05:56.01+00:00
Rudy Lartigue 0 Reputation points
1 answer

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.…

Azure SQL Database
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-18T08:04:09.8533333+00:00
Kalle Macklin 0 Reputation points
edited an answer 2025-02-24T09:34:34.44+00:00
Kalle Macklin 0 Reputation points
2 answers

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,…

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
477 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
Azure Update Manager
Azure Update Manager
An Azure service to centrally manages updates and compliance at scale.
350 questions
asked 2025-02-17T19:00:55.1133333+00:00
Jean-Marie Roger 0 Reputation points
commented 2025-02-24T09:05:50.3866667+00:00
Ashok Gandhi Kotnana 3,540 Reputation points Microsoft Vendor
1 answer

Execute TMSL in SSMS

I have a tmsl code which looks something like this: { "createOrReplace": { "object": { "database": "TabularProject1" }, "database": { "name":…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,316 questions
asked 2025-02-24T05:52:34.35+00:00
Hammad Ahmed 0 Reputation points
answered 2025-02-24T07:46:11.05+00:00
Olaf Helper 46,036 Reputation points
1 answer

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.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,651 questions
asked 2025-02-24T05:31:31.68+00:00
Fake 0 Reputation points
answered 2025-02-24T05:48:29.7733333+00:00
ZoeHui-MSFT 40,901 Reputation points
1 answer

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 Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
119 questions
asked 2025-02-21T20:13:46.6+00:00
Alberto Silva 0 Reputation points
answered 2025-02-24T02:35:48.13+00:00
LiHongMSFT-4306 30,901 Reputation points
2 answers

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 Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,651 questions
asked 2025-02-21T15:45:18.37+00:00
James Flush 0 Reputation points
answered 2025-02-24T01:45:12.8366667+00:00
ZoeHui-MSFT 40,901 Reputation points
3 answers

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…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
549 questions
asked 2020-09-30T10:08:06.55+00:00
Monika Badertscher 6 Reputation points
answered 2025-02-23T20:10:08.7533333+00:00
VadymLeliuk 1 Reputation point
0 answers

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…

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
549 questions
asked 2025-02-23T17:15:46.52+00:00
Wade McPherson 0 Reputation points
edited the question 2025-02-23T17:27:15.3633333+00:00
Erland Sommarskog 117.5K Reputation points MVP
3 answers

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2023-01-21T16:53:15.7633333+00:00
gianlucaast 100 Reputation points
edited an answer 2025-02-23T15:31:53.9633333+00:00
Furqan Athar 0 Reputation points
1 answer

error microsoft sql server management studio ,"Oops...Error decompressing SQL media."

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2024-03-20T12:58:32.6433333+00:00
yensur thahir112 5 Reputation points
commented 2025-02-22T21:39:54.42+00:00
ahmed farouk 0 Reputation points
1 answer One of the answers was accepted by the question author.

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…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2023-09-26T20:45:59.9733333+00:00
Owen Patrick 20 Reputation points
commented 2025-02-22T09:41:08.3066667+00:00
Minas Kotsis 0 Reputation points
2 answers

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-19T08:38:06.2933333+00:00
Sudipto Deb 0 Reputation points
commented 2025-02-21T22:01:01.31+00:00
Erland Sommarskog 117.5K Reputation points MVP
0 answers

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-19T06:46:20.4933333+00:00
Yuvaraj Sonale 0 Reputation points
commented 2025-02-21T17:35:06.13+00:00
Mallaiah Sangi 80 Reputation points Microsoft Vendor
1 answer

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…

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,367 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,095 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
asked 2025-02-06T23:25:40.6466667+00:00
Berchmans Marcelline 15 Reputation points
commented 2025-02-21T16:37:59.1433333+00:00
Keshavulu Dasari 3,380 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

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…

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
119 questions
asked 2025-02-18T21:38:57.8033333+00:00
Grossnickle, Brenda 120 Reputation points
accepted 2025-02-21T15:26:40.43+00:00
Grossnickle, Brenda 120 Reputation points
2 answers

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,998 questions
asked 2025-02-20T17:40:38.5833333+00:00
Zolotoy 226 Reputation points
answered 2025-02-21T12:07:43.4733333+00:00
Zolotoy 226 Reputation points
3 answers One of the answers was accepted by the question author.

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…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,651 questions
asked 2025-02-20T16:35:43.11+00:00
Naomi Nosonovsky 8,191 Reputation points
accepted 2025-02-21T11:46:26.7+00:00
Naomi Nosonovsky 8,191 Reputation points