18,012 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,784 questions
asked 2024-05-07T11:39:26.0633333+00:00
ahmedbark 0 Reputation points
edited an answer 2024-05-08T05:51:35.43+00:00
LucyChen-MSFT 1,120 Reputation points Microsoft Vendor
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,784 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,916 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,784 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,810 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
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…

Azure SQL 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,784 questions
asked 2024-05-07T19:44:02.75+00:00
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

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…

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,784 questions
asked 2024-04-30T15:39:20.9433333+00:00
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: …

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,784 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
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,810 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,784 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,784 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
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…

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,784 questions
asked 2024-05-06T13:06:14.6233333+00:00
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…

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,810 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,784 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
0 answers

Key store providers cannot be set more than once(Always Encrypted with JDBC and Java 8)

We are trying to use SQL Always Encrypted feature in our Java Web Application. Java 8 is the JRE and uses mssql-jdbc-9.2.1.jre8.jar as the jdbc driver. Azure-Key-vault as the column master key store provider Our application uses below code to…

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,784 questions
asked 2021-11-09T04:53:17.773+00:00
Subin Sankaran 1 Reputation point
commented 2024-05-07T09:07:01.79+00:00
Manjunatha Bhimanna (Aspiresys Consultant) 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,784 questions
asked 2024-05-06T09:26:30.6333333+00:00
Alen Cappelletti 931 Reputation points
accepted 2024-05-07T07:29:42.83+00:00
Alen Cappelletti 931 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,784 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,784 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
0 answers

SetDatabaseConnection WMIMethodException Error

I'm using a slightly modified version of the script found here: https://blog.aelterman.com/2018/01/03/complete-automated-configuration-of-sql-server-2017-reporting-services/. The modification is that I'm pointing to (local)\SQLExpress on line 41 as 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,784 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,093 questions
asked 2024-05-06T19:26:46.2033333+00:00
Mike Horton 0 Reputation points
edited the question 2024-05-07T02:31:33.8733333+00:00
CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
2 answers

Text delimiter file

Hi, I have two tables: one for headers with 9 fields and another for lines with 6 fields. Both header and lines are highlited in yellow. I need to combine both the headers and lines using a UNION operation to display the result below. From the line…

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,784 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
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
46 questions
asked 2024-05-06T14:48:13.48+00:00
Vicki 46 Reputation points
answered 2024-05-07T02:18:28.6533333+00:00
CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor
1 answer

Performance Monitoring tools used for 4 hrs

Using Performance Monitoring tool to check on the performance of the database server. I cannot extend the duration to more than 1000 secs. What are the other options for performance monitoring so that I can get the data for 4 hrs

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,810 questions
asked 2024-05-01T22:28:33+00:00
Avyayah 1,231 Reputation points
commented 2024-05-07T01:08:43.2566667+00:00
CosmogHong-MSFT 23,321 Reputation points Microsoft Vendor