SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,082 questions
1 answer
Why FOR XML PATH does not escape " or ' but does < or > or &
Hi there. I am puzzled by this behavior SELECT v.sc as [data()] FROM (VALUES ('"' , '"') ,('''' , ''') ,('<' , '<') ,('>' , '>') ,('&' , '&') ) v (sc, sce) FOR XML PATH(''), TYPE The…
asked 2024-11-25T15:22:53.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 95%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVM%3C/text%3E%3C/svg%3E)
Vladimir Moldovanenko
256
Reputation points
answered 2024-11-25T17:28:08.93+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
67,411
Reputation points
0 answers
Visual Studio: Web Server Unable to Listen on Port
Hello, I am encountering an issue with Visual Studio running on a Microsoft Windows Server 2022 Datacenter Evaluation, hosted as a Hyper-V virtual machine. When starting my ASP.NET Core application, I get an error indicating that the web server cannot…
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,648 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,236 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,082 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,945 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,745 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,648 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,236 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,082 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,945 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,745 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(179.20000000000002, 84%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
0 answers
Visual Studio: Web Server Unable to Listen on Port
Hello, I am encountering an issue with Visual Studio running on a Microsoft Windows Server 2022 Datacenter Evaluation, hosted as a Hyper-V virtual machine. When starting my ASP.NET Core application, I get an error indicating that the web server cannot…
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,648 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,236 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,082 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,945 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,745 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,648 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,236 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,082 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,945 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,745 questions
0 answers
We are setting up Entra Authentication for SQL Server. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted?
We are setting up Entra Authentication for SQL Server on premises via Azure Arc. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted?
asked 2024-11-22T22:00:30.56+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 19%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Seekell, Roger
46
Reputation points
commented 2024-11-25T15:48:39.94+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,210
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
I cannot install the SQL Server 2022 Developer Edition
I cannot install the SQL Server 2022 Developer Edition (x64) on the Microsoft Windows 10 Pro (10.0.19045). The Database Engine Services failed to install. Please see error messages and exit codes below: Error installing SQL Server Database Engine…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(185.6, 18%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
1 answer
How can I avoid costs on a free Azure account?
A few days ago, I created a free account to host my .NET API. This application uses SQL Server, so I decided to work with Azure SQL Server. Since I was in the design phase, I opted for their free-tier offering. However, at some point, I must have created…
asked 2024-11-25T13:11:20.4933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 9%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIF%3C/text%3E%3C/svg%3E)
Ignacio Ferrando
0
Reputation points
answered 2024-11-25T15:15:04.0333333+00:00
Ryan Hill
28,736
Reputation points Microsoft Employee
1 answer
Can I buy SQL Server 2022 Enterprise 96 Core License and install it on 4 physical servers with with 24 cores
Can I buy SQL Server 2022 Enterprise 96 Core License and install it on 4 physical servers with with 24 cores
asked 2024-11-25T14:10:01.0133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 97%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
menashe altman
0
Reputation points
answered 2024-11-25T14:11:41.6033333+00:00
menashe altman
0
Reputation points
1 answer
Can I buy SQL Server 2022 Enterprise 96 Core License and install it on 4 physical servers with with 24 cores
Can I buy SQL Server 2022 Enterprise 96 Core License and install it on 4 physical servers with with 24 cores
asked 2024-11-25T14:10:01.0133333+00:00
menashe altman
0
Reputation points
answered 2024-11-25T14:11:41.6033333+00:00
menashe altman
0
Reputation points
0 answers
Feature support of SQL Agent job running SQL Server Integration Services package with CDC task
We are trying to setup a SQL Agent which runs a SQL Server Integration Services package that makes use of a CDC Source Data Flow task. When running the job, we get an error saying that Enterprise Edition is required: Looking at documentation, we…
asked 2024-11-25T11:43:10.2033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 21%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Victor Rubio
20
Reputation points
edited the question 2024-11-25T11:44:48.4166667+00:00
Victor Rubio
20
Reputation points
0 answers
Feature support of SQL Agent job running SQL Server Integration Services package with CDC task
We are trying to setup a SQL Agent which runs a SQL Server Integration Services package that makes use of a CDC Source Data Flow task. When running the job, we get an error saying that Enterprise Edition is required: Looking at documentation, we…
asked 2024-11-25T11:43:10.2033333+00:00
Victor Rubio
20
Reputation points
edited the question 2024-11-25T11:44:48.4166667+00:00
Victor Rubio
20
Reputation points
1 answer
Error when setting destination in Copy Data activity (MS Fabric)
Hi all, In my Fabric workspace, I have a pipeline with a "Copy Data" activity. The source is a lakehouse. I am trying to set the destination to be SQL Server. I have put in the server name, username and password. I also checked the checkbox…
asked 2024-11-23T16:16:39.4233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 6%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJU%3C/text%3E%3C/svg%3E)
John Uzoma
20
Reputation points
commented 2024-11-25T10:43:51.87+00:00
John Uzoma
20
Reputation points
2 answers
BizTalk Server 2020 on Windows Server 2022 and SQL Server 2022
Can we install BizTalk Server 2020 on Windows Server 2022 and use Sql Server 2022 as the default database?
asked 2023-09-08T13:42:51.9766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 81%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Asher A
6
Reputation points
answered 2024-11-25T10:19:05.8733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 9%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUS%3C/text%3E%3C/svg%3E)
Urban Svensson
0
Reputation points
2 answers
BizTalk Server 2020 on Windows Server 2022 with SQL Server 2022
Can we install BizTalk Server 2020 on Windows Server 2022 with SQL Server 2019 and if Microsoft supports it ? Thanks
asked 2023-09-08T15:59:08.24+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 26%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Arshad, Sharjeel (TBS)
5
Reputation points
answered 2024-11-25T10:18:40.7733333+00:00
Urban Svensson
0
Reputation points
1 answer
Skip five rows when loading data
Is it possible to skip the top5 rows when loading data from flat file to sql table in SSIS
asked 2024-11-25T07:06:48.4633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 7.000000000000001%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Su Si
20
Reputation points
edited an answer 2024-11-25T07:19:10.2066667+00:00
ZoeHui-MSFT
38,066
Reputation points
1 answer
One of the answers was accepted by the question author.
SQL Availability Groups
Dear team, We are considering to deploy SQL 2019 on three servers, one that will be hosting the active databases (around 150 databases), one for high availability and one server in the disaster recovery site. We are considering using SQL availability…
asked 2024-11-06T07:11:57.0333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 52%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Micheal Mallo
330
Reputation points
commented 2024-11-25T06:23:54.7433333+00:00
Micheal Mallo
330
Reputation points
2 answers
One of the answers was accepted by the question author.
Maximum Length Exceeded
I am seeing the following error in my logs: EntityFramework.Exceptions.Common.MaxLengthExceededException: Maximum length exceeded ---> Microsoft.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated in table 'dbo.Profile',…
asked 2024-11-22T14:57:18.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(76.8, 43%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mike-E-angelo
541
Reputation points
edited the question 2024-11-25T05:27:49.19+00:00
ZoeHui-MSFT
38,066
Reputation points
1 answer
How to create DB for Reservation
I have a reservation - SQL Database Single/Elastic Pool General Purpose - Compute Gen5 Could you please share with me instructions on how to create DB suitable for my reservation As I understand if I create DB correctly it will link to the…
asked 2024-11-20T18:06:39.1+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 79%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Easy Drive
0
Reputation points
commented 2024-11-25T04:47:22.6+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,585
Reputation points Microsoft Vendor
1 answer
Azure MI Linked Server
Hi Team, I want to create linked server in Azure Managed Instance using Microsoft OLEDB driver, but I am unable to do the same so can you please help me with that if there is any way where we can do that. Or is there any other solution to connect Azure…
asked 2024-11-21T10:43:38.2166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(230.39999999999998, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Prateek Hiremath
20
Reputation points
commented 2024-11-25T04:28:54.4666667+00:00
Sai Raghunadh M
1,210
Reputation points Microsoft Vendor
3 answers
MS SQL Server 2012 Standard Free Edition
I need MS SQL Server 2012 Standard Free Edition and also SSMS 2012 standard Edition Free Version download link. Please help in urgent basis
asked 2024-11-24T14:05:22.2533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 37%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Md. Baker Hossen
0
Reputation points
answered 2024-11-25T03:28:35.0566667+00:00
LiHongMSFT-4306
28,806
Reputation points
1 answer
could not start the MSSQL server service I got an error 1067 in windows 11 with SQL Server 2024
I install the windows 11 with version 24H2 Build 26100.2314 pro then installed the Microsoft.SQL.Server.2022.Enterprise.x64 so after finished the success message of SQL installer, I try to start the MSSQLSERVER and I faced on below error: Windows could…
asked 2024-11-24T06:07:54.5166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 81%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Muhammad Ganji nezhad
0
Reputation points
answered 2024-11-25T03:15:43.6933333+00:00
LiHongMSFT-4306
28,806
Reputation points