20,349 questions with SQL Server-related tags

Sort by: Updated
0 answers

Cannot figure out why I'm getting this error: Msg 102, Level 15, State 1, Line 74 Incorrect syntax near ')'

Pretty new to SQL, I keep getting an error on the final bracket at the end of the code, but I can't figure it out. Anyone see any reasons? ;with cte as ( SELECT SampleID ,SetpointID ,CDPercentDiff ,AuditID ,pointrn = ROW_NUMBER() OVER…

SQL Server Database Engine
asked 2025-04-24T21:13:12.1866667+00:00
FSI 0 Reputation points
1 answer

SQL Server Limitations that aren't Solved

I use Sql Server 2022. I'm running Select queries using hundreds of words, and I need to know, for each matching record, which words were found. After running the Select query, I now have to run hundreds of searches for each word in each record, and…

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.
174 questions
asked 2025-04-23T23:52:20.8133333+00:00
Central data 156 Reputation points
commented 2025-04-24T19:49:24.1033333+00:00
Yitzhak Khabinsky 26,486 Reputation points
0 answers

Third party backup tools for SQL server

Anyone please share a few names of good and faster backup tools for SQL server? Preferably a snapshot of physical file backup It is for stand-alone server and should support VM too.

SQL Server Database Engine
asked 2025-04-24T18:18:03.1466667+00:00
Asharaf Pattarathil 0 Reputation points
edited the question 2025-04-24T18:19:32.2733333+00:00
Asharaf Pattarathil 0 Reputation points
3 answers One of the answers was accepted by the question author.

Small Dialog boxes in SQL Server Management Studio (SSMS) 18.9.2

After installing SSMS 18.9.2 on SQL 2016 server (Windows Server 2016) all dialogs of SSMS contain very small fonts...in some cases the fonts are so small that the slider bar covers up all text (i.e. Help-->About). Is there a way to have the dialogs…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2021-12-11T16:23:24.11+00:00
Wade Nederveld 26 Reputation points
edited a comment 2025-04-24T17:02:54.96+00:00
Louie C 0 Reputation points
3 answers

SSMS does not support <Ctrl>E for Execute any more

My SQL Server Management Studio 21.1 does not recognise single key commands such as <Ctrl>E (execute) or <Ctrl>R (show/hide result pane) I had first installed SSMS 21.1 and something happened after a few days so that when I started SSMS.exe…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2024-06-12T20:10:41.1033333+00:00
Eric Mamet 365 111 Reputation points
commented 2025-04-24T15:25:35.8966667+00:00
AbG3 1 Reputation point
0 answers

How to migrate large tables of size around 30gb from sql server 2014 to sql server 2022?

Hi , what would be the best way to migrate table of size 30 GB from sql server 2014 to sql server 2022?

SQL Server Database Engine
asked 2025-04-22T18:29:14.89+00:00
Kumari, Dimpy 0 Reputation points
commented 2025-04-24T14:36:17.25+00:00
Kumari, Dimpy 0 Reputation points
1 answer

MS SQL Installation error - The mof compiler could not connect with the wmi server

I tried to reinstall MS SQL 2022 server but I am facing the below error. title: microsoft sql server 2022 setup ------------------------------ the following error has occurred: the mof compiler could not connect with the wmi server. this is either…

SQL Server Database Engine
asked 2025-04-24T08:39:26.18+00:00
Rabin Mahato 0 Reputation points
answered 2025-04-24T14:08:43.8666667+00:00
Shubham Yadav 0 Reputation points
4 answers One of the answers was accepted by the question author.

how to change tabular mode to multidimensional model?

Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,338 questions
asked 2021-09-23T02:32:42.227+00:00
ismepopola 76 Reputation points
commented 2025-04-24T13:08:11.2833333+00:00
Michael Bartlett 0 Reputation points
1 answer

MSSQL Windows Server Failover Cluster - Cluster IP address already in use

Hello, I have a cluster named "ClusterMain" that contains three nodes: N1, N2, and N3. Everything was working fine until N3 suddenly started misbehaving and became isolated from the cluster. Currently, N1 and N2 are functioning normally within…

SQL Server Database Engine
asked 2025-04-23T20:26:47.6466667+00:00
Quadra 0 Reputation points
commented 2025-04-24T12:21:52.5933333+00:00
Quadra 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to recover the deleted Mysql resource database

