SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,711 questions
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
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
![](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(224.00000000000003, 79%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Груша Максим Олександрович
0
Reputation points
answered 2024-04-26T14:14:53.62+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, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
48,046
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?
asked 2024-04-25T15:06:44.48+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(150.4, 60%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES8%3C/text%3E%3C/svg%3E)
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…
![](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(262.40000000000003, 27%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EY%3C/text%3E%3C/svg%3E)
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…
![](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(89.60000000000001, 4%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
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…
asked 2024-04-22T12:53:22.4133333+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, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
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…
asked 2024-04-26T06:54:52.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(179.20000000000002, 76%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
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.…
![](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(147.20000000000002, 84%, 24%)' 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 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
asked 2024-04-25T17:10:02.28+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(9.6, 57.99999999999999%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
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…
asked 2024-04-22T13:33:58.7+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(83.2, 90%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYJ%3C/text%3E%3C/svg%3E)
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,711 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
Груша Максим Олександрович
0
Reputation points
asked 2024-04-26T09:37:34.1633333+00:00
Груша Максим Олександрович
0
Reputation points
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…
asked 2024-04-25T15:48:03.96+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(99.2, 51%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
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…
asked 2024-04-19T06:14:14.86+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(224.00000000000003, 74%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
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…
asked 2024-02-28T11:25:16.1466667+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(236.8, 94%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
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…
asked 2024-04-25T17:26:35.9733333+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(102.4, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
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…
![](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(57.599999999999994, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
4 answers
Tail log backup
Are tail log backups supported only in Full Recovery model?
asked 2024-04-16T14:09:24.11+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(304, 63%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECK%3C/text%3E%3C/svg%3E)
Chaitanya Kiran
696
Reputation points
commented 2024-04-26T06:17:30.22+00:00
LucyChen-MSFT
890
Reputation points Microsoft Vendor
4 answers
GDR upgrade path question
I have a SQL Server updated to version 15.0.4326.1, which is on the GDR path but on a GDR + CU version. Can I install the next update on the GDR path to go to version 15.0.2110.4 that is GDR only, or do I have to install the next GDR + CU update?
asked 2024-04-15T20:47:18.0366667+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, 81%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Ryan Schmitz
0
Reputation points
commented 2024-04-26T06:14:53.17+00:00
LucyChen-MSFT
890
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Excel数据导入的问题
我在尝试把excel表格的数据导入到sql的表里，有什么办法可以把前100行导入到A表，101-200行的数据导入到B表这样一次性完成吗
![](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(243.2, 19%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
3 answers
How to audit the data change in SQL
We are currently running SQL 2017. We are trying to track the data change with information like DateCreated,CreatedBy for new record added and DataChanged and ChangedBy for data updated or deleted. What is the best way to track these information? Thanks
asked 2024-04-25T15:46:33.6133333+00:00
szh8866-8371
100
Reputation points
edited an answer 2024-04-26T06:04:02.9733333+00:00
MikeyQiao-MSFT
485
Reputation points Microsoft Vendor
1 answer
The 'Publish and Subscribe' feature does not work on SQL Server2019 installed using Docker technology on Linux
Database server information : Linux (Rocky 9.1) , Podman platform install (A kind of docker technology),SQLServer 15.0.4033.1(2019)，docker image downloaded from the microsoft website,The service startup command is: podman run --name mssql2019 --net=host…
![](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(176, 97%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)