SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,949 questions
3 answers
One of the answers was accepted by the question author.
Compare table and update flag
Hi Team, I have 3 tables as shown below I am using MS flow - I get the ID in flow and fetch the Code for that ID in Table 1 (Eg: for 101 ID the code is 998877) Now need to compare that code (998877) in Table 2 If that code exists in table…
![](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, 27%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
2 answers
Windows Server 2012 R2 - Unexpected Restart
Hi Guys, I have problem with server. The server restart unexpected and show as picture below.. Anyone know what problem is it? Thank You.
![](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(217.60000000000002, 54%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYH%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
How to copy indexes from one table to another accross different db
suppose in db1 i have a emp1 table which has index and i have db2 and it has also emp1 table which has no index but same table structure. now i want to copy index from db1..emp1 to db2..emp1 and i tried below script which did not work but throw no error…
asked 2020-11-22T18:58:14.497+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, 12%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Sudip Bhatt
2,276
Reputation points
accepted 2020-11-23T09:13:47.323+00:00
Sudip Bhatt
2,276
Reputation points
2 answers
One of the answers was accepted by the question author.
HYPER -V REPLICA
Please note if anyone has information about this replica configuration is not active HYPER-V Setting
asked 2020-11-22T06:27:02.85+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, 57.99999999999999%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZI%3C/text%3E%3C/svg%3E)
zeynalov ismixan
96
Reputation points
answered 2020-11-23T09:12:54.237+00:00
Xiaowei He
9,906
Reputation points
1 answer
ActiveSync emails not down loaded into folders with Microsoft 365
ActiveSync exchange account at Outlook Microsoft 365 - updating seen to each folder downloaded , see attaching , - just none Emails in no folders after its time processed ? photo put this area perhaps not working…
asked 2020-11-15T00:40:41.007+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, 38%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB3%3C/text%3E%3C/svg%3E)
BleuOisou-3552
156
Reputation points
commented 2020-11-23T09:12:27.64+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(48, 71%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELZ%3C/text%3E%3C/svg%3E)
Lydia Zhou - MSFT
2,376
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Merge statement and insert data into another table
I have very basic question about Merge statement. see the sample code. MERGE Locations T USING Locations_stage S ON T.LocationID=S.LocationID WHEN MATCHED THEN UPDATE SET LocationName=S.LocationName; When Match then updating Location target table but if…
asked 2020-11-22T19:12:54.447+00:00
Sudip Bhatt
2,276
Reputation points
accepted 2020-11-23T09:11:26.33+00:00
Sudip Bhatt
2,276
Reputation points
2 answers
Remove "via" and "The actual sender of ....." Notification in Outlook
Hi All, I'm using a service to send emails as my domain, but when the emails are received it has the following highlighted notifications. I understand it is because of the difference between the Header FROM and Envelope. Is there a way to suppress it…
asked 2020-11-19T14:22:06.673+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, 62%, 28%)' 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)
MCcorpNow
66
Reputation points
commented 2020-11-23T09:10:33.997+00:00
JeffYang-MSFT
6,241
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
What is OUTPUT clause usaged with Merge statement
See this code example where OUTPUT clause has been used but what it will do ? does it just display data after merge statement complete updating or inserting data ? MERGE Production.ProductInventory AS target USING (SELECT ProductID,…
asked 2020-11-22T19:17:16.643+00:00
Sudip Bhatt
2,276
Reputation points
accepted 2020-11-23T09:08:19.043+00:00
Sudip Bhatt
2,276
Reputation points
2 answers
RDS Licensing Strange problem
Hello. I Have 5 RDS servers with Windows 2019. I have 30 RDS users License. The Rd license manager show that only 4 license are used, but for sure i have at least 25 users connected. The RD license diagnoser say that all is ok. I wondering Why…
asked 2020-11-19T16:52:00.247+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, 15%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAR%3C/text%3E%3C/svg%3E)
Andrea Rinaldi
6
Reputation points
commented 2020-11-23T09:07:51.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(252.8, 30%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEY%3C/text%3E%3C/svg%3E)
Eleven Yu (Shanghai Wicresoft Co,.Ltd.)
10,756
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to force Treeview scrollbar thumb scroll up/down when dragging any node
My treeview has huge node. i made possible to drag and drop the node. when i am on last node and try to drag that node to upward then treeview scrollbar not going up. so guide me how could i force treeview scroll bar go up when i will drag bottom nodes…
asked 2020-11-22T19:22:04.863+00:00
Sudip Bhatt
2,276
Reputation points
commented 2020-11-23T09:05:58.053+00:00
Sudip Bhatt
2,276
Reputation points
1 answer
[Migrated from MSDN Exchange Dev]problem with search index on exchange 2019
[Note] This thread was originally posted on MSDN. As the MSDN Exchange Dev forum mainly focuses on developing issues and the TechNet Exchange forums for general questions have been locked down, we manually migrated this one to Microsoft Q&A platform…
asked 2020-11-23T09:00:52.37+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, 22%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELL%3C/text%3E%3C/svg%3E)
Lucas Liu-MSFT
6,176
Reputation points
answered 2020-11-23T09:02:02.013+00:00
Lucas Liu-MSFT
6,176
Reputation points
1 answer
How to retrain Automated ML generated Model with new Data
Hi, i generated a machine learning model with Automated ML in Azure Machine Learning. Time to time i get new data, and i wanna feed the generated model with it. Is there a way to automatically retrain that model and updating the belonging endpoint.…
asked 2020-11-23T07:39:50.36+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(185.6, 44%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
ID_27051995
76
Reputation points
commented 2020-11-23T08:56:27.36+00:00
ID_27051995
76
Reputation points
1 answer
I need to get resource utilization data for azure sql hyperscaled database over email monthly. Can anyone help on that?
I need to get resource utilization data for azure SQL hyperscale database over email monthly. Can anyone help on that?
asked 2020-11-22T09:10:02.45+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(182.40000000000003, 19%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kumar Maity, Wrishav
1
Reputation point
commented 2020-11-23T08:54:56.637+00:00
Kumar Maity, Wrishav
1
Reputation point
1 answer
diploma 70-761 certified
Hello, I passed 70-761 exam in 30.05.2020. How can I get my diploma? Thank you. Have a nice day.
asked 2020-11-23T08:42:27.33+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, 91%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
Gheorghe Balint
1
Reputation point
answered 2020-11-23T08:49:01.933+00:00
MelissaMa-MSFT
24,201
Reputation points
1 answer
"fatal error LNK 1181:cannot open input file 'onecoreuap.lib".
Hi, When I try to compile DLL source file in Visual 2013 with build tool set Visual Studio 2013(V120), am facing the following error: "fatal error LNK 1181:cannot open input file 'onecoreuap.lib". Please anyone help how to solve this…
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
1,002 questions
asked 2020-11-06T11:56:27.647+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, 74%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Aishwarya Bhat
1
Reputation point
commented 2020-11-23T08:47:23.68+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, 11%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Dylan Zhu-MSFT
6,421
Reputation points
2 answers
One of the answers was accepted by the question author.
New Outlook version on Mac doesn't support some email accoutns
Hi all, I want to switch to the newer outlook version but one of my accounts seems to be not compatible with the newer version. In my old outlook version all of the accounts work normally. if I want to switch to the new version, a notification pops…
![](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(294.40000000000003, 96%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
3 answers
Estimate impact needed for rebuilding all indexes?
Have a 3rd party system that has a job that rebuilds all indexes nightly. We get periodic alerts when this happens that the TLog isnt big enough or a backup fails because the TLog is full. I know that rebuilding an index, and especially rebuilding ALL…
asked 2020-11-20T14:09:32.41+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(313.6, 25%, 40%)' 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)
bitshift
71
Reputation points
answered 2020-11-23T08:42:23.393+00:00
CathyJi-MSFT
22,306
Reputation points Microsoft Vendor
1 answer
No signin option in vscode
This might be pretty simple answer but i am breaking my head for quite some time on it. Can't seem to find answer online. When i go under Account (On left side bottom in VS Code) i see "You are not signed in to any account". Can anyone…
asked 2020-11-22T13:57:05.27+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(214.4, 17%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DevBuster007
186
Reputation points
answered 2020-11-23T08:38:01.21+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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
29,511
Reputation points Microsoft Vendor
1 answer
msn account frozen or locked out ?
Since November 7th I no longer get email from my cxxxxxx@Anonymous .com account on my computer or phone. Why not?
![](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(163.2, 83%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
![](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, 92%, 24%)' 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 answers
SSDT crash with two column key
I'm using the latest Visual Studio 2019 SSDT (SQL Data Tools). It crashes doing the following: Compare a table with PK constraint that has one column and also another unique constraint that has two columns as the key. In the comparison options,…
asked 2020-11-20T23:02:02.993+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, 11%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERO%3C/text%3E%3C/svg%3E)
Roberto Ortega
6
Reputation points
commented 2020-11-23T08:28:05.367+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(140.8, 78%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
Tianyu Sun-MSFT
31,086
Reputation points Microsoft Vendor