17,265 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

I can't start the MSSQLSERVER on new esxi host

I am a student currently studying virtualization and SQL installation for one of my projects apkbeb. After obtaining approval from my instrcutor, I attempted to transfer a virtual machine (VM) to my personal laptop. However, upon doing so, I encountered…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-07T11:39:26.0633333+00:00
ahmedbark 0 Reputation points
answered 2024-05-08T05:30:37.49+00:00
LucyChen-MSFT 1,120 Reputation points Microsoft Vendor
1 answer

SQL Connectivity Issue From Cloud app to on-prem server

hi, I have deployed a .net core MVC app in azure app service as a webapp. I have to connect to a on-prem sql server to retrieve data. I have setup Azure relay/hybrid connection for the same. Also I have installed hybrid connection manager in on-prem…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,199 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,931 questions
asked 2024-05-07T10:38:07.05+00:00
Santhi Dhanuskodi 145 Reputation points
answered 2024-05-08T05:05:00.6333333+00:00
Olaf Helper 40,901 Reputation points
1 answer

Change the code and used in existing Views

Hi There is Scalar UDF used many places in views and SP. I need to change the Scalar UDF from all views and SPs. What is the alternate way to replace it. Is it good that I can replace the Scalar UDF with Inline table valued function. Appreciate your…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-07T12:57:39.02+00:00
SVA 86 Reputation points
answered 2024-05-08T05:00:58.7+00:00
Olaf Helper 40,901 Reputation points
1 answer

When I apply the latest patches cu in the SQL server 2022 version. It uses high memory. What is the reason? It will happen sometimes or regular

When I apply the latest patches cu in the SQL server 2022 version. It is using high memory. What is the reason? It will happen sometimes or regular.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-08T02:53:41.3533333+00:00
Anandhswarupp 20 Reputation points
answered 2024-05-08T04:57:33.4+00:00
Olaf Helper 40,901 Reputation points
2 answers

Downloading the Server

I am not able to download the developer version of the SQL server 2022. It shows the same message again and again. What shall be done and why is it showing so? Kindly, have a look at the picture below. It's the message the pops-up repeatedly. Screenshot…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-07T13:04:36.5366667+00:00
Yashvi Govil 0 Reputation points
answered 2024-05-08T02:34:34.84+00:00
MikeyQiao-MSFT 560 Reputation points Microsoft Vendor
1 answer

How to pass multiple value for a postgres function in SSRS

I have created a report which is using postgres sql function and there are parameters for start date, end date and physician name. I am trying to pass multiple value for physician name and it is not working for me: This is how I am calling the function…

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.
2,808 questions
asked 2024-05-07T14:10:33.6366667+00:00
Ali Ahad 91 Reputation points
answered 2024-05-08T02:23:42.25+00:00
ZoeHui-MSFT 33,211 Reputation points
1 answer

¿Existe una url oficial donde me digan que tipo de licencia de SQL server necesito para replicar 5 bases de sucursales a una base centralizada?

podrían darme información oficial de favor para poder utilizar cualquier tipo de replicación https://learn.microsoft.com/es-es/sql/relational-databases/replication/types-of-replication?view=sql-server-ver16 y cual licencia debo comprar para pode…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-07T16:47:19.06+00:00
rojobanc 0 Reputation points
edited a comment 2024-05-08T01:31:42.1566667+00:00
LucyChen-MSFT 1,120 Reputation points Microsoft Vendor
2 answers

SSMS 20.1 Unable to see SSIS Execution Properties

Ever since I installed SSMS 20.1, I've been unable to look up the properties in SSIS jobs. I'm aware that 20.1 has changed the way connections are made but my connection is set up with "Trust server certificate" and multiple menus error…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
asked 2024-05-07T12:59:51.8066667+00:00
Michel Lalancette 0 Reputation points
answered 2024-05-08T01:29:33.76+00:00
ZoeHui-MSFT 33,211 Reputation points
2 answers

Error description: The system cannot find the path specified while installing SQL server management studio

I am facing an error while installing Microsoft SQL Server 2022, In the log file the error says : Component name: SQL Server Database Engine Services Instance Features Component error code: 0x80004005 Error description: …

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-06T16:23:40.68+00:00
Nikita Gaur 0 Reputation points
answered 2024-05-07T21:01:20.62+00:00
Erland Sommarskog 101.4K Reputation points MVP
1 answer

Access network folder and files from .NET Core application in IIS

Greetings, I have an application deployed in IIS with .NET Core 7 and SQL Server, I want to access a network path, write and read files within a folder in the path (\path\folder) What steps should I follow to achieve this?

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,199 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-07T17:35:39.8066667+00:00
Juan A. Reyes Paulino 20 Reputation points
answered 2024-05-07T20:42:31.8533333+00:00
Bruce (SqlWork.com) 56,846 Reputation points
3 answers

