18,507 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

Unable to install SQL Server. Exit code (Decimal): -2147467259

I tried to install it, and then after a few minutes i get this error: Unable to install SQL Server. Exit code (Decimal): -2147467259 and those is logs files. Summary_DESKTOP-GDTULCG_20240703_221010.txt Detail.txt

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,210 questions
asked 2024-07-03T19:36:17.05+00:00
Ali Azzam 0 Reputation points
commented 2024-07-07T07:44:40.92+00:00
Erland Sommarskog 105.8K Reputation points MVP
1 answer One of the answers was accepted by the question author.

how to see the effect of Enable Scalar UDF Inlining in query plan

hi, i read this artical https://learn.microsoft.com/en-us/sql/relational-databases/user-defined-functions/scalar-udf-inlining?view=sql-server-ver16 but could not reproduce  the following results , is ther any query or example on interent where i can see…

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,210 questions
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
63 questions
asked 2024-07-06T05:50:03.5633333+00:00
Rajesh Kumar Yadav 20 Reputation points
accepted 2024-07-07T07:08:13.7733333+00:00
Rajesh Kumar Yadav 20 Reputation points
2 answers

How to import images from folder files to SQL server?How can we see full image on SQL server.

How to import images from folder files to SQL server?How can we see full image on SQL server.

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,210 questions
asked 2024-07-06T12:38:50.8666667+00:00
Anandhswarupp 20 Reputation points
edited an answer 2024-07-07T04:56:10.9633333+00:00
Olaf Helper 42,841 Reputation points
0 answers

Whilst installing SQLServer, Comes up with error "Unable to install SQL Server (setup.exe)... Exit code (decimal): -2068119551... The target principal name is incorrect. Cannot generate SSPI context.

SQLServer_ERRORLOG_2024-07-06T21.00.28.txt Log file. So is there any fix to this issue? I'm guessing it's something on my end.

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,210 questions
asked 2024-07-06T20:08:42.8633333+00:00
RBobz14 0 Reputation points
commented 2024-07-06T21:52:13.63+00:00
Erland Sommarskog 105.8K Reputation points MVP
0 answers

Unable to install SQL Server. Exit code (Decimal): -2068052377

I tried to install it, and then after a few minutes I got this error: Unable to install SQL Server. Exit code (Decimal): -2068052377and those are logs files. Detail.txt Summary_DESKTOP-GDTULCG_20240706_224821.txt

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,210 questions
asked 2024-07-06T19:50:33.47+00:00
Ali Azzam 0 Reputation points
edited a comment 2024-07-06T21:38:51.54+00:00
Erland Sommarskog 105.8K Reputation points MVP
1 answer

Oracle to SQL data migration is taking too much time | Need Help

Hello Experts, We need your help to minimize time for data migration from Oracle to SQL. Example, there exist a table in Oracle with 100 Million records and its been three days and session is still executing in SQL server What we have done ? Created a…

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,210 questions
asked 2024-07-06T04:43:31.4+00:00
Mohsin M Patel 0 Reputation points
commented 2024-07-06T21:33:26.6833333+00:00
Erland Sommarskog 105.8K Reputation points MVP
2 answers

SSRS 2022 - Subscription Error when Scheduling to Run each Month on 10th 20th or 30th (Error: Invalid Days)

