21,331 questions with SQL Server-related tags

Sort by: Updated
0 answers

My Sql costs are very high for what is hundreds of rows of data that is only accessed by one user for a few hours a day

I have 100,000 free seconds and they have been used up in 2 days. How can I see why that is and resolve it? I have this setup, used space is 118mb, my compute utilization in the last 7days has not averaged more than 0.3% Free - General Purpose -…

SQL Server | Other
asked 2026-02-03T23:33:21.5366667+00:00
Vic Johnston 0 Reputation points
2 answers

DBF Table named Order in VFP

DBF Table named Order in VFP i think you can't have a tlb named order can anyone help with this problem. Update ORDER ; SET ORDER.GROUP = 'Apples' ; WHERE ORDER.GROUP == 'Apple'

SQL Server Database Engine
asked 2026-02-03T00:46:31.6266667+00:00
Paul Waldner 0 Reputation points
answered 2026-02-03T22:24:04.14+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

reserved keywords field name in VFP

Update _ORDER; SET group = 'Apples' ; WHERE group = 'Apple' Moderator: Moved from SQL Server | Other

SQL Server | Other
asked 2026-02-03T02:48:40.0933333+00:00
Paul Waldner 0 Reputation points
edited the question 2026-02-03T22:17:58.2533333+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
3 answers

Message=A severe error occurred on the current command. The results, if any, should be discarded.

Hi, There is an Failure in my Azure Datafacttory for a particular table with the below error message. Failure happened on 'Source' side.…

SQL Server | Other
asked 2026-02-03T06:06:13.4133333+00:00
Sudhakar Paraniselvan 0 Reputation points
answered 2026-02-03T22:15:54.5+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

sql server management system studio 20 crashes everytime i try to save a quers using ctrl +s or save as

I've had this issue for a couple of days now and i tried deleting the shell folder and uninstalling ssms but it doesn't seem to work, maybe there are folders that haven't been deleted when i uninstalled it? but it's driving me mad not to know how to fix…

SQL Server | Other
asked 2026-02-01T16:19:09.2+00:00
Nada Osama 25 Reputation points
commented 2026-02-03T21:38:03.53+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2025 LocalDb installation is missing components

According to https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2025 - "SQL Server Express LocalDB is a lightweight version of Express edition that has all its programmability features" Therefore I would…

SQL Server Database Engine
asked 2025-12-09T15:15:18.17+00:00
Duncan Smart 0 Reputation points
commented 2026-02-03T21:35:22.2533333+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
3 answers

How do I fix an SQL Server issue

I recently transferred from one computer to another and forgot that one of the programs needed installed from scratch or it caused issues and would not open the program even after re-installation. The issue I am having involves SQL server. Windows cannot…

SQL Server Database Engine
asked 2026-01-11T19:35:52.46+00:00
Kevin Johnson 0 Reputation points
edited an answer 2026-02-03T11:44:19.85+00:00
Carl Walker 0 Reputation points
3 answers

External Image for PowerBI Report Server

Good day! I am experiencing an issue with my report: the image I added is visible in the design view of Report Builder, but it does not display when I run the report in Power BI Report Server (PBIRS). The external image is stored in an Azure Blob…

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,136 questions
asked 2026-01-26T01:57:07.7033333+00:00
Power Pulse 0 Reputation points
answered 2026-02-03T09:09:16.8566667+00:00
kagiyama yutaka 0 Reputation points
2 answers

Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS)

Ik kan geen rest endpoint aanroepen uit SQL 2025 naar LocalHost (HTTPS) Microsoft SQL Server Enterprise Developer (64-bit) / Windows 11 Home / We hebben de volgende procedure…

SQL Server Database Engine
asked 2026-01-29T11:22:08.93+00:00
Patrick LEONARD 0 Reputation points
commented 2026-02-03T08:55:50.3566667+00:00
Shruti Dhruv 800 Reputation points Microsoft External Staff Moderator
3 answers

STAR Schema Model Design

Hello, I am planning to create START schema model but need to use existing views but looking data inside the views which have multiple records so it's hard to use ID which makes unique records. I was thinking to add ROW_NUMBER() to create Unique Key for…

SQL Server Database Engine
asked 2026-01-28T02:53:43.0233333+00:00
pdsqsql 436 Reputation points
edited an answer 2026-02-03T08:52:58.6433333+00:00
kagiyama yutaka 0 Reputation points
2 answers

How to recover from and MSDB database in “suspect” mode

