19,530 questions with SQL Server-related tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

Upgrading from SQL Server 2016 Express SP1 to SP3

Which option in SQL Server 2016 Express setup should be chosen to upgrade from SP1 to SP3? This is an in-place upgrade from SQL Server 2016 Express (SP1-GDR).

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,069 questions
asked 2024-11-21T21:07:43.11+00:00
Paul Tormey 20 Reputation points
answered 2024-11-23T19:50:28.43+00:00
Paul Tormey 20 Reputation points
0 answers

Error when setting destination in Copy Data activity (MS Fabric)

Hi all,   In my Fabric workspace, I have a pipeline with a "Copy Data" activity. The source is a lakehouse. I am trying to set the destination to be SQL Server. I have put in the server name, username and password. I also checked the checkbox…

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,069 questions
Microsoft Fabric Training
Microsoft Fabric Training
Microsoft Fabric: A Microsoft unified data platform.Training: Instruction to develop new skills.
52 questions
asked 2024-11-23T16:16:39.4233333+00:00
John Uzoma 20 Reputation points
commented 2024-11-23T18:08:57.6666667+00:00
Erland Sommarskog 112.8K Reputation points MVP
0 answers

Connecting to Azure Sql Managed Instance

Hello, I am having connectivity issue after migrating on-prem Databases to Azure Sql Managed Instance. I tried two way and getting slightly different error message: Somehow I am confused as I am able to using SSMS and Azure data Studio via my local, I am…

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.
14,069 questions
asked 2024-11-23T16:19:05.4766667+00:00
pdsqsql 411 Reputation points
commented 2024-11-23T17:58:31.11+00:00
Erland Sommarskog 112.8K Reputation points MVP
1 answer

"RESTORE detected an error on page (0:0) in database" error while restoring a database

I have a large database (750GB) that I am backuped on one server and attempted to restore on a different server, I receive the following error - "System.Data.SqlClient.SqlError: RESTORE detected an error on page (0:0) in 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.
14,069 questions
asked 2024-11-23T03:38:48.48+00:00
Johnson, Maurice 0 Reputation points
answered 2024-11-23T11:00:52.65+00:00
Erland Sommarskog 112.8K Reputation points MVP
0 answers

How to fix timeout error in connection using pyodbc in airflow

