SQL Server

Error Exit code (Decimal): -2064908287 when installing Microsoft SQL Server Developer 2022

Hi there, community! I'm just a guy who wants to become a Business Analyst. I was recomended to learn SQL on my own and, I decided to give a try to Microsoft SQL server. However, when I try to install the program, I'm getting this error. I have…

is allocated memory taken from Virtual memory reserved or its different.

if you see the screenshot , the buffle pool memory clerk, the allocated memory, Virtual memory reserved and virtual memory committed. I am confused if the allocated memory taken from virtual memory, or allocated memory is taken from OS and Virtual memory…

Latest security update has caused SS debugger to fail... 2008 r2 windows 10 - Windows Firewall

Getting: The WIndows Firewall on this machine is currently blocking remote debugging. RD requires... TCP Port 135... UDP 4500/ 500 be unblocked. Can't Cancel, Unlock for local or Unlock for Computer. Trying to "Debug>Start Debugging".

SSIS Package Execution Error - The requested OLE DB provider Microsoft.ACE.OLEDB.16.0 is not registered

Hello Community, I have been getting this error message every time I run my saved SSIS package. And even though I have looked up this error message across the web, the solutions have not seemed to work. To provide the background information with the…

need a query for a match 2

Hi all, I have these two tables: T1 Date Item Qty 2025-07-01 100 10 2025-07-01 101 20 2025-07-01 102 20 2025-07-01 105 30 2025-07-02 100 30 2025-07-03 200 20 2025-07-03 201 25 2025-07-03 202 40 2025-07-04 200 30 and T2 Date …

need a query to do a match

Hi all, I have these two tables: T1 Date Item Qty 2025-07-01 100 10 2025-07-01 101 20 2025-07-02 100 30 2025-07-03 200 20 2025-07-04 200 30 and T2 Date Item …

Microsoft Entra ID not working in SQL Server VSCode

Whenever I try to use my Microsoft Entra ID on the SQL Server extension in VSCode, I click 'Sign in', which takes me to the authentication page in my browser where I sign in. I get the page that says I am signed in and can close the browser, but the…

.NET GC not reclaiming memory after List<T>.Clear() in SQL CLR UDF under load - leads to memory insufficiency in SQL Server

We're running into memory insufficiency issues on SQL Server when using a SQL CLR UDF written in C# targeting .NET Framework 4.8. The function uses a singleton class to cache user session info using a List<T> of structs. Each struct holds…

"How can I install SQL Server Express Edition? I am getting an error with the decimal code 2061893606."

This is the error message its is getting when i am trying to install. I tried to screenshot the error but not working in my case.😁 Oops... Unable to install SQL Server (Setup.exe) Exit code (Decimal) : 2061893606 Error Description: Wait on the database…

When will SQL Server Management Studio (21) support ARM64-based PCs?

I have the MS Surface ARM64-based PC with a Snapdragon CPU and need to know when there will be a release of Microsoft SQL Server Management Studio 21 or later that supports this architecture. This is the management studio and not the SQL Server.

ReportViewer WebForms breaks when certain cultures are used in reports with datetime filtering

We've recently upgraded from standalone Report Viewer 2015 runtime to the NuGet package in our ASP.NET webapp (.NET Framework 4.7.2): https://www.nuget.org/packages/Microsoft.ReportingServices.ReportViewerControl.WebForms/ The issue is that using…

Azure SQL showing message 8152 instead of 2628

We have a strange insert 8152 error. The full insert SQL is failing. We have identified which fields are causing the error. Excluding those works but inserting those fields alone without other fields also work! And we are not getting the 2628 message.…

SQL Server saved remote password on linked server randomly becomes invalid

I have a 2019 SQL Server with a single instance on it. It has a linked server that tests out and works fine. However, the stored remote password randomly (daily to every few days) becomes invalid, and I have to reenter the password to get it to work…

How to download Sql Server Configuration Manager

Hello, BRAND NEW to SQL Server. I was following along with a tutorial and downloaded the SSMS, however, doesn't seem like i have the configuration manager installed properly. I tried entering the credentials first prompted once SSMS was done…

KB5058713 fails install

KB5058713 fails install regardless of reboots, disabling SQL services, or Safe boot. O/S: Win10 Pro 22H2 x64 Tried: Run WUpdate Troubleshooter - fails to launch due to error 0x80070003 Reboot & Update - install fails Clean boot & Update -…

Replication ISSUE - how to prevent error MSSQL_REPL-2147199363. after it happens, recreate publish and configure all suscriptors is necessary.

HI ALL, help please. currently we have our main database and many subscriptors, when some of the subscriptors are offline form some days (maintenance or politics company pourposes doesnt matter), and getting online again, we are facing some issues…

I am unable to install the sql express server 2022.

We need to migrate a TDE-encrypted database from one Azure SQL Managed Instance to another Azure SQL Managed Instance. The standard TDE certificate export process (BACKUP CERTIFICATE) doesn't work on Managed Instance. Is there any supported method to expo

We need to migrate a TDE-encrypted database from one Azure SQL Managed Instance to another Azure SQL Managed Instance. The standard TDE certificate export process (BACKUP CERTIFICATE) doesn't work on Managed Instance. Is there any supported method to…

Getting this error: Msg 3609, Level 16, State 1, Line 88 The transaction ended in the trigger. The batch has been aborted.

So I'm trying an exercise Trigger Code that would send an email if someone tries to insert into the adventure database a special offer that is equal to or greater than 80%, My Code goes Like this: ----------------------- The…

Export Query Results as CSV WITH Headers

I just need to get my query results out to a CSV file WITH Headers quickly (without going through the whole SSIS process for a one-off job). I thought the option below would do the trick, but I get a CSV WITHOUT Headers. Advice?