18,096 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

Issue with Excel Destination character size in SSIS

I am trying to export data from a database table in SQL server 19.1 version to a Excel file using SSIS 2019 excel destination task. One of the fields 'External Notes' coming from SQL database is VARCHAR(5000). I can export everything to excel but the…

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,520 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-17T11:41:58.3833333+00:00
Dhanvi Bansal 0 Reputation points
answered 2024-05-20T05:47:09.9266667+00:00
ZoeHui-MSFT 33,386 Reputation points
2 answers

Custom skill integration Azure AI Search

0 I have a requirement to crawl an Azure SQL server from Azure AI search. The SQL server exists in different VNET and I have created a Shared Private Link to connect. The Indexer works fine without any problem. As soon as I add a custom webapi skill the…

Azure AI Search
Azure AI Search
An Azure search service with built-in artificial intelligence capabilities that enrich information to help identify and explore relevant content at scale.
742 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.
12,859 questions
asked 2024-05-15T18:18:35.6533333+00:00
Somdeep Niyogi (external) 1 Reputation point
commented 2024-05-20T02:46:30.3266667+00:00
LucyChenMSFT-4874 1,280 Reputation points
1 answer

Error code 0x2AF9 When trying to connect to docker created mssql server with ODBC drivers

I am using Microsoft made images like mcr.microsoft.com/azure-sql-edge or mcr.microsoft.com/mssql/server:latest within docker to create a test environment server. I have installed ODBC drivers from Microsoft as well (17 & 18) and am trying to connect…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-14T14:12:31.44+00:00
Logan Jackson 0 Reputation points
commented 2024-05-20T02:45:52.9766667+00:00
LucyChenMSFT-4874 1,280 Reputation points
4 answers

How to restore SQL server 2019 database backup (.bak) to SQL server 2017.

Hi, In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-14T05:26:36.97+00:00
Shyam Kumar 0 Reputation points
commented 2024-05-20T02:45:15.2333333+00:00
LucyChenMSFT-4874 1,280 Reputation points
2 answers

How to sql dump generation on sql server 2008 ?

Good morning, I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory. Can you give me the procedure to disable the generation of these files please. Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-13T16:40:04.5466667+00:00
Tidiane TRAORE 0 Reputation points
commented 2024-05-20T02:44:40.49+00:00
LucyChenMSFT-4874 1,280 Reputation points
2 answers

“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQL Server 2014 is almost complete

“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQ L Server 2014 is almost complete

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-19T19:01:44.0666667+00:00
Ammar Al-Selwi 0 Reputation points
edited an answer 2024-05-20T02:21:14.7233333+00:00
LucyChenMSFT-4874 1,280 Reputation points
2 answers

Best practice on performing maintenance on a 2 node SQL Server Cluster with no witness.

Hello, We have a two-node SQL Server Cluster with no witness. Each month we patch the secondary server, then perform a failover and then patch the new secondary server. We do nothing special to tell the cluster that a node is going offline for patching.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-17T11:16:51.44+00:00
Theo 0 Reputation points
commented 2024-05-20T01:53:15.09+00:00
CosmogHong-MSFT 23,556 Reputation points Microsoft Vendor
1 answer

How To send mail with attachment from SQL MI

Hi Team, I am using msdb.dbo.sp_send_dbmail to send mail from sql mi. I need to send this mail with attachment. Since SQL MI does not support file attachment i am looking for the alternatives. I have one https service like https://test/getfile service…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-17T08:52:23.3666667+00:00
Radhakrishnan, Yadu Krishnan (Allianz Technology) 0 Reputation points
answered 2024-05-20T01:41:28.3266667+00:00
LucyChenMSFT-4874 1,280 Reputation points
0 answers

dacpac project .sqlproj creation. errors with multiple schemas

i have SQL Server database, with objects defined under two schemas, Schema 1 - dbo. Schema 2 - pr. Tables - dbo.person, dbo.orders, pr.person , pr.orders, pr.sales SP= dbo.getpersons, dbo.getdata, pr. salesinfo. when imported the data into .sqlproj…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-17T15:26:35.8766667+00:00
Ramanjaneyulu Jerugula 0 Reputation points
edited the question 2024-05-20T01:28:38.8166667+00:00
Anna Xiu-MSFT 26,481 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 20 Reputation points
answered 2024-05-19T19:14:18.5933333+00:00
James Longstreet 21 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Server - Question marks inserted with Hebrew collation

