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 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
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
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
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
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
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
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
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
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
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
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
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
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: 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
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
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
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
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
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