Dear community, My SQL server MSDB DB is in suspect mode and i have no backup, i have tried to repair it to no avail, i have also run a full SQL repair which completeted successfully but i still have the error. Please advise on how i can repair…

SQL Server Database Engine
asked 2026-01-29T06:07:27.2133333+00:00
Rab Processors 0 Reputation points
commented 2026-02-03T08:52:49.0666667+00:00
Shruti Dhruv 800 Reputation points Microsoft External Staff Moderator
4 answers

issue in SSMS 2022

#ssms Hi, I am using below SSMS. I have never seen this before. I am on SSMS and trying to right click on a stored proc and then modify it. But most of the times right click does not bring back anything, like modify etc. But sometimes it does. I have…

SQL Server | Other
asked 2026-02-02T22:37:53.8566667+00:00
panlondon1 21 Reputation points
recommended 2026-02-03T07:39:54.3233333+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
3 answers One of the answers was accepted by the question author.

Databasemail stops working on SQL Server 2025 after CU1 install

We have server with SQL Server 2025 RTM that works fine but when we install CU1 for SQL Server 2025 the databasemail stops sending mail from SQL Server, nor error message no mail reach mailbox. SQL Server version 17.0.4005.7

SQL Server Database Engine
asked 2026-01-20T18:20:29.8566667+00:00
Micael Carlsson 26 Reputation points
accepted 2026-02-03T07:29:09.05+00:00
Micael Carlsson 26 Reputation points
2 answers One of the answers was accepted by the question author.

How to create initial full backup followed by transaction logs daily?

This is related to work. I have been sending out a full-back up of a database in BAK file format (using SQL Server 2022) for a client, but now the client is asking for an initial full backup followed by transaction logs daily. How do I go about doing it…

SQL Server | SQL Server Transact-SQL
asked 2026-01-30T18:06:58.63+00:00
Justin Doh 960 Reputation points
accepted 2026-02-02T22:54:33.1266667+00:00
Justin Doh 960 Reputation points
1 answer

Power BI Question

I have a table from a SQL server. When I want to see specific data via a visual based on a name I select, it self-filters certain things. My table is called WidgetHistory. The column I want to pull data from is CurrentStatusID. I need to see all widgets…

SQL Server | Other
asked 2026-02-02T16:31:32.9766667+00:00
DukeNukem 0 Reputation points
commented 2026-02-02T22:19:46.4766667+00:00
Marcin Policht 75,675 Reputation points MVP Volunteer Moderator
2 answers

Official request to obtain the installer for SSMA for Oracle v7.x

Since the source environment is a legacy Oracle 10g, I would like to obtain the installer for SSMA for Oracle v7.x.

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.
593 questions
asked 2026-02-02T05:30:39.6066667+00:00
義教 平田 0 Reputation points
answered 2026-02-02T22:12:00.89+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

Unable to install SQL server (Setup.exe) Exit code:-2061893606

I am unable to install 2025 SQL server Express Edition. The OOps message pops up at the very end which says: Unable to install SQL server (Setup.exe) Exit code:-2061893606. Wait on the database engine recovery handle failed. Check the error log.

SQL Server | Other
asked 2026-02-02T14:59:06.57+00:00
NGUYEN VINH 0 Reputation points
answered 2026-02-02T22:04:04.76+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
2 answers

How to fix the identity issue in sql server 2025 AI feature while setting up Vector features

I am currently doing POC to explore SQL Server 2025 AI Feature in which I tried to set up Vector features. I am able to create scoped credential and external model but when I do the select statement it gives an error : here is the select state : SELECT…

SQL Server Database Engine
asked 2026-01-21T11:50:19.3833333+00:00
Venugopal, Kamalakkannan 0 Reputation points
commented 2026-02-02T21:36:03.31+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

Microsoft ACE.OLEDB.12.0 is not registered while import excel file

Microsoft ACE.OLEDB.12.0 is not registered -

SQL Server Database Engine
asked 2026-01-27T08:59:23.8633333+00:00
Noseda, Enzo 0 Reputation points
commented 2026-02-02T20:57:45.92+00:00
Erland Sommarskog 132K Reputation points MVP Volunteer Moderator
1 answer

SQL Server 2019 is not working

I went to update my Yearlie payroll tax program, and it now says that an error occurred while establishing a connection to the server. I contacted Yearlie and they spent a total of 12 hours on my computer and could not seem to fix the problem. They…

SQL Server Database Engine
asked 2026-01-12T17:14:37.2466667+00:00
Kathleen Bourcier 0 Reputation points
commented 2026-02-02T17:01:43.03+00:00
Kathleen Bourcier 0 Reputation points