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 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…
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.
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…
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…
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?
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…
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?
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…
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
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…
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 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
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…
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
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.
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…
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)
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 .
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…