SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,938 questions
2 answers
One of the answers was accepted by the question author.
How can I sync data from a source database table without primary key to the destination database table with primary key
Hi all, If the source MS SQL SERVER 2017 database table does not have primary key but destination MS SQL SERVER 2019 database table has primary key, what is the best way or method to make both tables data in sync? Please take into consideration that…
![](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, 28.000000000000004%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
4 answers
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
asked 2024-05-16T12:03:46.98+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(124.80000000000001, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nitya V
40
Reputation points
commented 2024-05-31T03:07:04.0466667+00:00
LucyChenMSFT-4874
1,660
Reputation points
2 answers
Is there a tier for a Flat Monthly Fee for an Azure VPN?
Since it seems we will have to constantly create a VPN, then delete it, then recreate it again when needed since there is no way to just disable when not needed. Is there a tier for a flat fee for an Azure VPN??
Azure VPN Gateway
Azure VPN Gateway
An Azure service that enables the connection of on-premises networks to Azure through site-to-site virtual private networks.
1,415 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,022 questions
asked 2024-05-30T14:52:23.72+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(6.4, 68%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Darrin Burns
20
Reputation points
answered 2024-05-31T03:06:07.6433333+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(134.4, 59%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
ChaitanyaNaykodi-MSFT
23,736
Reputation points Microsoft Employee
3 answers
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)
How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…
asked 2024-05-21T13:10:34.7166667+00:00
Nitya V
40
Reputation points
commented 2024-05-31T03:05:40.31+00:00
LucyChenMSFT-4874
1,660
Reputation points
1 answer
Troubleshooting SQL Server Replication Error During Version Upgrade
How can we resolve a Replication error that occurs when trying to include certain tables in a Publication after migrating from SQL Server 2012 to SQL Server 2019? Removing the affected articles is a temporary solution, but the issue persists for 10…
asked 2024-05-22T03:50:56.0266667+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(220.8, 35%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vanitha Dodla (MINDTREE LIMITED)
40
Reputation points Microsoft Vendor
commented 2024-05-31T03:04:48.8+00:00
LucyChenMSFT-4874
1,660
Reputation points
1 answer
Bidirectional replication between on prem SQL server and Azure sql with no primary key exist
Can you suggest possible solution for bidirectional real time sync between on prem SQL (2016) and Azure SQL with no primary key exist
asked 2024-05-30T21:51:18.5233333+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, 57.00000000000001%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Shantanu Dekapurwar
20
Reputation points
edited a comment 2024-05-31T03:04:10.92+00:00
Alberto Morillo
33,086
Reputation points MVP
1 answer
How to fix build errors that I am getting currently when I convert my .NET MAUI [ sdk 6 version] to .NET 8 version?
I am currently in a process of converting my MAUI project which is in .NET 6 version to .NET 8 version. I have used Microsoft's .NET upgrade assistant extension tool for the same. After successful upgrade, when I try to build/rebuild my project, I am…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,478 questions
.NET MAUI
.NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
3,007 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,413 questions
asked 2024-05-29T07:24:16.99+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(220.8, 0%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Suhas MR
0
Reputation points
answered 2024-05-31T03:04:08.02+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(22.400000000000002, 3%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EWZ%3C/text%3E%3C/svg%3E)
Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.)
27,126
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Datatime value issue
Hi, How to correct it below? tb_apply_date.Text = Datetime.Now.ToString();
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,721 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,413 questions
asked 2024-05-30T08:28:23.0166667+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, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,546
Reputation points
accepted 2024-05-31T03:03:42.38+00:00
Peter_1985
2,546
Reputation points
3 answers
Problems with AlwaysOn, HADR_LOGPROGRESS_SYNC waits and missing log block
Hi Folks! Need help from you ! We have some issues with AlwaysOn synchronisation on high load system and we can it repeat on PROD and LT environmets(not depend from hardware). Configuration: SQL Seerver 2019 EE CU24 Prod- 4 nodes (2 synchronous mode…
asked 2024-05-23T13:55:55.1133333+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(3.2, 74%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVN%3C/text%3E%3C/svg%3E)
Viacheslav Nikonorov
0
Reputation points
commented 2024-05-31T03:03:13.9066667+00:00
LucyChenMSFT-4874
1,660
Reputation points
1 answer
Can find the Power automate SharePoint test site for module Getting Started with Power Automate Unit 4
Can anyone tell me how to access the test sharepoint site for unit 4 of the Getting started with Power Automate Module? My org doesn't let me create a new file in our sharepoint site and I can't seem to access the one that the module says is…
asked 2024-05-29T20:36:36.2633333+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(54.400000000000006, 88%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Brittany Cummings
0
Reputation points
commented 2024-05-31T03:02:43.79+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, 86%, 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)
AmaranS
2,770
Reputation points Microsoft Vendor
4 answers
Can a deadlock issue be raise while running two select queries in sql server
Do we get a deadlock issue while running two select statements of two different table in sql server
asked 2024-05-24T13:21:28.4666667+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(316.8, 73%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKC%3C/text%3E%3C/svg%3E)
Khan-CW, P Ali Altaf 63769
0
Reputation points
commented 2024-05-31T03:02:32.7033333+00:00
LucyChenMSFT-4874
1,660
Reputation points
1 answer
Azure fundamentals launching sandbox is taking me to launch on a different organisation's
During the Azure fundamentals training I have just reached the training on Azure Accounts. At one point it starts to spin up the sandbox and despite my email address being pwc.com it is trying to go to a different pension company completely and as a…
Azure Training
Azure Training
Azure: A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.Training: Instruction to develop new skills.
1,076 questions
asked 2024-05-29T15:20:25.3366667+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(54.400000000000006, 46%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
David Cory (UK)
0
Reputation points
commented 2024-05-31T03:02:03.38+00:00
AmaranS
2,770
Reputation points Microsoft Vendor
1 answer
"Remove Unused References" unavailable for UWP projects
I have enabled "Remove Unused References" but the context menu of a UWP app project does not have the option: Could anyone shed some light on this?
asked 2024-05-30T23:35:05.0633333+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, 0%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EH%3C/text%3E%3C/svg%3E)
Hong
1,141
Reputation points
answered 2024-05-31T03:01:22.2966667+00:00
Junjie Zhu - MSFT
15,911
Reputation points Microsoft Vendor
2 answers
sql server agent alert failed
hello I have this problem with my SQL Server Agent, the service is working properly but when I make alert by some program running by SQL Server it shows that SQL Server agent is not working even if it is working, where should the problem be?
asked 2024-05-29T07:47:16.79+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(156.8, 34%, 25%)' 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)
Ahmed Al Mohalami
0
Reputation points
commented 2024-05-31T03:01:13.3133333+00:00
LucyChenMSFT-4874
1,660
Reputation points
1 answer
How to change the logo for SQL Server Master Data Services (MDS) in 2019
This used to be accomplished in the SQL Server Master Data Services (MDS) 2016 version by changing the logo.png file.
asked 2024-05-29T13:40:17.81+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(291.2, 5%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENJ%3C/text%3E%3C/svg%3E)
Novicki, Joseph
0
Reputation points
commented 2024-05-31T03:00:49.05+00:00
LucyChenMSFT-4874
1,660
Reputation points
1 answer
Microsoft Account Help
Does anyone know why I can't add a Samsung S23 to my Microsoft Account, it doesn't even show up as a linked device even though I'm signed in on edge with the phone like it says to.
Microsoft Edge
Microsoft Edge
A Microsoft cross-platform web browser that provides privacy, learning, and accessibility tools.
2,182 questions
asked 2024-05-30T14:03:21.2833333+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(259.20000000000005, 99%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
Lonnie
0
Reputation points
answered 2024-05-31T03:00:17.8933333+00:00
ShiJieLi-MSFT
8,106
Reputation points Microsoft Vendor
1 answer
The trust relationship between this workstation and the primary domain failed
Good day, I have some issue which is this error will appear when try to login the PC that has been joined the domain. The error was "The trust relationship between this workstation and the primary domain failed". I try several solution which is…
![](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(16, 36%, 11%)' 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)
1 answer
Onedrive no Server 2012 R2 Não Conecta
Onedrive no Server 2012 R2 Não Conecta, Help
asked 2024-05-30T14:46:28.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(297.6, 30%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIS%3C/text%3E%3C/svg%3E)
Ideal Suporte - T.I e Seg Eletrônica
0
Reputation points
answered 2024-05-31T02:55:02.71+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(278.4, 92%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYL%3C/text%3E%3C/svg%3E)
Yanhong Liu
3,420
Reputation points Microsoft Vendor
1 answer
Powershell script to Download All Contents ( Folder and Files ) from Sharepoint and Local to SharePoint
Hi There, Good Day. Would like to seek your assistance on how we able to transfer/download Folder with files and sub-folder, files to Local Drive from Sharepoint and Local to SharePoint. Greatly appreciate your feedback. Thank You.
asked 2024-05-30T06:10:30.32+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(176, 86%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Karl
0
Reputation points
answered 2024-05-31T02:54:32.3+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, 5%, 34%)' 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)
RaytheonXie_MSFT
32,246
Reputation points Microsoft Vendor
1 answer
Internal user and external cannot chat with each other in Teams
Hello Please i need your help on this issue. We have one of our user who is able to chat with an external user in Teams. When ever he tries to chat with the external user he get the error message below: "External user need to accept your…
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,282 questions
asked 2024-05-30T06:15:22.42+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(172.8, 76%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI8%3C/text%3E%3C/svg%3E)
IniobongNkanga-8038
266
Reputation points
answered 2024-05-31T02:53:42.2+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(112.00000000000001, 24%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
JimmyYang-MSFT
49,536
Reputation points Microsoft Vendor