SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,672 questions
3 answers
how to create a trigger for a table whose values depends on join
i have these tables from where first i need to find the validity column value from packages table then i need to create a trigger on every insert or update to see if the userpackges table has packagestatus column value set to true then trigger creates…
asked 2020-09-03T15:06:27.23+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(32, 22%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shahzaib khan
6
Reputation points
commented 2020-09-14T02:07:47.897+00:00
Shahzaib khan
6
Reputation points
2 answers
One of the answers was accepted by the question author.
Issue in installing additional SCOM Management server
Env: SCOM 2016 We have five Management Servers in the environment. Now, I want to add two more servers to environment. Built Windows 2016 servers and tried installing SCOM MS compoenent but stuck with mentioning Database details. When I enter Listener…
asked 2020-09-10T12:50:53.597+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, 83%, 26%)' 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)
Balaji Suresh
96
Reputation points
commented 2020-09-14T02:05:16.793+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(233.6, 30%, 32%)' 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)
Crystal-MSFT
48,001
Reputation points Microsoft Vendor
0 answers
Error while connecting Azure web app with custom connector in PowerApps
I have followed [MS article][1] to configure Azure AD authentication to my Azure Webapp. In this web app I am having API which I am calling as https://mysite.azurewebsites.net/api/Plugin. This is working fine if I don't have any authentication for my web…
asked 2020-09-10T09:48:06.43+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, 14.000000000000002%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMY%3C/text%3E%3C/svg%3E)
Mihir Yelamanchili
21
Reputation points
commented 2020-09-14T02:04:22.383+00:00
JamesTran-MSFT
36,596
Reputation points Microsoft Employee
1 answer
Estou com problemas no Visual C++
[1B18:1D24][2020-09-07T15:41:19]i001: Burn v3.10.4.4718, Windows v10.0 (Build 19041: Service Pack 0), path: C:\Users\ADRIAN\AppData\Local\Temp{E0EA5B9D-2342-4D65-A633-D1ABBF2E70ED}.cr\VC_redist.x86 (1).exe [1B18:1D24][2020-09-07T15:41:19]i009: Command…
asked 2020-09-07T18:41:23.877+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(128, 80%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Adrian Henrique
1
Reputation point
commented 2020-09-14T02:03:27.45+00:00
Molly Lu
841
Reputation points Microsoft Vendor
2 answers
Windows 10 Blue screen SYSTEM THREAD EXCEPTIONS NOT HANDLED
Hi... For a while I start getting a blue screen with this code SYSTEM THREAD EXCEPTIONS NOT HANDLED What failed: BazisVirtualCDBus Can I find how to fix that please and Thanks! Note: I don't really want to format my pc
asked 2020-09-05T21:31:29.227+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, 93%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EX1%3C/text%3E%3C/svg%3E)
xminer_gamer 11
1
Reputation point
commented 2020-09-14T01:58:08.297+00:00
Molly Lu
841
Reputation points Microsoft Vendor
2 answers
Accessing older version of Office
I have just bought a new lap top which has come with Windows 10. On my old lap top I had 'Office Home and Student' software - I still have the original CD and product key. Is there a way I can transfer the software from my old lap top to my new one?…
asked 2020-09-13T18:58:07.773+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, 51%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Charlotte Everitt
1
Reputation point
answered 2020-09-14T01:57:40.747+00:00
Teemo Tang
11,396
Reputation points
1 answer
VS-2019 Debugging MFC
I'm using MFC as a shared DLL in a program with an EXE and a number of my own DLLs, some of which use MFC. Using VS-2019, when I step through my program's DEBUG build, it won't step into the MFC library source code. How do I get it to do so? Dave
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,690 questions
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.
987 questions
asked 2020-09-11T13:03:50.997+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(51.2, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDW%3C/text%3E%3C/svg%3E)
David Webber
136
Reputation points
commented 2020-09-14T01:57:18.013+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,416
Reputation points
3 answers
SQL SERVER 2014 Enterprice Edition LICENSE
Can you please let me know, How many Sql Server Engine can be installed on different different machines while having one license?
asked 2020-09-10T12:19:15.66+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, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGK%3C/text%3E%3C/svg%3E)
GOUR Kundan
1
Reputation point
commented 2020-09-14T01:40:02.177+00:00
CathyJi-MSFT
21,866
Reputation points Microsoft Vendor
3 answers
If i remove Sitemap.xml file any impact on SharePoint internet site?
is /robots.txt & /sitemap.xml files will be security vulnerabilities for SharePoint Sites? what are the important considerations when using /robots.txt: can i remove /robots.txt,/sitemap.xml file from root directory of web application for…
![](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, 88%, 36%)' 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
cdc examples
can someone point to cdc examples please
asked 2020-09-10T22:51:19.123+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, 99%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NeophyteSQL
241
Reputation points
commented 2020-09-14T01:35:42.673+00:00
CathyJi-MSFT
21,866
Reputation points Microsoft Vendor
3 answers
Execution plan for specific stored procedure in SQL server
Team, Have SQL server 2008R2-wanted to know complete Query to get a execution plan from the cache for specific storedprocedure only.
asked 2020-09-09T11:39:29.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(60.8, 8%, 15%)' 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)
S_NO
21
Reputation points
commented 2020-09-14T01:32:08.133+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, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Cris Zhan-MSFT
6,626
Reputation points
1 answer
Can't list network adapters when creating an external virtual switch from Windows Admin Center
When I try to create a virtual switch from WAC and select external, it tries to load available network interfaces but it always fails with "Couldn't load the network adapters. Error: (1) RemoteException: No MSFT_NetIPInterface objects found with…
asked 2020-09-10T17:31:01.043+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, 57.99999999999999%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELS%3C/text%3E%3C/svg%3E)
Luke Schwager
1
Reputation point
answered 2020-09-14T01:22:22.093+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, 8%, 35%)' 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)
Daniel Zhou (Shanghai Wicresoft Co,.Ltd.)
256
Reputation points
2 answers
CMFCButton as a radio button
I have just discovered that the 'Feature Pack' class CMFCButton allows me to have an image and text on push-like radio button. (Normally this would require it to be owner-draw, and radio buttons don't have the owner-draw possibility, so I'm quite…
C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,690 questions
asked 2020-09-10T14:25:17.083+00:00
David Webber
136
Reputation points
commented 2020-09-14T01:19:31.577+00:00
Jeanine Zhang-MSFT
9,661
Reputation points Microsoft Vendor
1 answer
change data capture
we have some tables with change data capture enabled. for some reason, we had to disable cdc on the database now I have turned the cdc back on the tables, will there the data be sunchronized or will there be any lag in the data capture to the…
asked 2020-09-09T14:22:14.977+00:00
NeophyteSQL
241
Reputation points
commented 2020-09-14T01:18:08.813+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(108.80000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
AmeliaGu-MSFT
13,976
Reputation points Microsoft Vendor
asked 2020-09-08T03:12:58.847+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(92.8, 88%, 18%)' 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)
bogay chen
1
Reputation point
commented 2020-09-14T01:16:59.173+00:00
AmeliaGu-MSFT
13,976
Reputation points Microsoft Vendor
3 answers
Full text search index not getting generate on newly added data in SQL server express
I am using SQL server express edition, I have created full text search index on one a table having column datatype varbinary(max). But when new data added in that table full text index not populated on these newly added data. It is required to do restart…
asked 2020-09-07T09:35:39.067+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(217.60000000000002, 18%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Amruta Thorat
1
Reputation point
commented 2020-09-14T01:15:23.08+00:00
AmeliaGu-MSFT
13,976
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
SharePoint Online new experience doesn't show on default view of doc library
I have a document library on SharePoint Online. This library has more than 5000 documents. It was showing in the classic view before but due to some requirement I had to change the setting to modern view. What I found was that most of the filtered views…
asked 2020-09-02T11:25:14.253+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(108.80000000000001, 66%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
nikhil gokhale
121
Reputation points
commented 2020-09-14T01:13:42.44+00:00
ChelseaWu-MSFT
6,326
Reputation points
1 answer
Fail to update an existing SSIS package
Hi, We are running SQL Server 2016. Lately, I have already updated an existing package in a SSIS Solution as the request of sorting sequence has been changed. When I run the package in Data Tools, the output Flat File is correct. Then I Deploy…
asked 2020-09-08T06:42:42.047+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(147.20000000000002, 99%, 24%)' 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)
TonyJK
876
Reputation points
commented 2020-09-14T01:10:56.95+00:00
Cris Zhan-MSFT
6,626
Reputation points
1 answer
How can I stop my Dell XPS 8930 running 2004 rel of Windows 10 Pro from periodically deactivating.
I am running Windows 10 Pro on a Dell XPS 8930. I logon using my Microsoft account. The computer is on a peer to peer network with all machines runnign Windows 10 Pro and all logged in to Microsoft Account. Only this machine is having problems. Over…
asked 2020-09-11T02:05:14.67+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(12.8, 74%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Michael Schmieg
1
Reputation point
commented 2020-09-14T01:10:04.337+00:00
Dale Kudusi
3,236
Reputation points
4 answers
Official documentation showing RTM is simply the first release official release of the software version SQL Server Standard
Good day. I am in a bit of a pickle. A software vendor is claiming that the version of SQL Server that was installed was not SQL Server Standard because the vendor executes a select query for version "select @@version" and the resulting display…
asked 2020-09-10T12:17:48.95+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(284.8, 69%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Brandi Grow
1
Reputation point
commented 2020-09-14T01:10:02.04+00:00
Cris Zhan-MSFT
6,626
Reputation points