SQL SERVER 2022 - certificate error when creating a job for integration services

In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,459 questions
asked 2024-04-10T03:35:21.82+00:00
Marcio Matos 5 Reputation points
commented 2024-05-07T17:07:21.5333333+00:00
4310-gfi 0 Reputation points
1 answer

I can see latest jar of MSSQL jdbc version 12.6.1.jre11 has Vulnerabilities in one of the dependent in built library

In our java application, we are using MSSQL jdbc and to remediate Vulnerabilities, we have upgraded our jar to latest version 12.6.1, but even it shows SCA Vulnerability in one of the inbuilt dependent as shown in below…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-06T14:41:54.67+00:00
Peruka, Himaja 0 Reputation points
edited a comment 2024-05-07T16:08:26.6466667+00:00
Peruka, Himaja 0 Reputation points
2 answers

Enterprise Report Server not showing Data Driven Subscriptions

We have updgraded from Standard to Enterprise reporting services. We were expecting to have the option to create data-driven subscriptions but the option is not available. All the articles found during our web search say 'Data-driven subscriptions' will…

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.
2,808 questions
asked 2024-04-29T21:26:46.1566667+00:00
Linda 1 Reputation point
commented 2024-05-07T15:29:41.5566667+00:00
Linda 1 Reputation point
2 answers

How to fix NT AUTHORITY\ANONYMOUS LOGON login failure during MS SQL Server installation

Hi - I'm trying to install MS SQL Server on Microsoft Windows Server 2022 Standard 10.0.20348 Build 20348. I've tried installing both MS SQL Server 2019 and 2022. The installation fails with: Detailed results: Feature: Database…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-02T14:35:00.5566667+00:00
Lemons, Terry 1 Reputation point
commented 2024-05-07T13:19:06.6166667+00:00
Lemons, Terry 1 Reputation point
4 answers One of the answers was accepted by the question author.

Is there a 64 bit SSMS?

I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2021-09-29T11:48:06.173+00:00
子明 李 21 Reputation points
commented 2024-05-07T10:37:11.39+00:00
Vladimir Bazanov 0 Reputation points
3 answers One of the answers was accepted by the question author.

Power BI Reporting Server on Standard DB Engine

Is it possible for the .pbix files to work correctly when the Power BI reporting server (PBIRS) is installed on a Standard DB Engine? According to the below link, it looks contradictory as while it states that Standard edition is possible, it also…

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.
2,808 questions
asked 2024-05-01T18:27:45.1366667+00:00
Jessy 20 Reputation points
accepted 2024-05-07T09:24:20.3433333+00:00
Jessy 20 Reputation points
2 answers

The transaction log for database is full due to 'REPLICATION'

Hi! I have a SQL 2019 database that is a member of 3 node always on availability group. It is also the subscriber being populated from a DB2 database. The log keeps filling up and I am unable to shrink or backup.. I get the message: The transaction log…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
asked 2022-04-25T08:33:47.077+00:00
zoe Ohara 286 Reputation points
commented 2024-05-07T09:12:45.76+00:00
Rishi Sethi 0 Reputation points
2 answers One of the answers was accepted by the question author.

Integration service on dedicated SQL instance

Based on an assessment I did on a client's server, I have to move all the integration services to a dedicated machine. We decided to separate ETL and data on two machines. My question is: having a dedicated instance, how do I manage the memory CAP on…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-06T09:26:30.6333333+00:00
Alen Cappelletti 911 Reputation points
accepted 2024-05-07T07:29:42.83+00:00
Alen Cappelletti 911 Reputation points
1 answer

Scripting out 'Create Merge Replication' does not include 'processing_order'

We use Merge Replication and have defined a specific 'processing_order' for the Articles in the Publication. The Articles include tables, functions and stored procedures. When we want to setup or refresh a test environment, we will script out the…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2024-05-03T03:20:20.6466667+00:00
Greg Youdale 5 Reputation points
commented 2024-05-07T06:16:19.72+00:00
Greg Youdale 5 Reputation points
4 answers One of the answers was accepted by the question author.

How to install sql server on windows 11 using UTM on mac,

Hello everyone Please help me. I am stuck here for 2 days. I am trying to install sqlserver 2022 on windows 11 using UTM on mac m1. I am getting this error.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,776 questions
asked 2023-01-25T16:38:55.61+00:00
Malik Allahyar Nawabi 20 Reputation points
commented 2024-05-07T02:53:33.55+00:00
Merna 0 Reputation points