17,929 questions with SQL Server-related tags

Sort by: Updated
1 answer

Microsoft OLE DB Driver for Sql Server 18.7.2 x86 installer fails with unsupported operating system error on Windows 10

x64 works, but x86 gives me this message on multiple Windows 10 computers:

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,617 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.
12,713 questions
asked 2024-04-26T14:24:11.66+00:00
Erik Schlorholtz 0 Reputation points
answered 2024-04-26T15:26:07.7033333+00:00
Erik Schlorholtz 0 Reputation points
0 answers

Preview Error Adding Extension Assembly to SSRS RDL Report in VS2022

I am using Visual Studio 2022 with the Microsoft Reporting Services Projects extension. I've created a Reporting Services project and added a simple report. In this report, I included a textbox with the expression =User!Language and successfully…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
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,799 questions
asked 2024-04-25T20:50:57.0033333+00:00
James, Alec (Basingstoke) 0 Reputation points
commented 2024-04-26T15:06:18.7566667+00:00
James, Alec (Basingstoke) 0 Reputation points
0 answers

Powershell from SSIS - Empty environment variable

I'm running a script in an SSIS package and I specify an account to run the package in SQL Server Agent. When it runs, I am unable to get the value of $ENV:LOCALAPPDATA Here's my code along with writing out the LOCALAPPDATA value Start-Transcript…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,056 questions
asked 2024-04-26T14:36:22.63+00:00
HSB 25 Reputation points
2 answers

Log Shipping on SQL Server 2019 on Linux

I am attempting to set up log shipping in docker containers. I was able to set up the samba share and get everything setup and jobs deployed to both primary and secondary servers where the logs will be shipped. I think I have narrowed down the issue to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-25T18:11:39.8466667+00:00
Pepe-8078 0 Reputation points
commented 2024-04-26T14:36:08.77+00:00
Pepe-8078 0 Reputation points
1 answer

How to fix XamlReader.RewrapException(ex, xamlLineInfo, baseUri);

Here is the error System.Windows.Markup.XamlParseException: "'The invocation of the constructor on type 'DentistryOOP.View.MainWindow' that matches the specified binding constraints threw an exception.' Line number '6' and line position…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,245 questions
XAML
XAML
A language based on Extensible Markup Language (XML) that enables developers to specify a hierarchy of objects with a set of properties and logic.
765 questions
asked 2024-04-26T10:23:50.44+00:00
answered 2024-04-26T14:14:53.62+00:00
Michael Taylor 48,206 Reputation points
3 answers One of the answers was accepted by the question author.

How to contact Microsoft for technical support

We are running 2017 SQL enterprise and standard version. How to contact Micrsoft for technical support?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-25T15:06:44.48+00:00
szh8866-8371 100 Reputation points
accepted 2024-04-26T13:37:32.5566667+00:00
szh8866-8371 100 Reputation points
1 answer

Synapse Python/Spark Notebook code with SQL to query data from linked service to SQL Server

In Synpase, I have linked service to a SQL Server database. I'm looking for a sample notebook code, either in python or spark, that I can run a complex SQL qery within this code to get data from multiple SQL Server tables, put the rsults in a dataframe…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,368 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.
12,713 questions
asked 2024-04-24T13:45:40.7233333+00:00
ylycfj88 0 Reputation points
commented 2024-04-26T13:03:43.0433333+00:00
ylycfj88 0 Reputation points
0 answers

Does PolyBase support JOIN PUSHDOWN to Oracle Data Source

From my testing PolyBase on SQL 2019 does not push JOIN to the data source, even though the data source is setup with PUSH DOWN on. The documentation it states JOINS can be pushed down to…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-26T13:00:58.79+00:00
Mihaela 1 Reputation point
3 answers One of the answers was accepted by the question author.

Locking comparison SQL Server 2017 versus SQL Server 2022

We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-22T12:53:22.4133333+00:00
Paolo Taverna 71 Reputation points
commented 2024-04-26T11:36:16.8166667+00:00
Paolo Taverna 71 Reputation points
1 answer

Azure Data Share to Share data from Azure Managed Instance SQL Server

As part of my migration project requirements, I am looking to share data from my source system which is in Azure MI SQL Server and to the target system which is also in Azure MI SQL Server. I need to share the source data which is in Azure MI SQL Server…

Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
44 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.
12,713 questions
asked 2024-04-26T06:54:52.4633333+00:00
Balan Murugan 41 Reputation points
commented 2024-04-26T10:50:29.0133333+00:00
Balan Murugan 41 Reputation points
4 answers

MSSql 2k16 cannot switch version

