Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,692 questions
2 answers
One of the answers was accepted by the question author.
CreateTime bigint
We have an RDS deployment with a DB for the broker that manages it. There is a central DB and there when a user logs in in the Sessions table there is a column called CreateTime which is defined as a bigint: For example, I entered in today at…
asked 2020-11-17T14:58:30.76+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, 76%, 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)
reuvygroovy
781
Reputation points
commented 2020-11-18T11:26:22.257+00:00
Viorel
120.4K
Reputation points
1 answer
Microsoft AxtiveX Data Objects 2.8 Library COMExceptionからのメッセージがWindowsバージョンで違うことがある
ErrorCode=-2147217887[0x80040e21]のエラーが発生したときに、System.Runtime.InteropServices.COMExceptionのMessageで帰ってくるメッセージ内容がWindowsバージョンで違うことが判明しました。 WindowsXP、Windows7 : 複数ステップのOLE DB の操作でエラーが発生しました。各 OLE DB の状態の値を確認してください。作業は終了しませんでした。 Windows10 : 0x80040e21…
![](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, 6%, 18%)' 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
One of the answers was accepted by the question author.
Do SQL 2019 evaluation can be used for live enviroment?
My client asks me about using SQL 2019 evaluation in his live environment until it expired. Then he wants to buy a licence. I cannot find informations about it anywhere.
asked 2020-11-18T09:45:11.207+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, 95%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Daniel Kubiczek
41
Reputation points
accepted 2020-11-18T11:08:38.137+00:00
Daniel Kubiczek
41
Reputation points
2 answers
One of the answers was accepted by the question author.
Modern Team Site and Office 365 Group Team Site Pro & Cons
We are setting up Departmental Sites. Shall we go for Modern Team Site with Office Group or Modern Team Site with out Office 365 Groups. What are the Pros & Cons of each ? Please suggest.
asked 2020-11-04T13:41:28.69+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, 26%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sajith Gopalakrishnan Hema
1,046
Reputation points
accepted 2020-11-18T10:22:56.137+00:00
Sajith Gopalakrishnan Hema
1,046
Reputation points
1 answer
One of the answers was accepted by the question author.
Hide Site Page Menu from the Home Page of the Modern Team Site
How to hide Site Page Menu from the Home Page of the Modern Team Site ? The requiremen is only Site Collection Owner can create pages. Site Members or Site Contributors should not creare page.
asked 2020-11-11T08:50:58.82+00:00
Sajith Gopalakrishnan Hema
1,046
Reputation points
accepted 2020-11-18T10:21:57.51+00:00
Sajith Gopalakrishnan Hema
1,046
Reputation points
2 answers
Since VS 16.8, extension toolbars are hidden on code window load
Allright, so this is an odd one. Ever since upgrading to 16.8 (now 16.8.1) the two toolbars I have added for my extension (Supercharger) to the VS IDE are automatically hidden after loading the solution. I have been notified about this a little earlier…
![](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, 70%, 38%)' 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)
5 answers
One of the answers was accepted by the question author.
Notify user and close application before deploying new version
Hi! I deploy and update chrome browser with Endpoint Manager. I found out that when a new version is installed on a computer where chrome is in use, chrome causes problems afterwards. Is there a way to notify users to close chrome, before the…
asked 2020-11-04T12:47:57.823+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(262.40000000000003, 68%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sven van der Vecht
41
Reputation points
commented 2020-11-18T10:02:40.107+00:00
Amandayou-MSFT
11,141
Reputation points
1 answer
User last login computer object
How to get a user last login computer object using power shell from windows server 2019. Thanks
asked 2020-11-18T05:03:54.057+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, 45%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
krishna das
6
Reputation points
answered 2020-11-18T09:59:39.747+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, 94%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIX%3C/text%3E%3C/svg%3E)
Ian Xue-MSFT
40,591
Reputation points Microsoft External Staff
1 answer
Problem with following Sharepoint site
Hi, guys! I have a problem with following sharepoint site. When I am clicking on following (star at the top right corner), site will not followed. In DevTools-> Network I got status code : 500 Internal Server Error. Request URL:…
asked 2020-11-09T21:25:28.397+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, 35%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EOM%3C/text%3E%3C/svg%3E)
Oleksii Marchenko
1
Reputation point
commented 2020-11-18T09:51:57.867+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(67.2, 7.000000000000001%, 16%)' 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)
MichaelHan-MSFT
18,046
Reputation points
1 answer
asked 2020-11-17T16:06:10.383+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(169.60000000000002, 57.00000000000001%, 26%)' 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
Reputation point
answered 2020-11-18T09:42:52.083+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(28.799999999999997, 57.99999999999999%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECF%3C/text%3E%3C/svg%3E)
Carl Fan
6,876
Reputation points
1 answer
One of the answers was accepted by the question author.
Child proces not started immediately
Hi, I have a scenario with a parent flow that starts a child flow. In most cases the child flow is started directly, but some times it occurs that the action in the parent flow waits for 3 - 12 minutes before it starts the child flow. The child flow runs…
asked 2020-11-17T08:03:46.78+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(38.4, 22%, 13%)' 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)
Dave Godschalx
96
Reputation points
accepted 2020-11-18T09:40:51.503+00:00
Dave Godschalx
96
Reputation points
2 answers
What configurations should I set to support avx512 instructions like _mm512_setr_epi32 in Debug mode?
I wrote a cpp file including avx512 instructions with VS2019, the complication is complete with no error, but when I tried to debug, an error of "Illegal Instruction" came out near the _mm512_setr_epi32, as well as the other instructions. So I…
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,033 questions
asked 2020-11-14T08:38:19.307+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, 70%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
smith tony
1
Reputation point
commented 2020-11-18T09:37:41.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(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
3 answers
Rename Users
Hi All, We need to rename around 100 user accounts on our Domain. Basically we need to change from abc001 to xyz001. We need to ensure the users keep all their profile settings locally and on our file server so they are able to reach back to their…
asked 2020-11-12T11:41:26.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(83.2, 73%, 18%)' 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)
czql5v
146
Reputation points
answered 2020-11-18T09:36:55.687+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(281.6, 28.999999999999996%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVW%3C/text%3E%3C/svg%3E)
Vicky Wang
2,736
Reputation points
4 answers
Upgrading Child Domain: Running Adprep in 2012r2
Hi, In order to upgrade a domain to 2012r2, one has to run adprep. Adprep has to have connection to schema fsmo and other roles (infra/rid ?), and needs 3 types of permissions when we run /forestprep, 1 when running /domainprep. Now, how does this…
asked 2020-11-12T15:16:19.147+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, 52%, 37%)' 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)
InfoTechdude
161
Reputation points
answered 2020-11-18T09:36:45.547+00:00
Vicky Wang
2,736
Reputation points
2 answers
Active Directory Quotas in both Domain and Configuration partition
Hi, I noticed so called Active Directory Quotas are accessible from BOTH domain and configuration partitions...Can somebody explain this plus implications on both? There is great article on the topic here "Active Directory Quotas"…
asked 2020-11-13T16:26:25.19+00:00
InfoTechdude
161
Reputation points
answered 2020-11-18T09:36:03.627+00:00
Vicky Wang
2,736
Reputation points
2 answers
After join domain in Windows 10 Search and Startbar not Working
Dear Tech Net Support I am using Windows Server 2019 Standard Edition, Which is activated by licence key. After join domain one Computer which is installed windows 10 pro but Search and Start Bar not working. Plz give me a solution.
asked 2020-11-15T12:07:26.787+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, 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' %3EAB%3C/text%3E%3C/svg%3E)
Alfala bulbula
1
Reputation point
answered 2020-11-18T09:35:37.323+00:00
Vicky Wang
2,736
Reputation points
3 answers
One of the answers was accepted by the question author.
Old Mailboxes still exists on Database after move-request
Hello All, I have exchange 2013 CU7, Disk drive is almost full "drive E" and i moved around 750 mailboxes (300 GB size) to another database on different drive "drive F" and they moved successfully, the issue is the drive size still…
asked 2020-11-06T10:38:42.143+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(73.60000000000001, 88%, 17%)' 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)
Hammoudeh
346
Reputation points
commented 2020-11-18T09:35:23.347+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,381
Reputation points Microsoft Employee
2 answers
Any point in installing high available RODCs?
Hi, We know RODC is "special" kind of domain controller, but is there any reason to install highly available RODCs? How to do it- clusters/nlb? Any deployment tips/tricks/gotchas? Thank you!
asked 2020-11-16T16:51:39.987+00:00
InfoTechdude
161
Reputation points
answered 2020-11-18T09:32:58.867+00:00
Vicky Wang
2,736
Reputation points
1 answer
Teams fails to install on Fedora 32
If I try to install the current Teams (1.3.0025560-1_x86_64) rpm in Fedora Linux 32 using the "Discover" software manager, I receive an error message "Bad GPG signature" and the installation fails. Is there a way round this? Thanks,…
asked 2020-11-02T18:00:38.453+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, 17%, 28%)' 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)
Marchant, Andrew
1
Reputation point
commented 2020-11-18T09:29:17.477+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
57,591
Reputation points Microsoft External Staff
2 answers
Visual Studio 16.8 Not Installing .NET 5
Many of us have probably heard about the release of Visual Studio 2019 16.8 & .NET 5, which were released 11/10/2020. However, even though the Visual Studio Installer updated my Visual Studio 2019 to 16.8 (actually, 18.8.1 now), it did not update…
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,112 questions
asked 2020-11-12T19:40:38.713+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, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nathan Sokalski
4,111
Reputation points
commented 2020-11-18T09:27:03.08+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
30,926
Reputation points Microsoft External Staff