SQL Server | Other

This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

When I create a table in SQL, after right-clicking on the table name and selecting the design option, it gives this error: This backend version is not supported to design database diagrams or tables. (MS Visual Database Tools)

Updating Dynamics GP 2018 generates "The stored procedure smGrantAccessOnAccountMSTR returned the following results: DBMS: 0 Microsoft Dynamics GP:" while updating our company database.

We have been attempting to upgrade our Dynamics GP version 18.5.1596 (2002) to version 18.8.1957 (2026). After installing the msp file, we run the GP 2018 Utilities application to update the databases. The DYNAMICS database completes, and then it moves…

Unable to access SQL Database for Get data in Power BI Lab

I am having trouble connecting to the SQL database in the first Lab. To complete the Get data in Power BI Lab, I must have access to SQL Server. I keep getting an error message when I try to open SQL Server in Power BI. I get this error message…

SQL LICENSE

I have a product key, and I'd like to know what type of license it corresponds to.

how to override the database selected in the available database dropdown

I need to union results from two databases using fully qualified objects/views but the query after the union returns zero rows.

sql server job is not running based on schedule

hi all: I have a very interesting case . There is a Database Full backup job and it had a schedule to run on a daily basis at 12am. I've changed it to run on a weekly basis but after a few days, I was surprised to find that this job was still…

How to add table permission in Power platform entity

How to add table permission in Power platform entity

Restoring last SQL transaction log

Hi expert, I've ended my large DB from Log shipping process and it has many transaction log files created, and now how to make my DB on secondary instance taking online? what is the steps should I do? great thanks & appreciation for all reply warmest…

How to enable SQL Server linked server credential delegation on Linux?

I have two SQL Server instances, "main" and "linked", deployed on Docker, and both are configured for Active Directory authentication using a local test AD. I want to add "linked" as a linked server on "main", and…

EOpen Sql Server 2019 Standart Lisans anahtarını bulmak istiyorum.

Merhaba, elimizde lisans ayrıntı numarası ve Ana program numaraları mevcut fakat kurulum için lisans anahtarına ihtiyacımız var. Satın aldığımız firma portalına ulaşamıyor. Kurulum için anahtara ihtiyacımız var ve biz Microsofta da ulaşamıyoruz konu…

SQL Snapshot Replication Fails with BCP EOF / NULL Errors (Works in Transactional Replication)

Issue: We have Snapshot Replication on a production server that was working fine but recently started failing with the below error: Agent message code 20037. The process could not bulk copy into table "XXX". Message: End of file…

Licensing Query: Downgrade Rights clarity on Active SQL Server Subscription purchased via CSP

Hi, I have been trying to get something official reference that explicitly confirms the Downgrade Rights for CSP Subscriptions, specifically as an example: Active subscription purchased via CSP for 'SQL Server Standard 2022 - 2 core license pack - 1…

Microsoft SQL Server Security Update download

Microsoft has released a fix for this flaw in their April 2026 Security Update. Please download and install the patch from the Microsoft Update Catalog. Where can I get the download file?

where is KB5094123?

where can I download Microsoft SQL Server Security Update for SQL server 2019?

SQL Server 2019 Table lock and wont unlock until restarting database

We are running Microsoft SQL Server 2019 (RTM-CU32-GDR) and a specific database table seems to lock and never unlocks. It also locks all associated tables. The only way to get the database to respond is wait for it to restart or restart the entire SQL…

Can we get the T-SQL debugger back?

How can I browbeat Microsoft to re-enable the debugger in SSMS? I tried using SSDT in Visual Studio 2022, and it was absurd ... I had to spend fifteen minutes creating a new project, importing the database, etc. only to be told, when I started trying to…

Sequel Server Reporting Services - are there any wildcard characters that you can use in the filter fields?

In the Sequel Server Reporting Services, are there any wildcard characters that you can use in the filter fields such as a customer name field?

SQL 2022 Express Replication with error

The error says "The process could not connect to Publisher"

Need to request a report from a Small Package customer that is requesting the Entry Summary from past shipments

Hi, I need to know if in SSRS, I can generate a report of the Entre Summary from a Small Package Customer.. See below the type of Image Im looking for.. Could you guide me, on wich report should I select ?

I am encountering an issue while installing Microsoft SQL Server 2022 Express Edition. The installation fails with the following error: Product: SQL Server 2022 Express Edition Operating System: Windows (please specify your version) Error Code: -20618936