20,745 questions with SQL Server-related tags

Sort by: Updated
0 answers

SQL Integration Issue – Execution failed with error code 18885920258

System.Data.SqlClient.SqlException: Execution failed with error code <error_code_18885920258> at Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Execute() at Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ValidateParameters(SqlParameterCollection…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,723 questions
asked 2025-09-04T14:09:04.07+00:00
aditi sharma 0 Reputation points
0 answers

SQL Driver for MSSQL 2008 R2 and OpenJDK 17

Hi Guys, I am connecting Microsoft SQL Server 2008 R2 (SP3-GDR) (KB4057113) - 10.50.6560.0 (X64) from RHEL9.6 system having openJDK17 on it but getting below error. I tried with SQL driver version 13,12 and 10 but result is same always. So can you…

SQL Server Database Engine
asked 2025-09-04T13:53:49.5666667+00:00
Sumit Chaudhary 0 Reputation points
1 answer One of the answers was accepted by the question author.

SQL Server 2016 Update Path Issue After Installing version 13.0.7055.9

Hello, I am seeking guidance on the correct update path for a SQL Server 2016 SP3 instance after installing a specific feature pack update. Summary of the Issue: After installing the "Azure Connect Feature Pack" update (KB5058717), I am unable…

SQL Server Database Engine
asked 2025-08-22T13:58:19.49+00:00
Conor Keaney 20 Reputation points
accepted 2025-09-04T13:50:28.2366667+00:00
Conor Keaney 20 Reputation points
1 answer

Column Data size issue

Hi, I have an "ID" column in the tblAudit table with datatype NUMERIC(18,0). The table has 45 million records, and the ID column is the clustered primary key. Generally, this column should occupy less than 1 GB of storage, but on my server,…

SQL Server Database Engine
asked 2025-09-03T02:13:57.8066667+00:00
RAMA KRISHNA MANDALAPU 0 Reputation points
commented 2025-09-04T12:30:49.3866667+00:00
Abdifatah Hassan Roble 80 Reputation points
0 answers

Database 'X' on server 'Y' is not currently available.

We have a database which mirrors another one on a different server, but has suddenly become unavailable as of 06:03:25 04/09/2025 and is still ongoing. The error message I am receiving when trying to gain access to the database is the…

SQL Server | SQL Server Transact-SQL
asked 2025-09-04T09:55:37.3433333+00:00
James Tordoff 0 Reputation points
0 answers

InvalidItemNameException in SSRS 2016/2019 – Impact of URL-Encoded Characters Post Upgrade to Version 15.0.1104.39

After upgrading SQL Server Reporting Services (SSRS) from version 15.0.1102.962 to 15.0.1104.39, attempts to create folders via the SSRS web service now fail with the following error: InvalidItemNameException: “The name of the item 'Name contains…

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.
3,080 questions
asked 2025-08-29T10:25:00.3033333+00:00
ZTS 60 Reputation points
commented 2025-09-04T08:13:51.81+00:00
ZTS 60 Reputation points
0 answers

Unable to Add Database to Availability Group Due to Missing Database Master Key

I have encountered an issue while trying to add a database to an Availability Group. The Database Master Key (DMK) seems to be missing, which is preventing the process. Below are the details gathered from the relevant system views: Certificates SELECT…

SQL Server Database Engine
asked 2025-09-03T14:55:01.26+00:00
Muneeb Akbar 0 Reputation points
commented 2025-09-04T07:19:13.36+00:00
Muneeb Akbar 0 Reputation points
0 answers

Why are users being dropped from a Database by a node.js process

We have a DB where users are being dropped on a schedule. The users are in the master DB, which we then add to a different DB, but since the weekend, users are being dropped form the DB (although still in the master DB)

SQL Server | Other
asked 2025-09-03T21:48:24.4066667+00:00
Ross T Boltman (z) 0 Reputation points
0 answers

How to convert timestamp from utc to +10

I have a problem. Don't know how to convert timezone to mine

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,350 questions
asked 2025-09-03T01:34:58.6333333+00:00
Ivan Vasenev 5 Reputation points
commented 2025-09-03T21:39:52.06+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
1 answer

Inquiry About SQL Server 2014 Per Core Licensing

Hello, I would like to inquire about SQL Server 2014 Per Core licenses. Could you please provide information on: Availability of Standard and Enterprise editions under per-core licensing. Minimum cores required per processor. Pricing per 2-core…

SQL Server Database Engine
asked 2025-09-03T07:31:02.7366667+00:00
Phonexay Vientiane 0 Reputation points
answered 2025-09-03T21:36:58.11+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
0 answers

What collations does sys.fn_get_audit_file_v2 support

When calling the function on a server with default collation Latin1_General_100_CI_AS_SC_UTF8 I get this error: Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_100_CI_AS_SC_UTF8" in…

SQL Server Database Engine
asked 2025-09-03T08:56:40.3666667+00:00
Jakob Hommelhoff 0 Reputation points
commented 2025-09-03T21:33:04.6233333+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
1 answer

Error al instalar sql server 2022 standar edition

Buenos días, al intentar instalar me sale ese error. Se descargo desde la misma plataforma de Microsoft.

SQL Server Database Engine
asked 2025-09-03T15:53:32.8566667+00:00
Héctor Oré 0 Reputation points
answered 2025-09-03T21:17:56.6566667+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
0 answers

SQL Server Integration Package Failing with Error Code 18883190814 During Execution

System.Data.SqlClient.SqlException: Execution failed with error code <error_code_18883190814> at Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.Execute() at Microsoft.SqlServer.Dts.Runtime.TaskHost.Execute(Int32& result) at…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,723 questions
asked 2025-09-03T17:28:17.3266667+00:00
aditi sharma 0 Reputation points
commented 2025-09-03T21:13:23.2866667+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
0 answers

I need to download an older SSRS Version

Hello, Im installing Dynamic365 Finance&Operations on-premise. On a Windows server i have installed SQL Server 2019, and when i try to execute the security frabric SSRS gives me the same error as the link below while installing. …

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.
3,080 questions
asked 2025-09-03T21:09:16.08+00:00
Luiz Nakamoto 20 Reputation points
commented 2025-09-03T21:12:57.9766667+00:00
Luiz Nakamoto 20 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Server: query performance

I would like to write a fast query returning the data that the following query returns: SELECT M,COmb,Mod,Loc,Initial, Final,Kms_,R,Franq,Num_Fleet,Pneus,Cli,Active,Interv, Cost1,Cost2,Name,Colab_Cod,col.colName FROM tFleetCars AS v OUTER APPLY ( …

Developer technologies | Transact-SQL
SQL Server | Other
asked 2021-11-12T11:29:35.293+00:00
JDias 161 Reputation points
commented 2025-09-03T20:50:29.1866667+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
3 answers

sql server 2022 windows authentication not working on peer to peer network

I have two brand new latest version PCs with windows 11 installed and connected as a peer to peer network. I have installed MS SQL 2022 (Developer) on one pc and SSMS on the other pc. I can establish a connection via SA account and query the database as…

Windows for business | Windows Client for IT Pros | User experience | Other
SQL Server | Other
asked 2024-02-20T02:53:02.21+00:00
Peter Halbert 0 Reputation points
commented 2025-09-03T14:24:55.92+00:00
Mark Murphy 0 Reputation points
3 answers

Best practice with sp_syspolicy_events_reader and ##MS_PolicyEventProcessingLogin##

The SQL Server logs on our primary replica (Microsoft SQL Server 2022 with Always On) has been filling up with this repeated message: The activated proc '[dbo].[sp_syspolicy_events_reader]' running on queue 'SQLAG1_msdb.dbo.syspolicy_event_queue'…

SQL Server Database Engine
asked 2025-08-05T14:53:19.4333333+00:00
anna@tec 0 Reputation points
commented 2025-09-02T20:41:10.98+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
3 answers

SQL Express Setup (SQLEXPR_x64_ENU) failed with 2068052310 error code

I was installing SQL Express 2019 (SQLEXPR_x64_ENU) at Windows 10 64 bit machine, but getting 2068052310 error code. Pre-Installed: SQL Express 2012 SP4 64 bit.

SQL Server | Other
asked 2024-09-27T16:18:02.5933333+00:00
Anonymous
commented 2025-09-02T20:38:49.95+00:00
Erland Sommarskog 125.1K Reputation points MVP Volunteer Moderator
1 answer

i [purchased a new laptop Hp victus 15 AMD Ryzen 7 8845HS w/ Radeon 780M Graphics (3.80 GHz) but i am not able to install sql express on this

i [purchased a new laptop Hp victus 15 AMD Ryzen 7 8845HS w/ Radeon 780M Graphics (3.80 GHz) but i am not able to install sql express on this

SQL Server Database Engine
asked 2025-09-02T10:34:29.0433333+00:00
Ashish Sharma 0 Reputation points
edited an answer 2025-09-02T17:58:07.1633333+00:00
Alberto Morillo 34,926 Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Urgently need SQL keys

Hello, Please urgently end us the the SQL license key on the OV agreements. Customer is sittung waiting for license keys, Thank you

SQL Server | Other
asked 2025-09-01T14:22:07.95+00:00
Elisabeth Petillon Stavik 20 Reputation points
edited the question 2025-09-02T10:18:37.73+00:00
Elisabeth Petillon Stavik 20 Reputation points