SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,021 questions
1 answer
SQL Server Express 2014 Installation error
Hello everyone, The problem I describe doesn't happen directly to me, but to a user of my software who asked me for help. Therefore I don't have direct access to the affected machine. I haven't found any solution for this specific problem on the…
asked 2021-01-14T10:19:20.49+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(44.800000000000004, 80%, 14%)' 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)
adampp
1
Reputation point
answered 2021-01-15T07:26:08.51+00:00
CathyJi-MSFT
22,306
Reputation points Microsoft Vendor
2 answers
Retrieve 'Source name' and/or 'Sql statement' for all tables in tabular model?
Hi experts, I am trying to get a query to retrieve all the sources for all the tables in my tabular model... Specifically I want to get this sql code: And if its not a query, and its a "full consumption" of a table/view, I…
asked 2021-01-14T10:06:45.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(105.60000000000001, 51%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
Fra1978
126
Reputation points
answered 2021-01-15T07:23:41.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(252.8, 9%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELY%3C/text%3E%3C/svg%3E)
Lukas Yu -MSFT
5,821
Reputation points
1 answer
Is it true microsoft does not offer suppot for mover tool
I just verified mover was acquired by Microsoft, and am trying to use the mover tool to transfer files from SharePoint online to another SharePoint online tenant, but the tools seems not to work as expected hence i opened a ticket for the case and the…
asked 2021-01-14T12:40:45.963+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, 19%, 34%)' 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)
Bernard Muendi
1
Reputation point
answered 2021-01-15T07:22:19.433+00:00
Li Zhang_MSFT
1,566
Reputation points
1 answer
Visual Studio Enterprise 2017 does not admit the entry of the license.
I have an Enterprise version of Visual Studio 2017 installed, the institution has an Enterprise Licensing Agreement with Microsoft. The issue is that it tells me that the license has expired that I must register a valid code. My support partner has…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
5,209 questions
asked 2021-01-13T23:54:56.297+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(246.4, 57.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Rodolfo Desanti Aguero
1
Reputation point
commented 2021-01-15T07:15:46.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(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,841
Reputation points Microsoft Vendor
2 answers
How to stop sharepoint from downloading to a local folder
Hello everyone. I'm trying to get sharepoint to open in a web app rather than downloading to a local folder on a user's computer. It only seems to do it occasionally and only in Chrome (that I know of). My boss is requiring the document have check in/out…
asked 2021-01-08T22:32:27.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(214.4, 74%, 30%)' 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)
Mika Slater
1
Reputation point
commented 2021-01-15T07:10:38.273+00:00
Li Zhang_MSFT
1,566
Reputation points
1 answer
Skype for Business on Prem: How to Limit Enterprise Calling to 1 Minute for Certain users.
Hi, Is there any way where we can set policy or limit the enterprise calling for certain user to 1 minute. we have enabled enterprise voice policy for most of the users, however for certain department we want to limit to 1 minute one call only. i am…
asked 2021-01-07T07:30:51.763+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(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' %3EG%3C/text%3E%3C/svg%3E)
Greenman
1
Reputation point
commented 2021-01-15T07:07:50.073+00:00
Sharon Zhao-MSFT
25,106
Reputation points Microsoft Vendor
2 answers
Sharepoint 2016 Central Administration base type not allowed
Hi All, I am looking for some help. After upgrading a sharepoint farm to the latest CU Dec 2020, I have been unable to open the Central Administration Page. The following error occurs: Sorry, something went wrong The base type…
![](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' %3ED%3C/text%3E%3C/svg%3E)
1 answer
C# insert column from nested json string to column
I'm using a c# .net project with tht sqlcommand listed below to get the person government id's out of the json string and insert to a column. The sql command inserts a list. How to I get the idValue to insert into the column? sqlcommand …
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.
11,032 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,657 questions
asked 2020-12-18T15:26:57.533+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, 57.00000000000001%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
ERPISE
1
Reputation point
answered 2021-01-15T07:04:00.613+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(115.19999999999999, 4%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Timon Yang-MSFT
9,591
Reputation points
4 answers
SQL Server various Lock Mode
Lock mode considers various lock types that can be applied to a resource that has to be locked: Exclusive (X) Shared (S) Update (U) Intent (I) Schema (Sch) Bulk update (BU) when i execute this query then i saw IX on…
asked 2021-01-11T18:19:09.63+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
commented 2021-01-15T07:03:59.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(236.8, 76%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEM%3C/text%3E%3C/svg%3E)
EchoLiu-MSFT
14,581
Reputation points
6 answers
SQL prefix wildcard search on very large table
Hi, I am looking for the best practice in finding text with a prefi wildcard within a very large table. To give you an idea, the product table has approx. 2 million products. It has a cluster as non-cluster indexes. Example of possible values: …
asked 2021-01-12T09:31:55.233+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(89.60000000000001, 24%, 18%)' 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)
Phyxsius
21
Reputation points
commented 2021-01-15T07:03:00.153+00:00
EchoLiu-MSFT
14,581
Reputation points
1 answer
how to open template selection option page from sharepoint online SitePages library
Hi, When i try to create new page from home page of sharepoint online site, it is opening template selection page for me, but when i am trying to create page directly from SitePages it is not asking for may template. Can we create this functionality…
asked 2021-01-07T15:35:06.377+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(89.60000000000001, 59%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Dinesh Negi
1
Reputation point
commented 2021-01-15T07:02:46.85+00:00
Li Zhang_MSFT
1,566
Reputation points
4 answers
SQL time compare
hi , so i have a trigger which executes job at 12 am due to some update on source table that i need to avoid. i need to check if current date time > 6 am , then only it will check for other conditions and execute job.
asked 2021-01-12T21:10:44.12+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, 92%, 30%)' 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)
coool sweet
61
Reputation points
commented 2021-01-15T07:01:02.26+00:00
EchoLiu-MSFT
14,581
Reputation points
1 answer
How to delete a user "correctly" in AD hybrid mode properly with exchange online account
Hello All: We are currently running AzureADConnect with our on premAD and we also have Exchange hybrid mode configured. I need to rewrite some scripts to delete user with these new settings in place. What is the "proper" order to delete a user…
asked 2021-01-09T05:29:38.003+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(118.4, 28.000000000000004%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEL%3C/text%3E%3C/svg%3E)
Edmund Lee
1
Reputation point
commented 2021-01-15T07:00:44.497+00:00
SAGOHIL-MSFT
456
Reputation points Microsoft Employee
1 answer
SSRS Text format
Hi, I'm currently converting Access report into SSRS reports and one of my issue is that they are creating txt file with some of the reports. As their is no export to text file in SSRS I'm exporting to CVS with the txt file which works great but I need…
asked 2021-01-14T16:56:53.157+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, 49%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJF%3C/text%3E%3C/svg%3E)
Jean-François Handfield
101
Reputation points
answered 2021-01-15T06:58:07.387+00:00
ZoeHui-MSFT
37,746
Reputation points
0 answers
Problein in deploy to IOS
Hello Team I have an app, that is working great, but in ios I get this error /Library/Frameworks/Mono.framework/External/xbuild/Xamarin/iOS/Xamarin.iOS.Common.targets(3,3): Error: System.IO.DirectoryNotFoundException: Could not find a part of the…
asked 2021-01-14T18:19:09.667+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, 5%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEG%3C/text%3E%3C/svg%3E)
Eduardo Gomez
3,426
Reputation points
commented 2021-01-15T06:57:45.44+00:00
Cole Xia (Shanghai Wicresoft Co,.Ltd.)
6,751
Reputation points
1 answer
Regarding threat monitoring in Azure
Hi, How to perform threat monitoring for Azure resources like Azure Firewall/NSG. What is the best way this can be done? Is there a way to automate this monitoring process?
asked 2021-01-05T15:54:58.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(224.00000000000003, 67%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Ananya Sarkar
311
Reputation points
answered 2021-01-15T06:57:40.783+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, 39%, 34%)' 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)
SwathiDhanwada-MSFT
18,776
Reputation points
3 answers
Software Center Appication starts installing then goes back to available SCCM
Hello, I am having some issues with an application that when I click install moves to installing and after time out just shows available again. Log is attached. Any help or thoughts would be really appreciated! I did try deleting the…
asked 2021-01-12T22:15:12.92+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(0, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETF%3C/text%3E%3C/svg%3E)
Thomas Faherty
151
Reputation points
commented 2021-01-15T06:49:41.55+00:00
AllenLiu-MSFT
45,611
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Windows clustered file Server 2008 R2 problems accessing to shared folders.
I will try to describe a problem as detail as I can. The problem is that workstations that are part of System911.com windows domain are access to shared folders on file server. File server are part of another windows domain sovi.sk. All machines…
asked 2020-11-18T13:42:57.377+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, 51%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESE%3C/text%3E%3C/svg%3E)
Sovi Engineer
96
Reputation points
accepted 2021-01-15T06:46:04.67+00:00
Sovi Engineer
96
Reputation points
0 answers
Trying to ingest iot data into blockchain with sample app refrigerated Transportation. the logicapp successfully sends data to blockchain workbench Servicebus , but the smart contract not seeing the transaction
Trying to ingest iot data into blockchain with sample app refrigerated Transportation. the logicapp successfully sends data to blockchain workbench Servicebus , but the smart contract app not seeing the transaction
asked 2020-12-31T19:44:31.293+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, 51%, 23%)' 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)
Raghavan Sampathkumar
1
Reputation point
commented 2021-01-15T06:44:54.68+00:00
SanaCMSFT-8922
301
Reputation points
3 answers
One of the answers was accepted by the question author.
How to get list of SQL servers on the network
I want to know the list of SQL services installed on the network. Note: On some of the servers browser service is disabled state due to which I am unable to get information using the powershell scripts. Please advise if there is any work around which…
asked 2020-12-16T14:59:35.507+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(272, 95%, 36%)' 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)
Kranthi DBA
221
Reputation points
accepted 2021-01-15T06:34:01.027+00:00
Kranthi DBA
221
Reputation points