Restore the deleted resource Mysql database backup ,i can't find the deleted resource in the deleted resource list , it was deleted accidently few hours before only

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,037 questions
asked 2025-04-24T03:59:53.4633333+00:00
Lavanya Yatin 20 Reputation points
commented 2025-04-24T12:06:48.9133333+00:00
Shikha Ghildiyal 4,705 Reputation points Microsoft Employee
0 answers

WSFC Issues with Node failing Over but the Roles stay on the old primary

Hi Hope someone can help me out here, last couple of nights our WSFC has failed over, The servers have not been restarted but the Primary Node failed over to the Secondary node, though none of the Availability Groups moved with the failover, all the…

SQL Server Database Engine
asked 2025-04-24T08:30:40.1133333+00:00
Clive Wightman 146 Reputation points
2 answers

Errors to run some custom reports after migration

Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type…

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,037 questions
Microsoft Configuration Manager
asked 2023-11-21T16:42:52.0966667+00:00
Claudio Santini 0 Reputation points
commented 2025-04-24T06:29:34.85+00:00
Filip Aiello 0 Reputation points
1 answer

SQL Server Installation

I am not able to Install the SQL Server on my laptop, i have been trying since last 3days. all times there are showing common errors Please help me out

SQL Server Database Engine
asked 2025-04-23T17:11:58.24+00:00
Shanmukha Rao Chintada 0 Reputation points
answered 2025-04-24T06:25:34.2566667+00:00
Olaf Helper 46,546 Reputation points
1 answer

Query related to length in CAST and Output clause

Hi Team, Could you please reply to below queries - Using CAST, I need to convert BigInt and Datetime2 values to Varchar. How could I be sure on the length that I need to use (in CAST) to convert these values to Varchar. I am using Update statement…

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.
174 questions
asked 2025-04-22T18:21:46.98+00:00
Salil Singh 40 Reputation points
answered 2025-04-24T06:20:32.56+00:00
Olaf Helper 46,546 Reputation points
1 answer

BCP OUT/IN, What is native format and its usage. I am planning to use BCP out/in to export & Import table data from source to target and would like to know which is the best option when my data contains special character inside it and also have some email

BCP native format when to use when not to use. Is there any alternative BCP utility to export and import data from source to target table

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.
174 questions
asked 2025-04-24T05:15:22.5166667+00:00
C, Manoharan (Cognizant) 40 Reputation points
answered 2025-04-24T06:12:34.9+00:00
Olaf Helper 46,546 Reputation points
2 answers One of the answers was accepted by the question author.

Can I convert a database field from binary to a PDF file in SQL Server?

I have a SQL Server database in which there are PDF documents stored in a column with the binary data type. I need to figure out how to get the actual PDF document out.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
asked 2023-06-23T17:56:16.4533333+00:00
Romelfanger, Matt 20 Reputation points
commented 2025-04-23T23:46:34.4166667+00:00
J Gonzalez 46 Reputation points
0 answers

Unable to Silent install SQLServerReportingServices.exe version 2022 Version: 16.0.1117.32

Unable to silent install SQLServerReportingServices.exe**.** It runs for a few seconds and then exits. No log. No folder created in C:\program files. Double clicking this exe will launch the GUI installer and installs without issue. Downloaded…

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,037 questions
asked 2025-04-23T20:53:26.99+00:00
Ryan Naylor 0 Reputation points
1 answer

How come I can no longer put in a support ticket via Azure? It takes me here now.

Resource ID : 1. The request limit for the database is 60 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance. (Framework Microsoft SqlClient Data Provider)

SQL Server Database Engine
asked 2025-04-21T19:59:16.24+00:00
Greg Smith 0 Reputation points
commented 2025-04-23T19:59:23.7233333+00:00
TP 118K Reputation points
0 answers

How to recover the Azure sql flexible server database from the deleted resource

My resource is accidently deleted need to get the backup of the mysql database from the deleted resources how should i get it .

SQL Server Database Engine
asked 2025-04-23T19:29:54.5066667+00:00
Lavanya Yatin 20 Reputation points
1 answer

Vulnerable and Outdated Components in SSRS

When we performed Burp Suite Professional scan for SSRS module, we have come across different vulnerable and outdated components which are listed below : jquery version 3.1.1 angularjs version 1.5.7 moment.js version 2.14.1 bootstrap version 3.3.5 can…

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,037 questions
asked 2025-04-22T06:41:49.02+00:00
Akshayaa Kalyanavenkatesh 40 Reputation points
commented 2025-04-23T09:35:19.74+00:00
Akshayaa Kalyanavenkatesh 40 Reputation points