running an express edition of 2k16, that reached file size limit, on a w10/64 OS. All OS updates done. SMSS v 20.1 Purchased serial with 20 cals. Started the "2k16 install center" --> Maintenance --> Edition upgrade type in the serial.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-26T04:19:36.4433333+00:00
rnervi 0 Reputation points
commented 2024-04-26T10:16:05.1366667+00:00
rnervi 0 Reputation points
1 answer

How to fix Database Engine Services Failure during SQL server 2022 installation

I was trying to install SQL Server 2022 on my windows virtual machine and got the following error: Unable to install SQL Server(setup.exe) I have attached the summary file too.Summary.txt

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-25T17:10:02.28+00:00
Juwairiyyah Ahmed 0 Reputation points
commented 2024-04-26T09:51:48.36+00:00
Juwairiyyah Ahmed 0 Reputation points
2 answers

How to enable support for Unicode characters with command prompt

Hello Microsoft Support, We are facing an issue when using bcp.exe command on Windows server to bulk load data to SQL Server. The BCP command is not working when the file name contains non-english characters. We wanted to enable Unicode support for…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,127 questions
asked 2024-04-22T13:33:58.7+00:00
Yash Jain 5 Reputation points
commented 2024-04-26T09:45:17.24+00:00
Olaf Helper 40,816 Reputation points
0 answers

How to fix XamlReader.RewrapException(ex, xamlLineInfo, baseUri);

System.Windows.Markup.XamlParseException: "'The invocation of the constructor on type 'DentistryOOP.View.MainWindow' that matches the specified binding constraints threw an exception.' Line number '6' and line position '9'."

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,245 questions
XAML
XAML
A language based on Extensible Markup Language (XML) that enables developers to specify a hierarchy of objects with a set of properties and logic.
765 questions
asked 2024-04-26T09:37:34.1633333+00:00
1 answer One of the answers was accepted by the question author.

Access Blob Storage from Azure SQL Server using a Managed Identity

Greetings, As the title suggests I am trying to bulk insert data from a file in Blob Storage in an Azure SQL database using an external data source with a credential using a managed identity. However the bulk insert fails saying the sql server doesn't…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,427 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.
12,713 questions
asked 2024-04-25T15:48:03.96+00:00
Dimitar Grozev 20 Reputation points
accepted 2024-04-26T09:30:44.31+00:00
Dimitar Grozev 20 Reputation points
5 answers

SQL Server Express 2022 Reinstall

Hi I have a question regarding the install process of SQL Server 2022 Express. I was running the platform successfully. My laptop was then migrated to a different domain and SQL Server stopped working (folder rights). I subsequently uninstalled SQL…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-19T06:14:14.86+00:00
Francois Timms 0 Reputation points
commented 2024-04-26T08:03:37.0766667+00:00
LucyChen-MSFT 890 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Issue with Bulk import using BCP with data file name consisting non-English character

I attempted to bulk import data using BCP from a file with non-English characters in its name. Both files were accessible, yet the import failed. Renaming the file to "order.txt" and "order.txt.format" resolved the issue, allowing…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-02-28T11:25:16.1466667+00:00
Haresh Prajapati 20 Reputation points
commented 2024-04-26T08:02:21.3366667+00:00
Haresh Prajapati 20 Reputation points
3 answers One of the answers was accepted by the question author.

Convert xlsx files to csv via automated script?

Hello, we have .xlsx files (not xls) and would like to convert them into csv files (so we can import into SQL Server) via some type of automated script to avoid manually doing each day. (Tried different methods via Import Wizard and OPENROWSET and got…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-25T17:26:35.9733333+00:00
techresearch7777777 1,776 Reputation points
accepted 2024-04-26T07:21:57.6866667+00:00
techresearch7777777 1,776 Reputation points
1 answer

How to handle Azure SQL Virtual Machine discovery and cost together with Azure DevOps Server?

Hello, I am looking for answers for the scenario when we install Azure DevOps Server on Azure Virtual Machine. In this scenario we have VS Enterprise licenses so we have Azure DevOps Server license with SQL Standard license covered. However Azure came…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,128 questions
Azure Cost Management
Azure Cost Management
A Microsoft offering that enables tracking of cloud usage and expenditures for Azure and other cloud providers.
2,034 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.
12,713 questions
asked 2024-04-25T08:00:03.7266667+00:00
Milan 56 Reputation points
commented 2024-04-26T07:15:13.0133333+00:00
Milan 56 Reputation points
4 answers

Tail log backup

Are tail log backups supported only in Full Recovery model?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,713 questions
asked 2024-04-16T14:09:24.11+00:00
Chaitanya Kiran 696 Reputation points
commented 2024-04-26T06:17:30.22+00:00
LucyChen-MSFT 890 Reputation points Microsoft Vendor