SQL Server on Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
371 questions
2 answers
Use SQL Server 2022 License Key to Install SQL Server 2019
Hi, I have installed SQL Server 2019 on our cloud EC2 Windows server machine using the SQL Server Evaluation Edition with a 180-day free trial. We intend to purchase the SQL Server 2022 Standard Edition key. Can we use this key to activate the SQL Server…
asked 2024-07-11T09:43:23.8833333+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(179.20000000000002, 89%, 27%)' 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)
surya kannan
0
Reputation points
commented 2024-07-18T10:11:31.1033333+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
3 answers
SQL Server 2019 installation Error
Hi Team, I installed sql server 2022 which was working well till last week. Today i got error while connecting to DB engine, so i tried to uninstall and reinstall the same. It did not work. SO i tried installing 2019 SQL Server and i am still getting the…
asked 2024-07-09T08:57:03.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(272, 99%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Aprameyan Guruvayurappan
0
Reputation points
commented 2024-07-18T10:10:41.41+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
2 answers
Unable to install SQL Server Exit Code (Decimal): -2068052294. There is a problem with this Windows Installer package. A program run as part of the setup did not finish as expected. Contact your support personnel or package vendor
I just bought this laptop to support my study for data analysis (Dell XPS 13 which run on Window 11). When I tried to both install SQL Express 2019 or 2022, I cannot install the application and the same error occurred as mentioned above. I have tried…
asked 2024-07-04T17:00:33.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(57.599999999999994, 6%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Minh Phuc Le
0
Reputation points
commented 2024-07-18T10:10:21.6166667+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
1 answer
sql server install not properly
TITLE: Microsoft SQL Server 2014 Setup The following error has occurred: SQL Server Setup has encountered an error when running a Windows Installer file. Windows Installer error message: An error occurred during the installation of assembly…
asked 2024-07-04T04:46:59.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(9.6, 57.99999999999999%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Ashutosh Olekar
0
Reputation points
commented 2024-07-18T10:09:46.5666667+00:00
MikeyQiaoMSFT-0444
1,755
Reputation points
1 answer
How to get a particular column from table and display in in label and not in the list in sqlite database in mvvm model
In MVVM model using async connection, I want to retrieve just one column from my async table to a label not to list. all sample I am seeing put all column in the list . I want only one mesa1 column to be displayed in a label.text. public async Task
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,325 questions
.NET MAUI
.NET MAUI
A Microsoft open-source framework for building native device applications spanning mobile, tablet, and desktop.
3,206 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,629 questions
Microsoft Q&A
Microsoft Q&A
Use this tag to share suggestions, feature requests, and bugs with the Microsoft Q&A team. The Microsoft Q&A team will evaluate your feedback on a regular basis and provide updates along the way.
689 questions
asked 2024-06-08T10:40:43.1+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, 90%, 22%)' 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)
Gbenga Banuso Odumosu
40
Reputation points
edited the question 2024-07-18T10:04:50.2533333+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, 16%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Rakesh Gurram
5,170
Reputation points Microsoft Vendor
3 answers
SSRS Image rotate when exported
If a report is rendered with an image (with an "External" source and a URL in the expression) it is OK, but when it is exported to PDF the image gets rotated -90º on the PDF file. This issue can be seen in several versions of SSRS and on…
asked 2023-01-04T16:50:37.55+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(16, 88%, 11%)' 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 Carvalho
6
Reputation points
commented 2024-07-18T09:47:09.82+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, 37%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELM%3C/text%3E%3C/svg%3E)
Leonardo Melo
0
Reputation points
0 answers
allowed_media_types not available as a column in the Seller Fill and Delivery Network report
Hello, I'm trying to get the "allowed_media_types" column to the "Seller Fill and Delivery Network report" according to thisp page…
asked 2024-07-18T09:22:46.59+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, 53%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
Adel NAHAL
0
Reputation points
asked 2024-07-18T09:22:46.59+00:00
Adel NAHAL
0
Reputation points
2 answers
unable to convert unique identifier
Hi Team, unable to convert this value as an unique identifier and getting null values SELECT try_convert(uniqueidentifier,''9UIC32D1-932-4V03-45E9-FGSGDASASDATY'')testid
asked 2024-06-12T07:17:37.1633333+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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vineet S
425
Reputation points
edited the question 2024-07-18T08:49:02.3533333+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, 4%, 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)
ShaktiSingh-MSFT
14,381
Reputation points Microsoft Employee
3 answers
SQL Permissions
Hi, I would like to understand different database level permissions like db_owner, db_datareader etc. I am trying to get the SQL commands allowed for the these roles. Also I would like to map users for these roles for developers, QA engineers etc For eg…
asked 2024-06-06T06:08:59.87+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(19.2, 54%, 11%)' 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)
Santhi Dhanuskodi
205
Reputation points
edited the question 2024-07-18T07:50:25.8366667+00:00
ShaktiSingh-MSFT
14,381
Reputation points Microsoft Employee
1 answer
%%LOCKRES%% - SQL Server - Row identifier causing Deadlocks
Hi Team, Recently I came across an issue where I am facing deadlocks in SQL Server databases (19.2.56.2) due to the internal hashing mechanism of the Row identifier virtual column - %%LOCKRES%% On analysis I find that the row identifier - %%LOCKRES%%…
asked 2024-06-02T06:24:20.88+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(227.2, 67%, 32%)' 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)
Govar1604
0
Reputation points
edited the question 2024-07-18T07:35:28.3533333+00:00
ShaktiSingh-MSFT
14,381
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
left and right join
Hi, table 1 Table 2 select A.* from table1a LEFT join table2 b on a.col1=b.col1 output: which is correct but on right join it shows above results how to calculate this join and how it will react on NULL and blank
asked 2024-06-23T11:34:41.0833333+00:00
Vineet S
425
Reputation points
edited the question 2024-07-18T07:23:47.01+00:00
ShaktiSingh-MSFT
14,381
Reputation points Microsoft Employee
1 answer
SSRS Format currency
Hello, In MS Report Builder, I try to get columns showing currency formatted like this 8.959.930,44€ When I configure the cell to "Currency", the result is : 8,959,930.44€ I tried to format te cell with this =Format(Sum(Fields!PRIXVENTE.Value),…
asked 2024-07-17T08:34:49.4933333+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, 60%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Philippe Desmarez
0
Reputation points
answered 2024-07-18T05:18:25.6666667+00:00
ZoeHui-MSFT
35,381
Reputation points
2 answers
How to read pdf,jpeg,gif document using tesseract OCR with C# asp.net MVC
Currently we have one page and this page contains one file-upload and one submit button, then the user will select a file from file-upload and submit the pdf,jpeg,gif file. Now my requirement is the user will upload pdf,jpeg,gif read the content of the…
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,411 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,325 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,629 questions
asked 2023-11-11T21:00:28.0866667+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(179.20000000000002, 39%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
coder rock
296
Reputation points
commented 2024-07-18T03:35:12.0433333+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, 84%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
winironteam
36
Reputation points
1 answer
One of the answers was accepted by the question author.
How to save the current SSRS Report Manager brand into a default brand package, or tweak just 1 setting
I just want to make one change on the current SSRS Report Manager branding. I don't want to replace everything. I just want to make the item listing's text font darker. One change. Otherwise, how do I download the current branding, or is the default…
asked 2024-07-16T14:02:55.9266667+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, 27%, 15%)' 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)
Smith, Mark H
20
Reputation points
commented 2024-07-18T02:24:16.8766667+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, 32%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMT%3C/text%3E%3C/svg%3E)
Michael Taylor
51,341
Reputation points
1 answer
SQL Server Always on High Availability License Requirments
Hello Experts, This conversation about reaching SQL high availability between two nodes and required licensing. We currently have one server (a node) running our production SQL server 2019 with the Enterprise edition core base, as seen below. Windows…
asked 2024-07-17T21:42:30.2366667+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, 64%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Raj Kumar A
6
Reputation points
commented 2024-07-18T01:57:08.41+00:00
LiHongMSFT-4306
25,651
Reputation points
2 answers
How to fix SSMS import excel issue for Dell/Windows?
Hi, Im starting to learn how to code in SQL and want to start creating my own projects. Im trying to import my own excel file (64 bit) to the SSMS server but am unable to do so because of this image in the attached. Can anyone help with a solution to…
asked 2024-07-17T13:35:41.4566667+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, 41%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZM%3C/text%3E%3C/svg%3E)
Zach Masessa
0
Reputation points
commented 2024-07-18T01:27:48.94+00:00
LiHongMSFT-4306
25,651
Reputation points
3 answers
KB5040948 security patch crashed SQL Server
KB5040948 security patch corrupted master database. Script level upgrade for database 'master' failed because upgrade step 'ssis_discovery' encountered error 35262, state 4, severity 10. It succeeded on standalone servers, but crashed on servers with…
![](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(288, 95%, 37%)' 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)
1 answer
One of the answers was accepted by the question author.
I created a SSIS package to fetch data from an API to store in the Data Warehouse. But I am getting the runtime error in my script task. I even used try/catch to figure out the error, but nothing is working.
Additionally, I am using a variable 'Token' which I declared in ReadWriteVariables. The error - at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at…
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
516 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,629 questions
asked 2024-07-13T01:33:03.4633333+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, 9%, 14%)' 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)
Manmohit Singh
20
Reputation points
accepted 2024-07-17T19:25:59.7033333+00:00
Manmohit Singh
20
Reputation points
2 answers
How to "restore" AdventureWorks .bak into Azure SQL Database
I'm trying to get the AdventureWorks dataset into a new Azure SQL Server Database, using the instructions here : https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms When I connect to the…
asked 2024-07-15T17:16:06.2433333+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' %3EAE%3C/text%3E%3C/svg%3E)
Amy Elmer
0
Reputation points
commented 2024-07-17T18:23:16.7566667+00:00
Oury Ba-MSFT
17,791
Reputation points Microsoft Employee
1 answer
Download link for different versions of SQL Server Connector (EKM.dll)
KB4470999 describes a breaking change when transitioning to SQL Server Connector 1.0.5. The solution described in the article ( https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/backup-restore/error-33111-restore-issues-sql-connector) …
asked 2024-07-17T09:34:37.9833333+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, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDA%3C/text%3E%3C/svg%3E)
Dan-Andrei Ganea
0
Reputation points
edited an answer 2024-07-17T17:34:40.7933333+00:00
Dan-Andrei Ganea
0
Reputation points