18,185 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer

SSRS Report Server 22 Native Scale Out with a network Load Balancer not working as expected.

I have setup a 2022 SQL Instance. Using the DB from a 2012 r2 instance. I have looked over documentation. I can only get the last report server joined to the instance to display the webserver and the reports server. Example node1, 2 and 3 were installed…

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,934 questions
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,832 questions
asked 2024-05-29T23:10:13.39+00:00
AP 0 Reputation points
commented 2024-05-30T17:44:32.07+00:00
AP 0 Reputation points
2 answers

Hash table creation issue in Sql server

I have created hash table in outer procedure with 2 columns and trying to create another hash table with same name but 3 columns. Now if i try to insert into hash table in inner procedure i get error saying not able to access third column (which was not…

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,934 questions
asked 2024-05-30T09:15:06.0866667+00:00
yashwin g shetty 20 Reputation points
answered 2024-05-30T17:43:26.0033333+00:00
Zahid Butt 556 Reputation points
0 answers

Errors on some reports after upgrading to16.0.8886.1775 (SQLServerReportingServices_16.0.1115.92.exe dated 5/1)

After upgrading we get this error on multiple (not all) reports "The Hidden expression for the tablix 'table1' contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=4.0.0.0,…

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,832 questions
asked 2024-05-30T16:41:17.3866667+00:00
Kehoe, Tim 0 Reputation points
1 answer One of the answers was accepted by the question author.

Benefits and disadvantages of WITH (NOLOCK)

Benefits and disadvantages of WITH (NOLOCK). Also is there other commands that can serve different use cases.

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,934 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,566 questions
asked 2024-05-30T15:12:46.18+00:00
Jonathan Brotto 80 Reputation points
accepted 2024-05-30T15:37:38.99+00:00
Jonathan Brotto 80 Reputation points
1 answer One of the answers was accepted by the question author.

Cannot alter column because it is 'ROWGUIDCOL'

After restoring a database one of my columns was changed from NULL to newid(). I tried to run ALTER TABLE Table1 ALTER COLUMN Id uniqueidentifier NULL script and I got 'Cannot alter column Id because it is 'ROWGUIDCOL'

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,934 questions
asked 2024-05-30T09:28:42.0733333+00:00
Ludmil G 81 Reputation points
accepted 2024-05-30T15:25:46.4366667+00:00
Ludmil G 81 Reputation points
1 answer

Help required with SQL Server

Hi Team, Could you please reply to below 2 points - I have a requirement where I need to identify all windows machines where Microsoft SQL Server is installed (any version). To identify I have gone to control panel of each machine(inside uninstall and…

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,934 questions
asked 2024-05-30T10:08:43.63+00:00
Salil Singh 20 Reputation points
commented 2024-05-30T14:36:51.6766667+00:00
Salil Singh 20 Reputation points
2 answers One of the answers was accepted by the question author.

Availability Groups in depth

Hi, I want in depth information on Availability Groups. Any link that I can read?

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,934 questions
asked 2024-05-28T04:30:49.72+00:00
Chaitanya Kiran 736 Reputation points
accepted 2024-05-30T14:18:53.6666667+00:00
Chaitanya Kiran 736 Reputation points
5 answers

Upgrade required

Hi Team, I am having SQL Server 2022 Developer edition on my windows machine. I need to upgrade below (to avoid any security vulnerability) - SQL Server 2022 Developer edition OLEDB ODBC Please let me know the steps(links) for same. Let me know if…

SQL Server on Azure Virtual Machines
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,934 questions
asked 2024-05-29T18:03:08.4666667+00:00
Salil Singh 20 Reputation points
commented 2024-05-30T13:52:50.71+00:00
Ben Miller-(DBADuck) 0 Reputation points MVP
0 answers

SQL managed instance stopped saying I got the vCore 720 reached

I've create a resource of SQL managed instance with the new offer of free vCore 720 hours/month for 12 months. But after 2 weeks the database stopped saying I got the vCore 720 reached. Is that right? I've created just 1 database in the instance. How can…

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,934 questions
asked 2024-05-30T08:48:39.2433333+00:00
GK 0 Reputation points
commented 2024-05-30T08:59:32.8366667+00:00
GK 0 Reputation points
1 answer One of the answers was accepted by the question author.

"Sync to other databases" is missing

Under Data management, select Sync to other databases is missing, I'm the Global Admin / Owner of the Database and Subscription so I think this can't be an access Issue.

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,934 questions
asked 2024-05-29T08:24:57.7533333+00:00
Erick Rae Q. Nobleza 20 Reputation points
accepted 2024-05-30T08:47:23.92+00:00
Erick Rae Q. Nobleza 20 Reputation points
1 answer

can you guys help me, I always get this error when importing management studio sql files.

The given value '24,269' of type String from the data source cannot be converted to type int for Column 7 [rating_count]. (Microsoft.Data.SqlClient) Failed to convert parameter value from a String to a Int32. (Microsoft.Data.SqlClient) Input string was…

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,934 questions
asked 2024-05-30T08:14:13.89+00:00
muhammad fajar 0 Reputation points
answered 2024-05-30T08:33:48.96+00:00
Olaf Helper 41,571 Reputation points
1 answer

SQL Server 2022 Express installation - how to fix 'error while checking Rules of Sql Server set up'?

Hello, I am having trouble installing SQL Server 2022 Express Edition, Basic installation type. I keep getting this error during installation: "There was an error while checking Rules of Sql Server setup" I have so far tried: Restarting my…

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,934 questions
asked 2024-05-29T12:02:47.3133333+00:00
Mariel 0 Reputation points
commented 2024-05-30T08:25:08.2166667+00:00
MikeyQiao-MSFT 660 Reputation points Microsoft Vendor
0 answers

Microsoft (R) Visual Basic Compiler asking the upgrade the version.

We are trying to Execute SSRS report using rs.exe and will store result in CSV file. For this We have prepared (.rss) file, and executed from command prompt with following command. rs -i filename.rss -s https://server_name/ReportServer -v…

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,832 questions
.NET F#
.NET F#
.NET: Microsoft Technologies based on the .NET software framework.F#: A strongly typed, multi-paradigm programming language developed by the F# Software Foundation, Microsoft, and open contributors.
97 questions
asked 2024-05-29T09:11:40.0433333+00:00
Kalee Mamillapalli 0 Reputation points
edited the question 2024-05-30T08:21:07.9366667+00:00
Jiachen Li-MSFT 27,401 Reputation points Microsoft Vendor
0 answers

SQL SPNs for 2 Node AON Cluster with 2x Instances and custom Ports

Hi everybody, I read so many different suggestions in different forums and blog artciles that it made me question my understanding about the proper SPN registration for SQL. I have a pretty standard setup: 2 Node Cluster consisting of: …

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,934 questions
asked 2024-05-30T08:00:27.4866667+00:00
SChalakov 10,271 Reputation points MVP
edited the question 2024-05-30T08:05:01.86+00:00
SChalakov 10,271 Reputation points MVP
1 answer

How to fix issue in prepapred statement on jdbc driver 12.6.1 jre11

Recently we have upgrade the SQL JDBC driver from version 4 to version 12.6.2 jre11 as we upgraded to 2022 SQL server. After changing the driver we are facing issue in prepared statement. The same code with 12.6.2 jre8 and java8 returning results . But…

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,934 questions
asked 2024-05-10T13:49:21.6766667+00:00
Dhamodharan M 0 Reputation points
commented 2024-05-30T07:58:55.31+00:00
MikeyQiao-MSFT 660 Reputation points Microsoft Vendor
4 answers

Can a deadlock issue be raise while running two select queries in sql server

Do we get a deadlock issue while running two select statements of two different table in sql server

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,934 questions
asked 2024-05-24T13:21:28.4666667+00:00
Khan-CW, P Ali Altaf 63769 0 Reputation points
edited a comment 2024-05-30T07:39:44.5733333+00:00
LucyChenMSFT-4874 1,660 Reputation points
1 answer

exit code (decimal): -2068052377error description: invalid command line argument. consult the window installer sdk for detailed command line help

This morning I was still able to use sql, I was curious and deleted something like SQLEXPRESS16, then I uninstalled all sql and reinstalled it all, and used quite a few cmd commands that I didn't know to uninstall but still nothing. I can't remove them,…

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,934 questions
asked 2024-05-29T14:08:19.1766667+00:00
Dukanhh 0 Reputation points
commented 2024-05-30T07:34:30.4766667+00:00
MikeyQiao-MSFT 660 Reputation points Microsoft Vendor
1 answer

Seeking Expertise in Spark SQL CTE Recursive Queries in Azure Databricks

I'm currently diving deep into Spark SQL and its capabilities, and I'm facing an interesting challenge. I'm eager to learn how to write CTE recursive queries in Spark SQL, but after thorough research, it seems that Spark doesn't natively support…

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,498 questions
Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,981 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,934 questions
asked 2024-05-30T04:27:35.4+00:00
Anuj, Singh (Cognizant) 50 Reputation points
answered 2024-05-30T06:20:08.11+00:00
CosmogHong-MSFT 23,951 Reputation points Microsoft Vendor
2 answers

In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role.

In my application SQL Server 2019 is already supported, I want to it will support SQL Server 2022 also and ODBC 18 driver. For this scenario does SQL Server Native Client comes into any kind of role. If yes then what is that. Do I need to install SQL…

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,934 questions
asked 2024-05-30T02:59:59.6566667+00:00
Mahesh Kumar 20 Reputation points
answered 2024-05-30T06:06:30.0933333+00:00
Olaf Helper 41,571 Reputation points
2 answers One of the answers was accepted by the question author.

Hyper-V replica - EnableWriteOrderPreservationAcrossDisk for SQL VM not working

According to Support policy for hardware virtualization product - SQL Server | Microsoft Learn, Hyper-V replica for a VM running SQL server is a supported scenario as long as you enable EnableWriteOrderPreservationAcrossDisks as described in 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,934 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,328 questions
Hyper-V
Hyper-V
A Windows technology providing a hypervisor-based virtualization solution enabling customers to consolidate workloads onto a single server.
2,583 questions
asked 2024-05-28T06:44:01.8033333+00:00
Stefanos Papaefthimiou 20 Reputation points
answered 2024-05-30T05:26:49.64+00:00
Stefanos Papaefthimiou 20 Reputation points