Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,518 questions
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…
asked 2024-05-17T11:41:58.3833333+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, 47%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Dhanvi Bansal
0
Reputation points
answered 2024-05-20T05:47:09.9266667+00:00
ZoeHui-MSFT
33,386
Reputation points
4 answers
Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
asked 2024-05-16T12:03:46.98+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, 84%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENV%3C/text%3E%3C/svg%3E)
Nitya V
40
Reputation points
answered 2024-05-20T05:45:15.57+00:00
LucyChenMSFT-4874
1,280
Reputation points
2 answers
SQL Server Maintenance Plan: Cleanup Task
Hello! Some time ago I noticed that my two maintenance plans were working incorrectly: the cleanup tasks that must have been deleting files older then 2 weeks had not been really deleting anything and my oldest files were ~29.02.2024. The reason was that…
asked 2024-05-17T09:41:25.65+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(214.4, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Hram Admin
0
Reputation points
answered 2024-05-20T05:35:32.98+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…
asked 2024-05-15T18:18:35.6533333+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, 2%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
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…
asked 2024-05-14T14:12:31.44+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, 32%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
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. …
asked 2024-05-14T05:26:36.97+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(284.8, 83%, 37%)' 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)
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.
asked 2024-05-13T16:40:04.5466667+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, 49%, 11%)' 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)
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
asked 2024-05-19T19:01:44.0666667+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, 69%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
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.…
asked 2024-05-17T11:16:51.44+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(150.4, 62%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Theo
0
Reputation points
commented 2024-05-20T01:53:15.09+00:00
CosmogHong-MSFT
23,556
Reputation points Microsoft Vendor
0 answers
how to fix "Event ID 1309 from source ASP.NET 4.0.30319.0 cannot be found" Could not find file 'C:\Windows\TEMP\fsd3ypse.dll'.
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 4/29/2024 10:23:20 AM Event time (UTC): 4/29/2024 5:23:20 PM Event ID: 9b963c660c6142f28d1ee5d6ff0786a3 Event sequence: 61229 Event occurrence: 6 Event detail code: 0…
asked 2024-05-17T09:58:38.7066667+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(22.400000000000002, 75%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sakthi Ganesh S
0
Reputation points
edited the question 2024-05-20T01:43:13.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(163.2, 68%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYZ%3C/text%3E%3C/svg%3E)
Yu Zhou-MSFT
12,371
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…
asked 2024-05-17T08:52:23.3666667+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, 93%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERY%3C/text%3E%3C/svg%3E)
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…
asked 2024-05-17T15:26:35.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(240, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERJ%3C/text%3E%3C/svg%3E)
Ramanjaneyulu Jerugula
0
Reputation points
edited the question 2024-05-20T01:28:38.8166667+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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
26,481
Reputation points Microsoft Vendor
1 answer
How to install SQL Server in windows 11? I'm getting error code : 2061893606 while installing.
Could you plz help me with this error. how to fix it..?
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
9,205 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,852 questions
asked 2024-05-17T09:19:18.6133333+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(150.4, 31%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPA%3C/text%3E%3C/svg%3E)
Podhari Arun Kumar
0
Reputation points
edited the question 2024-05-20T01:19:06.8166667+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(281.6, 49%, 37%)' 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)
LiweiTian-MSFT
14,940
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
asked 2024-04-19T14:09:09.57+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, 68%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Thomas Davies
20
Reputation points
answered 2024-05-19T19:14:18.5933333+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, 28.000000000000004%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
James Longstreet
21
Reputation points
1 answer
AKS deployed application to access on-prem server
Hi, I want to connect to on-prem sql server from a .net application which is deployed in AKS. We already have Azure relay/hybrid connection setup for the same, but that requires azure app service. I am looking for options to connect from AKS deployed…
asked 2024-05-16T12:53:21.2833333+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
145
Reputation points
commented 2024-05-19T17:28:56.1166667+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, 4%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
kobulloc-MSFT
23,811
Reputation points Microsoft Employee
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…
asked 2021-06-22T16:29:10.737+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(297.6, 23%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Natalie Sh
26
Reputation points
commented 2024-05-19T08:01:18.8333333+00:00
Erland Sommarskog
102.2K
Reputation points MVP
0 answers
Microsoft programmability model that
libraries to access data on Microsoft 365 services.
asked 2024-05-15T13:55:10.93+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, 49%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDT%3C/text%3E%3C/svg%3E)
Divy This
0
Reputation points
commented 2024-05-18T16:56:01.7766667+00:00
Vahid Ghafarpour
18,685
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,672 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
![](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(195.2, 1%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Thomas Benson
0
Reputation points
commented 2024-05-18T15:32:12.21+00:00
Thomas Benson
0
Reputation points
2 answers
How to troubleshoot “SQL Server is terminating because of fatal exception C0000005 . Error code 17311
We have a legacy version SQL Server MSSQL 2008 , where we are getting an error “SQL Server is terminating because of fatal exception C0000005 " SQL Service gets stopped frequently on every Sunday. Unable to find solution for the above error , can I…
asked 2024-05-16T12:45:55.47+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(195.2, 57.00000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Seelan, Sathiya
40
Reputation points
answered 2024-05-18T15:31:05.21+00:00
Erland Sommarskog
102.2K
Reputation points MVP
asked 2024-05-16T18:33:09.84+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(67.2, 70%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
sherif samy
0
Reputation points
commented 2024-05-18T15:16:37.6066667+00:00
Erland Sommarskog
102.2K
Reputation points MVP