Unable to create/modify SSRS 2022 report subscription to run each month on the 10th, 20th or 30th. Example Schedule settings (See screenshot below): Schedule: Month Months: All months selected On calendar day(s): 20 (But is the same result if 10 or…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,855 questions
asked 2024-02-15T04:43:13.83+00:00
Gui Xiong (South Western Sydney LHD) 5 Reputation points
commented 2024-07-06T13:25:52.68+00:00
Vig Vaidianathan 0 Reputation points
0 answers

unique column in table

HI, merging table1 in table2 merge into table2 using table1 on table.col1=table2.col1 when not match then insert how to add unique column with auto increament number and not null in table like uniquenumner; Name;' 001 Test1 003 …

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,210 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,592 questions
asked 2024-07-06T02:21:59.06+00:00
Vineet S 285 Reputation points
commented 2024-07-06T08:37:22.5733333+00:00
Erland Sommarskog 105.8K Reputation points MVP
0 answers

Connectivity from AKS Cluster to Self hosted sql vm from different Vnet

I have a service deployed in Private AKS cluster and database is SQL server in Azure VM, both AKS and SQL server are in different VNET. We can't go with VNET peering since there is IP range conflicts between vnets. Creating private endpoint also won't…

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,268 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,210 questions
Azure Kubernetes Service (AKS)
Azure Kubernetes Service (AKS)
An Azure service that provides serverless Kubernetes, an integrated continuous integration and continuous delivery experience, and enterprise-grade security and governance.
1,964 questions
asked 2024-07-06T04:27:06.01+00:00
Gnanasoundari 25 Reputation points
commented 2024-07-06T08:34:20.5833333+00:00
Erland Sommarskog 105.8K Reputation points MVP
2 answers

Create a report in SCCM to query machines without a specific software

I am needing to create a report to all machines WITHOUT Microsoft Edge installed. I am fairly novice with SCCM and not a SQL guy. I'd like to use the creation wizard in SCCM and report builder, but I get lost. Ideally we would like to be able to…

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,855 questions
Microsoft Configuration Manager
asked 2022-05-03T15:53:15.117+00:00
Kai Lantiegne 1 Reputation point
commented 2024-07-06T02:06:05.34+00:00
Ryan 0 Reputation points
1 answer

SQL Server Backup in Azure VMs

The Azure backup for SQL VM doesn't allow the selection of multiple databases to be restored through the Azure portal. E.g. if I need to restore 10 databases which have already been backup up by Azure backup, I need to go through the restore process 10…

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,174 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,478 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,210 questions
asked 2024-07-05T16:58:17.4633333+00:00
Onetrowon Emmanuel 0 Reputation points
commented 2024-07-06T01:54:58.5366667+00:00
Onetrowon Emmanuel 0 Reputation points
4 answers

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install SQL Server 2022 on Ubuntu Server 24.04 LTS. I tried to use Microsoft SQL Server 2022 from the Ubuntu 22.04 repository, but I couldn't run the service correctly. I'm done with this state of service (see printout).Is…

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,210 questions
asked 2024-06-09T22:09:54.9333333+00:00
Eghost 0 Reputation points
edited an answer 2024-07-06T00:48:41.32+00:00
PhiHung Bach 0 Reputation points
3 answers One of the answers was accepted by the question author.

When i try to connect MSSQLSERVER server it doesn't appear and only the SQLEXPRESS server appears.

I've installed SQL2022-SSEI-Dev then installed the SQL2022-SSEI-Expr then the SSMS-Setup-ENU when i open the SSMS to connect a server i cant find DEV server and only the Express server appears. What's wrong and how to fix?

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,210 questions
SQL Server Training
SQL Server Training
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Training: Instruction to develop new skills.
7 questions
asked 2024-07-05T01:05:50.22+00:00
ABDELHALEEM MOHAMMED 20 Reputation points
commented 2024-07-05T23:48:48.9033333+00:00
ABDELHALEEM MOHAMMED 20 Reputation points
0 answers

SSPI Error when connecting from Intune Managed AVD to SQL Host using SSMS

Hi All, I have a problem when trying to connect to a SQL Server using SSMS via an Entra joined and Intune Managed AVD. The SQL host is in an AD DS where accounts are synced to Entra AD. The error I get is : The target principal name is incorrect. …

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,210 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,365 questions
asked 2024-07-05T12:59:15.8366667+00:00
Jason P 116 Reputation points
edited the question 2024-07-05T22:31:08.68+00:00
kobulloc-MSFT 25,811 Reputation points Microsoft Employee
1 answer

SQL Server 2022 Kurulum Hatası

SQL Server 2022 Detail.txt Summary_DESKTOP-UN0800B_20240602_203435.txt Summary.txt Exit Code (Decimal): -2068052377 Error Description: Geçersiz komut satırı bağımsız değişkeni (Invalid command line argumant)

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,210 questions
asked 2024-06-02T17:55:45.07+00:00
Kadir Veysel SAYAR 5 Reputation points
commented 2024-07-05T19:00:25.7633333+00:00
beyza güven 0 Reputation points
3 answers

SQL Bulk Copy failed

SQL Bulk Copy failed due to receive an invalid column length from the bcp client. I am getting this error while copying data from adls to sqlserver. I am copying a csv file. I checked the length of each and every column. Destination has more length when…

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,210 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,023 questions
asked 2022-09-26T05:37:18.833+00:00
KEERTHANA JAYADEVAN 66 Reputation points
answered 2024-07-05T18:15:52.4+00:00
ravi555 0 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Server connection timeout after idle

I just set up on Azure a SQL Server (free tier) connecting to an .NET Core web app also on Azure. After 20 minutes the database goes idle. The first attempted connection to the database fails with the call stack below. The subsequent call works…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,345 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,210 questions
asked 2024-07-04T17:35:16.3733333+00:00
Patricia Davidson 20 Reputation points
commented 2024-07-05T16:37:31.1233333+00:00
Patricia Davidson 20 Reputation points
3 answers One of the answers was accepted by the question author.

Installing MSSQL on Surface Laptop 7 with Snapdragon

I know there's been questions in the past when the ARM based MacBooks launched but now that Microsoft is shipping more ARM devices with the new Surface Pro and Surface Laptop is there any updated way to install and run MSSQL? Is Docker still the best…

Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
5,000 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,210 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
8,797 questions
asked 2024-07-03T15:08:36.85+00:00
CandidKilsborne 20 Reputation points
commented 2024-07-05T16:11:26.88+00:00
Bruce (SqlWork.com) 60,376 Reputation points
1 answer

Cannot create and start Extended Events session in Azure SQL Managed Instance

Hello, I am trying to create an Extended Events session in Azure SQL Managed Instance. First I am trying to use SSMS GUI: Extended Events -> Sessions -> New Session... Add "error_reported" event, configure fields, select Data Storage as…

Azure SQL Database
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,210 questions
asked 2024-06-24T15:08:42.51+00:00
Aleksey Vitsko 20 Reputation points
commented 2024-07-05T15:27:27.5966667+00:00
Aleksey Vitsko 20 Reputation points
1 answer

I am trying to access SQL Server hosted in Azure VM from Azure function app

I am trying to access SQL Server hosted in Azure VM from Azure function app, but getting connection timeout error while connecting through it.

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,478 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,210 questions
asked 2024-07-04T13:03:53.9366667+00:00
Ritika Pandey 25 Reputation points
commented 2024-07-05T14:50:19.19+00:00
Nikhil Duserla 645 Reputation points Microsoft Vendor