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
0 answers
How can I run an automation template
I want to run an automation template for a sql database deployed with ARM. The aim is to trigger a stored procedure
asked 2024-05-08T00:16:54.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 0%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Oyin
0
Reputation points
edited the question 2024-05-08T02:56:06.3966667+00:00
PRADEEPCHEEKATLA-MSFT
77,901
Reputation points Microsoft Employee
0 answers
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.
asked 2024-05-08T02:53:41.3533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 73%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anandhswarupp
20
Reputation points
asked 2024-05-08T02:53:41.3533333+00:00
Anandhswarupp
20
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…
asked 2024-05-07T13:04:36.5366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 96%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYG%3C/text%3E%3C/svg%3E)
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…
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
0 answers
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…
asked 2024-05-07T12:57:39.02+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SVA
86
Reputation points
commented 2024-05-08T01:51:52.1666667+00:00
CosmogHong-MSFT
23,321
Reputation points Microsoft Vendor
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…
asked 2024-05-07T16:47:19.06+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 62%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
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…
asked 2024-05-07T12:59:51.8066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 63%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EML%3C/text%3E%3C/svg%3E)
Michel Lalancette
0
Reputation points
answered 2024-05-08T01:29:33.76+00:00
ZoeHui-MSFT
33,211
Reputation points
0 answers
User Managed identity with failover group with servers in different regions
while using user managed identity with azure sql , the connection string or token acquired using DefaultAzureCredential is dependent on the clientID of user managed identity. for the scenario when there is a sql failover switch i.e due to outage in one…
asked 2024-05-07T19:44:02.75+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 34%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKK%3C/text%3E%3C/svg%3E)
KAMALPREET KAUR
1
Reputation point Microsoft Employee
commented 2024-05-08T00:45:15.15+00:00
GeethaThatipatri-MSFT
27,717
Reputation points Microsoft Employee
0 answers
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…
asked 2024-05-07T10:38:07.05+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 54%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
Santhi Dhanuskodi
145
Reputation points
commented 2024-05-07T22:46:12.8266667+00:00
Grmacjon-MSFT
16,191
Reputation points
0 answers
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…
asked 2024-05-07T11:39:26.0633333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 81%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ahmedbark
0
Reputation points
commented 2024-05-07T21:39:55.7233333+00:00
Erland Sommarskog
101.4K
Reputation points MVP
0 answers
Ununable to install sql server (setup.exe) Exit code (Decimal): -2147467259 Error description: The service did not respond to the start or control request in a timely fashion.
I'm trying to download SQL express through the installation process it gives me an error Oops... Unable to install sql server (setup.exe) Exit code (Decimal) -2147467259E Error description: The service did not respond to the start or control request in…
asked 2024-04-30T15:39:20.9433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 2%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
moris shehady
0
Reputation points
commented 2024-05-07T21:15:27.4233333+00:00
Erland Sommarskog
101.4K
Reputation points MVP
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: …
asked 2024-05-06T16:23:40.68+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 9%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
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?
asked 2024-05-07T17:35:39.8066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Juan A. Reyes Paulino
20
Reputation points
answered 2024-05-07T20:42:31.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
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 :…
asked 2024-04-10T03:35:21.82+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 98%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marcio Matos
5
Reputation points
commented 2024-05-07T17:07:21.5333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E4G%3C/text%3E%3C/svg%3E)
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…
asked 2024-05-06T14:41:54.67+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 34%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPH%3C/text%3E%3C/svg%3E)
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 72%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
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…
asked 2024-05-02T14:35:00.5566667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 88%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
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.…
asked 2021-09-29T11:48:06.173+00:00
子明 李
21
Reputation points
commented 2024-05-07T10:37:11.39+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 11%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVB%3C/text%3E%3C/svg%3E)
Vladimir Bazanov
0
Reputation points
0 answers
The target principal name is incorrect
Hi Team, I've got the error "The target principal name is incorrect. Cannot generate SSPI context" when I tried to connect to SQL Server from other server. I've checked sql logs and I found info SPN was registered . I've run Kerberos…
asked 2024-05-06T13:06:14.6233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 66%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Marcin Woszczyna
0
Reputation points
commented 2024-05-07T09:39:12.2266667+00:00
MikeyQiao-MSFT
560
Reputation points Microsoft Vendor
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 25%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)