SQL Server 2019, Developer edition, Windows 10. The client is SSMS 18. When database is created with Hebrew collation, for example, Hebrew_CI_AI, there is no problem, Hebrew strings are inserted and being read as they are. When database is created…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,561 questions
asked 2021-06-22T16:29:10.737+00:00
Natalie Sh 26 Reputation points
commented 2024-05-19T08:01:18.8333333+00:00
Erland Sommarskog 102.2K Reputation points
0 answers

Microsoft programmability model that

libraries to access data on Microsoft 365 services.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
JavaScript API
JavaScript API
An Office service that supports add-ins to interact with objects in Office client applications.
898 questions
asked 2024-05-15T13:55:10.93+00:00
Divy This 0 Reputation points
commented 2024-05-18T16:56:01.7766667+00:00
Vahid Ghafarpour 18,765 Reputation points
1 answer

Creating Dataset in VS2020 using SQL query rather than visual designer

I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,676 questions
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,818 questions
asked 2024-05-08T11:12:55.34+00:00
Thomas Benson 0 Reputation points
commented 2024-05-18T15:32:12.21+00:00
Thomas Benson 0 Reputation points
1 answer

SSIS - Flat File Destination Fixed Width Columns Appear to be Ragged

I am trying to create a flat file export, the spec is fixed width column, no headers or delimiters. There are 16 columns, the total width of all the columns combined is 624 characters. i have attempted two methodologies, both yield the same result where…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
asked 2024-05-16T22:31:35.1166667+00:00
Ken Wenze 0 Reputation points
commented 2024-05-18T15:12:13.03+00:00
Erland Sommarskog 102.2K Reputation points
0 answers

How to resolve this error "External component has thrown an exception" in MS SQL server while loading excel file ?

How to resolve this error "External component has thrown an exception" in MS SQL server while loading excel file ?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-17T04:56:21.8033333+00:00
Hemant S 0 Reputation points
commented 2024-05-18T15:06:49.2766667+00:00
Erland Sommarskog 102.2K Reputation points
2 answers

unable to connect another data base in same server which is azure sql - through ssms

Issue description: Msg 40515, Level 15, State 1, Line 66 Reference to database and/or server name in 'sriniazpracticedbserver.database.windows.net.TARGET.dbo.data_trg' is not supported in this version of SQL Server. Completion time:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-17T05:49:15.5066667+00:00
Srinivas Mantri 0 Reputation points
answered 2024-05-18T14:46:59.58+00:00
Erland Sommarskog 102.2K Reputation points
4 answers

Security update for SQL Server 2019 CU25

Hi, I would like to clear up some confusion regarding security updates for SQL Server 2019. If Security update for SQL Server 2019 CU 25 KB5036335 is pushed out by our System Engineers team to a server, does that mean it includes the Cumulative Update…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,252 questions
asked 2024-05-14T17:31:21.2833333+00:00
David D. Lengar 0 Reputation points
commented 2024-05-18T14:09:39.63+00:00
Erland Sommarskog 102.2K Reputation points
2 answers One of the answers was accepted by the question author.

Execution Plan Parallel Deadlock Issue Persisting in SQL Server 2022

Hi Msft team! I hope this message finds you well. I am writing to report a persistent issue with execution plan parallel deadlocks that still exists in SQL Server 2022. Despite updates and patches, this bug appears to remain unresolved, and I have been…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-05-10T15:07:55.6733333+00:00
Steven Lam 20 Reputation points
commented 2024-05-18T13:03:02.69+00:00
Steven Lam 20 Reputation points
3 answers

How do I fix MSSQL Server 2022 Database Engine Services failing to install?

I have been struggling with this for far too long now. I've reinstalled it twice now with 9 repair tries. Still no luck. I need some help because my classes require it to be installed. Overall summary: Final result: Failed: see details…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2023-03-28T13:45:32.1966667+00:00
JC Sanders 5 Reputation points
edited an answer 2024-05-18T09:01:56.57+00:00
Alok Jha 0 Reputation points
4 answers One of the answers was accepted by the question author.

Not able install sql server 2022 in window 11.

Error installing SQL Server Database Engine Services Instance Features The system cannot find the path specified Error code:…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,859 questions
asked 2024-03-03T17:37:10.53+00:00
dinabondhu pramanik 25 Reputation points
answered 2024-05-18T08:57:03.8733333+00:00
Alok Jha 0 Reputation points