Hi, I am running an airflow DAG in docker, where I connect to sql server 2019 using a pyodbc connection function. My connection function is as: def get_db_connection(): return pyodbc.connect( 'DRIVER={ODBC Driver 17 for 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.
14,069 questions
asked 2024-11-23T06:00:19.38+00:00
Xavier Langa 0 Reputation points
commented 2024-11-23T10:48:40.4233333+00:00
Erland Sommarskog 112.8K Reputation points MVP
0 answers

How to load data from multiple txt files after removing first row into tables?

Hi All, I faced one scenario where i have 6 txt files of different regions. In every text document First Line is not required. How can I remove First line alone and load the data from all six source docs into SQL tables? Data From North…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,601 questions
asked 2024-11-23T07:58:05.68+00:00
Ramana Kopparapu 306 Reputation points
0 answers

In T-SQL debugging, "Step Into" behaves like "Step Over."

visual studio 2022 (17.11.5) Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 <X64> (Build 22631: ) (Hypervisor)…

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,069 questions
asked 2024-11-22T11:14:07.62+00:00
Jungsooooo 0 Reputation points
commented 2024-11-22T22:08:18.9+00:00
Erland Sommarskog 112.8K Reputation points MVP
1 answer One of the answers was accepted by the question author.

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

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.
14,069 questions
asked 2024-11-21T04:04:53.5+00:00
Prateek Hiremath 20 Reputation points
commented 2024-11-22T22:01:05.5633333+00:00
Erland Sommarskog 112.8K Reputation points MVP
0 answers

We are setting up Entra Authentication for SQL Server. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted?

We are setting up Entra Authentication for SQL Server on premises via Azure Arc. We want to protect against regional outages. How do we configure private DNS so that if a region goes down, SQL Authentication via Entra ID will not be impacted?

Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,019 questions
Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
444 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,069 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,295 questions
asked 2024-11-22T22:00:30.56+00:00
Seekell, Roger 46 Reputation points
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…

Azure SQL Database
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,601 questions
asked 2024-11-12T13:59:46.06+00:00
Teresa Thomas 1 Reputation point
commented 2024-11-22T20:59:21.2+00:00
Mahesh Kurva 975 Reputation points Microsoft Vendor
1 answer

Migrating existing packages - C# task is failing on a new server

Hi, We're migrating our SSIS server to a new server. Original server is Windows Server 16, SQL Server 2019. New server is Windows Server 2022 and OS is SQL Server 2022. We're getting the error on the packages that use C# script task: Code: 0x00000005 …

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,069 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,663 questions
asked 2024-11-21T23:58:54.0533333+00:00
Naomi Nosonovsky 7,911 Reputation points
edited an answer 2024-11-22T20:57:22.1866667+00:00
Yitzhak Khabinsky 26,041 Reputation points
2 answers

Error occurred during local report processing

Hi Experts, i am getting error while generating the report: I have used parameters like : and getting error as below screenshot The 'Value' expression for the query parameter '?' contains an error: Overload resolution failed because…

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,944 questions
asked 2022-11-29T06:28:37.413+00:00
Rathore, Vaibhav Singh 1 Reputation point
commented 2024-11-22T19:06:13.44+00:00
BremerhavenRocks 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…

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.
14,069 questions
asked 2024-11-20T18:06:39.1+00:00
Easy Drive 0 Reputation points
commented 2024-11-22T16:08:26.4433333+00:00
NIKHILA NETHIKUNTA 3,585 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SQL Server 2019 installation failed with 2068052310 Exit code

SQL Server 2019 installation failed with below error. I have tried manually installing the msodbcsql.msi and re-tried the SQL server installation, but that also failed. The SQL2019-SSEI-Expr.exe was downloaded from microsoft.com

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,069 questions
asked 2022-11-10T08:37:44.4+00:00
Kizhakkethiruoth, Jagadeesh 56 Reputation points
commented 2024-11-22T16:07:38.6933333+00:00
Kacper Lugiewicz 0 Reputation points
2 answers

Possibity of upgrade and migration from SQL 2014 to SQL 2022

HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards,

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,069 questions
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.
540 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,069 questions
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.
540 questions
asked 2024-11-15T08:49:17.6066667+00:00
Tarik sendro 0 Reputation points
commented 2024-11-22T14:37:11.7166667+00:00
Tarik sendro 0 Reputation points
2 answers

Possibity of upgrade and migration from SQL 2014 to SQL 2022

HI Team, I am having one system ( Procesor: Intel Xeon E-2224 3.4GHz, 8M c ache, 4C/4T, turbo (71W)) with installed 2014 SQL I would like to upgrade to 2022 Standard SQL is it possible and what is most easy way. Kind regards,

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,069 questions
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.
540 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,069 questions
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.
540 questions
asked 2024-11-15T08:49:17.6066667+00:00
Tarik sendro 0 Reputation points
commented 2024-11-22T14:37:11.7166667+00:00
Tarik sendro 0 Reputation points
1 answer

[Completed with warning]:The site database has a backlog of SQL change tracking data. For more information

We got this issue when we run prerequisites check in Configuration Manager (SCCM). [Completed with warning]:The site database has a backlog of SQL change tracking data. For more information see https://go.microsoft.com/fwlink/?linkid=2027576

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,069 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,305 questions
Microsoft Configuration Manager
asked 2024-11-10T09:06:45.25+00:00
Mirza Anwarulla Baig 0 Reputation points
commented 2024-11-22T13:16:02.9733333+00:00
Sherry Kissinger 5,176 Reputation points
1 answer One of the answers was accepted by the question author.

[Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for SQL Server]Client unable to establish connection.

Hello, researched and around still having issues on connecting into SQL Server. Error getting is: [Microsoft][ODBC Driver 18 for SQL Server]SSL Provider. The certificate chain was issued by an authority that is not trusted. [Microsoft][ODBC Driver 18 for…

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,069 questions
asked 2024-11-05T17:45:22.7233333+00:00
techresearch7777777 1,901 Reputation points
accepted 2024-11-22T10:40:55.3466667+00:00
techresearch7777777 1,901 Reputation points
2 answers

Critical Error for SharePoint_Config Database

Hi, I searched all forums for three days but can't find the answer. These topics won't work : Answer 1 Answer 2 Answer 3 The server returns this critical error: SQL database login for 'SharePoint_Config' on instance 'ServerSql' failed.…

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,944 questions
SharePoint Development
SharePoint Development
SharePoint: A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.Development: The process of researching, productizing, and refining new or existing technologies.
3,071 questions
asked 2022-11-21T10:40:33.883+00:00
Safa 1 Reputation point
commented 2024-11-22T09:36:12.8+00:00
Sudhir Singare 0 Reputation points
2 answers

SQL Recursive query to generate output

Hello Expert , I am trying to generate one output as: Two different Tables: Table1: Cat1, Vol,Rank Cat1, 1, 1 Cat1, 4, 2 Cat1, 6, 3 Table2: Rank, Vol_Threshold, Partition 1, 21, 1 2, 27, 2 3, 34, 3 Would like to generate output: if running first…

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,069 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,663 questions
asked 2024-11-18T12:14:09.0766667+00:00
Avanish Tomar 0 Reputation points
commented 2024-11-22T07:17:52.2866667+00:00
LiHongMSFT-4306 28,806 Reputation points