SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,057 questions
1 answer
Why the same issue is been addressing in both KB
KB5042749: This KB article addresses the CVE-2024-37341 vulnerability by fixing a specific issue in the affected software. The exact nature of the fix can include code changes to eliminate the vulnerability, such as patching a security hole or updating…
asked 2024-11-21T06:28:55.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(316.8, 60%, 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)
Balakrishna
0
Reputation points Microsoft Vendor
answered 2024-11-21T07:16:43.6166667+00:00
ZoeHui-MSFT
37,991
Reputation points
1 answer
Why the same issue is been addressing in both KB
KB5042749: This KB article addresses the CVE-2024-37341 vulnerability by fixing a specific issue in the affected software. The exact nature of the fix can include code changes to eliminate the vulnerability, such as patching a security hole or updating…
asked 2024-11-21T06:28:55.12+00:00
Balakrishna
0
Reputation points Microsoft Vendor
answered 2024-11-21T07:16:43.6166667+00:00
ZoeHui-MSFT
37,991
Reputation points
4 answers
Where and how do I add the SQL license key when SQL server reporting services expire
Our SQL 2022 reporting services stopped working. We figured out it had expired, and I must add the SQL license key. I need to know the process of adding the license key to SQL reporting services.
asked 2024-11-20T21:34:40.0933333+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, 57.00000000000001%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Dennis Huston
0
Reputation points
answered 2024-11-21T07:12:24.51+00:00
ZoeHui-MSFT
37,991
Reputation points
4 answers
Where and how do I add the SQL license key when SQL server reporting services expire
Our SQL 2022 reporting services stopped working. We figured out it had expired, and I must add the SQL license key. I need to know the process of adding the license key to SQL reporting services.
asked 2024-11-20T21:34:40.0933333+00:00
Dennis Huston
0
Reputation points
answered 2024-11-21T07:12:24.51+00:00
ZoeHui-MSFT
37,991
Reputation points
2 answers
Error -2054422515 installing SQL Server Express using a .net desktop application
We use a 3rd party application to install/upgrade sql server on client PC. But it is throwing an exception stated above.Detail.txt What I am trying: Upgrade SQL Server from 2012 to 2016 SP3 using 3rd party installer. Here I am attaching the Detail log…
![](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(96, 8%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
0 answers
Upload to Azure Migrate - Error AADSTS16000
I am using the latest version of Data Migration Assistant. Once I finish the assessment of a local SQL Server instance and try to upload the assessment to Azure migrate, I get this error after signing in to my Azure account. I can log into the portal and…
asked 2024-11-15T06:26:16.32+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, 62%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAC%3C/text%3E%3C/svg%3E)
Agam Chauhan
0
Reputation points
commented 2024-11-21T05:49:05.9733333+00:00
Agam Chauhan
0
Reputation points
1 answer
Migration_Azure
I have migrated the data from SQL server to Azure SQL Database. The size on the SQL dataset was around 250 mb but on migration when i checked the size it is around 500 mb. I would like to know the reason and how can i cross check that
asked 2024-11-21T04:04:53.5+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(230.39999999999998, 10%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
Prateek Hiremath
0
Reputation points
edited an answer 2024-11-21T04:36:40.3366667+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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
3,505
Reputation points Microsoft Vendor
0 answers
Using Database Mail to Send Attachments Local to SQL Server
Hi All, Running SQL Server Express 2017. We have a requirement to send emails with file attachments using database mail. The files have been placed in a directory located on the same server as the SQL server. The SQL service has read-only access to the…
![](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, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV7%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(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' %3EA%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
partition by
Hi, how to add partition by in below table where there is no date key or duration..please give example here is example of sample data customerid - 1 product - grains productcategory-rice sales- 1000
![](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)
1 answer
ADO.NET connection failure to Azure Database from VS 2022 SSIS Package running against SQL Server 2022 using Microsoft SQLClient Data Provider
I have a SSIS package running on SQL Server 2022 in VS2022 that connects to a 3rd party Azure database as a source with ADO.NET using Microsoft Entra Password that has been running successfully for a few years. However, recently I needed to make…
asked 2024-11-12T13:59:46.06+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, 86%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETT%3C/text%3E%3C/svg%3E)
Teresa Thomas
1
Reputation point
commented 2024-11-21T01:57:38.74+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, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
890
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
cluster Index
if we have large amount of data and customer id would be unique key and product and product and price and billons of data how cluster Index is doing in memory operation? and helpful would be non cluster Index here is example of sample data customerid…
1 answer
System.Data.Entity.Infrastructure.DbUpdateConcurrencyException HResult=0x80131501 Message=Store update, insert, or delete statement affected an unexpected number of rows (0).
using System; using System.Collections.Generic; using System.Data; using System.Data.Entity; using System.Data.Entity.Infrastructure; using System.IO; using System.Linq; using System.Net; using System.Web; using System.Web.Mvc; using…
Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
754 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,942 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.
14,057 questions
asked 2024-11-18T17:56:30.2966667+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(316.8, 3%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Phạm Thanh Lam
0
Reputation points
commented 2024-11-21T01:03:25.0833333+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, 62%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
Hongrui Yu-MSFT
2,865
Reputation points Microsoft Vendor
1 answer
How to install Reporting Services in an Azure SQL VM
Hello, I have an Azure SQL VM and i need to install SQL Reporting Services. I downloaded the setup but it asking for a serial number that i don't have. How do i know the serial number of SQL to insert in the instalation process? Or there is another way…
asked 2023-11-21T15:33:23.5+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, 21%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sérgio Raposo
0
Reputation points
edited a comment 2024-11-20T23:29:38.1833333+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(265.6, 28.000000000000004%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDM%3C/text%3E%3C/svg%3E)
Daniel Montero
0
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS server 2022 connecting to SQL Server 2019 - Jobs are failing
Good day, We have many SSIS packages developed and stored in the file system. We're running them using dtexec utility like this dtexec.exe /FILE E:\SSIS_ROOT\VA\package\exec_usp_File_Extract_Setup.dtsx /SET…
asked 2024-11-15T18:33:44.1866667+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(137.6, 31%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Naomi Nosonovsky
7,886
Reputation points
commented 2024-11-20T22:44:12.5566667+00:00
Naomi Nosonovsky
7,886
Reputation points
2 answers
One of the answers was accepted by the question author.
SSIS server 2022 connecting to SQL Server 2019 - Jobs are failing
Good day, We have many SSIS packages developed and stored in the file system. We're running them using dtexec utility like this dtexec.exe /FILE E:\SSIS_ROOT\VA\package\exec_usp_File_Extract_Setup.dtsx /SET…
asked 2024-11-15T18:33:44.1866667+00:00
Naomi Nosonovsky
7,886
Reputation points
commented 2024-11-20T22:44:12.5566667+00:00
Naomi Nosonovsky
7,886
Reputation points
0 answers
ODBC DSN (SQL Server 18 driver) can't connect to Azure hosted database using ActiveDirectoryServicePrincipal
I have an ODBC DSN set up using SQL Server ODBC driver 2018.184.01.01. I can connect to my Azure hosted database using this DSN in Python, with the DSN, UID, PWD in the connection string. However attempting the same connection string using the C language…
asked 2024-11-20T21:48:56.5366667+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, 41%, 31%)' 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)
Michael Aiello
0
Reputation points
commented 2024-11-20T22:07:04.1466667+00:00
Erland Sommarskog
112.8K
Reputation points MVP
4 answers
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…
asked 2024-05-24T00:46:20.3866667+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(198.4, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Michael F. Assis
25
Reputation points
commented 2024-11-20T21:56:52.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(256, 64%, 34%)' 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)
WebLuke
0
Reputation points
1 answer
How to create DB for Reservation
I have a reservation - SQL Database Single/Elastic Pool General Purpose - Compute Gen5 Could you please share with me instructions on how to create DB suitable for my reservation As I understand if I create DB correctly it will link to the…
asked 2024-11-20T18:06:39.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(25.6, 79%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
Easy Drive
0
Reputation points
edited the question 2024-11-20T21:22:58.1433333+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, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VarunTha
9,420
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
SQL Server Log File is Consuming up to 600GB in my C drive.
SQL Server Log File is Consuming up to 600GB in my C drive. How do I remove or shrink the log file?
![](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, 20%, 18%)' 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)
3 answers
Convert SQl query to Linq query in c#
Below is my full sql query need to convert into linq query delcare @personId int=12345 select distinct p.fName, p.lName, p.personId, p.assignedId,0 doId,…
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,057 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.
11,048 questions
asked 2024-11-19T19:16:20.94+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
376
Reputation points
commented 2024-11-20T15:51:43.32+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, 61%, 30%)' 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)
Bruce (SqlWork.com)
67,176
Reputation points