258 questions
1 answer
Known issue? Insert into temp table sometimes throws 8152 instead of 2628
Our system frequently needs to create temporary tables in order to pass data from Java to stored procedures. Since we are using SQL Server 2022, I would expect that when inserting a too-large value into a column we would get exception 2628 with the…
SQL Server | SQL Server Transact-SQL
asked 2026-01-06T19:01:14.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(166.4, 11%, 26%)' 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)
Dan Blum
0
Reputation points
answered 2026-01-06T19:34:30.4466667+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
1 answer
Attunity drivers are failing after OS upgrade to 2022
we have ssis packages where target is sql server 2016 and os 2016. recently we upgraded server os to 2022 but the sql server is still 2016. after upgrade the packages which are using attunity drivers to connect to oracle are failing when we give password…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2026-01-06T16:10:32.53+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(160, 98%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
vamsi krishna
0
Reputation points
answered 2026-01-06T16:11:45.05+00:00
Q&A Assist
1 answer
One of the answers was accepted by the question author.
SQL Server 2025 VECTOR_DISTANCE() should accept plain VARCHAR expression
Hello! Playing with VECTOR functions, I think these should accept implicit conversion from VARCHAR to VECTOR, to avoid additional casting operations: declare @v1 as VECTOR(3) = '[-1,1,0]' declare @s1 as VARCHAR(50) = '[-1,1,0]' drop table tab1; create…
SQL Server Database Engine
563 questions
asked 2026-01-06T12:53:24.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(249.60000000000002, 57.99999999999999%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESF%3C/text%3E%3C/svg%3E)
Sebastien Flaesch
51
Reputation points
accepted 2026-01-06T15:43:15.88+00:00
Sebastien Flaesch
51
Reputation points
0 answers
SSIS Job Failing Due to MongoDB Driver Dependency Error After MongoDB 8 Upgrade
As part of an ongoing upgrade to MongoDB version 8, we are updating the C# components used to integrate data into MongoDB collections to ensure compatibility with the latest MongoDB driver syntax and APIs. During this upgrade, we are encountering a…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2026-01-06T15:16:26.63+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(278.4, 50%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESA%3C/text%3E%3C/svg%3E)
Sahar Aitlhou
0
Reputation points
asked 2026-01-06T15:16:26.63+00:00
Sahar Aitlhou
0
Reputation points
2 answers
The SQL Server Management studio no longer shows running SSIS packages
Hi everyone, I run a bunch of SSIS packages in a SQL Server Agent job. The packages are deployed as files in the file system. They are executed as SQL Server Agent Service Account. I used to be able to see them under Running Packages. Today, they weren't…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2025-12-19T21:51:23.88+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, 92%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIG%3C/text%3E%3C/svg%3E)
Igor Gelin
0
Reputation points
edited an answer 2026-01-06T12:39:26.4833333+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(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Yitzhak Khabinsky
27,091
Reputation points
2 answers
Failed to create backup file in SQL Server
Hello, I'm having trouble with SQL Server backups and have a question. I translated this from Japanese, so the wording might be a bit awkward. [Environment] SQL Server 2019 running on a Hyper-V virtual environment on Windows Server 2016 [Issue] During…
SQL Server | SQL Server Transact-SQL
258 questions
asked 2025-12-26T01:35:10.4033333+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(268.8, 18%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
UTAMARO
0
Reputation points
commented 2026-01-06T09:57:08.3866667+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
1 answer
About SQL License
SQLのライセンスを購入して納品の連絡までは来たのですが、Microsoft365管理センターで対象のラインセンスが反映されず、困っています。 手続等足りていない部分があったら、その内容も含めて対応を確認したいです。 お手数をおかけしますがご確認をよろしくお願いいたします。
SQL Server Database Engine
563 questions
asked 2025-11-25T07:23:26.52+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(41.6, 51%, 14%)' 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)
大資 山田
0
Reputation points
commented 2026-01-06T09:29:27.6833333+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(134.4, 49%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
SQLDriverConnect truncates File DSN attribute values - breaks OAuth2 AccessToken support
Category: ODBC / Driver Manager Description: Problem Summary: The Windows ODBC Driver Manager (odbccp32.dll) truncates File DSN attribute values when reading the DSN file and passing attributes to the driver via SQLDriverConnect. This breaks OAuth2…
SQL Server | Other
14,631 questions
asked 2025-11-25T09:11:07.14+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, 6%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vikas Kumar
0
Reputation points
commented 2026-01-06T08:55:34.39+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
Upgrade from SQL-Server 2019 Standard to SQL-Server 2022 Standard
I want to make an upgrade from SQL-Server 2019 Standard to SQL-Server 2022 Standard. But i can't check the button for the standard edition. Best regards Carsten Neuhaus IKN GmbH
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.
590 questions
asked 2025-11-25T11:45:42.41+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, 51%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECN%3C/text%3E%3C/svg%3E)
Carsten Neuhaus
0
Reputation points
commented 2026-01-06T08:49:47.35+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
0 answers
SSIS error
Good morning everyone, I'm getting the following error [Execute SQL Task] Error: Executing the query "DECLARE @ReturnCode INTEGER = 0; [Execute SQL Task] Error: Executing the query "DECLARE @RerurnCode INTEGER = 0; excute ? OUTPU..."…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2025-11-25T18:27:45.5966667+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
8,881
Reputation points
commented 2026-01-06T07:28:15.4133333+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
I need to download SQQL 2025 standard and enterprise
Where can I get our SQL 2025 media to start installing
SQL Server | Other
14,631 questions
asked 2025-11-25T21:10:33.0466667+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(115.19999999999999, 57.00000000000001%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPC%3C/text%3E%3C/svg%3E)
Poupart, Christian
0
Reputation points
commented 2026-01-06T07:12:52.01+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
MySQL INSERT fails with ERROR 1064, 1265, 1292 (invisible character in numeric ID, ENUM mismatch, invalid DATETIME)
Hi, I’m importing seed data into a MySQL table and my bulk INSERT fails with multiple errors depending on the row. I suspect some data-cleaning/format issues during copy/paste or CSV → SQL conversion. Table definition CREATE TABLE lead_broker_status ( …
SQL Server Database Engine
563 questions
asked 2026-01-02T12:42:04.7466667+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, 74%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Arthur Tong
0
Reputation points
edited a comment 2026-01-06T06:56:36.1166667+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
Error: 40 - Could not open a connection to SQL Server
We are encountering an issue while importing data from a data warehouse hosted on SQL Server into Power BI. The connection is established successfully, and the import begins as expected. However, after running for some time, the process fails with the…
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,765 questions
asked 2025-11-25T21:24:25.6+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, 45%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Moorthy, Jayachandran
0
Reputation points
commented 2026-01-06T06:11:26.1266667+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
microsoftt access problem
when i run my laptop always a notification is aheaded tha odbc microsoft log in failed but i dont want this how i can solve this problem
SQL Server Database Engine
563 questions
asked 2025-11-27T04:53:57.7933333+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, 52%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Darshan Chandra Roy
0
Reputation points
commented 2026-01-06T05:51:16.6366667+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
1 answer
Need Archived Installer for SSMA 10.3
Hi, I’m running SQL Server 2022 Express on Windows 10 (64‑bit) and using SSMA for Access. With SSMA 10.4, I keep getting the error “Bad parameters for connection” when connecting via Windows Authentication. I understand this is a known regression in…
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.
590 questions
asked 2025-11-29T19:05:58.6566667+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(268.8, 71%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMJ%3C/text%3E%3C/svg%3E)
Mario Jaile
41
Reputation points
commented 2026-01-06T05:34:56.1133333+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
Error in connecting power bi to AXDW by DirectQuery
I opened the Power BI app on a virtual machine (VM) and tried to connect to AXDW using the server name "." or "dvhd10043vm" and the database name AXDW with the DirectQuery method. However, I encountered the following error message:…
SQL Server Database Engine
563 questions
asked 2025-11-30T07:07:40.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(118.4, 83%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mohamed Elsayed Tawfik
5
Reputation points
commented 2026-01-06T04:51:49.11+00:00
Akhil Gajavelly
1,110
Reputation points Microsoft External Staff
Moderator
2 answers
One of the answers was accepted by the question author.
How do I change the font size in the 'Connect to Server' dialog box?
My 'Connect to Server' dialog box is almost unreadable due to small font size. While it's straight forward to change fonts elsewhere in SSMS through Tools->Options->Environment->Fonts and Colors, there doesn't seem to be a way to change the…
SQL Server | Other
14,631 questions
asked 2026-01-05T15:56:39.62+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, 43%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vaughn, Daniel R
20
Reputation points
answered 2026-01-05T20:27:38.47+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
2 answers
SQL Server Express 2025 installation issue on hp omnibook 7
I have got new HP Omnibook 7 flip ultra 7. I am trying to install sql server express 2025 but every time it failed. The exit code is -2061893606 (Error description: Wait on the Database engine recovery handle. Check sql server error log for potential…
SQL Server Database Engine
563 questions
asked 2025-12-16T00:07:22.9033333+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(185.6, 79%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Amanullah Dar
0
Reputation points
commented 2026-01-05T20:07:48.13+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
3 answers
Cannot transfer my Access tables using the new SSMA 10.4 version
I would like to get SSMA 10.3 (Access → SQL Server edition) since I cannot use the current version which gives me the "Error Bad parameters for connection” regression in 10.4." I am running SQL Server Express, SSMA and VStudio 2022 Express so I…
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.
590 questions
asked 2025-12-27T19:33:44.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(249.60000000000002, 23%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
James Johnson
5
Reputation points
commented 2026-01-05T20:03:46.7333333+00:00
Erland Sommarskog
130.5K
Reputation points MVP
Volunteer Moderator
3 answers
Sql Server License
Hi, Can I use the Pay-as-you-go pricing model for a SQL server on a local virtual machine? Or does it need its own dedicated machine? Thank you
SQL Server | Other
14,631 questions
asked 2025-12-01T16:34:41.38+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(208, 41%, 30%)' 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)
Kyle Malvey
0
Reputation points
edited an answer 2026-01-05T19:37:23.8566667+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)
82,311
Reputation points
Volunteer Moderator