20,034 questions with SQL Server-related tags

Sort by: Updated
3 answers

SSMS v19.0.2 text editor breaks

I'm hoping someone can assist. I am running Win11 Pro and have installed SSMS 19.0.2 - I have a very weird issue that crops up when I open an existing .sql file. The text editor loses 'focus' and I can click the cursor anywhere (as long as 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.
14,485 questions
asked 2023-05-24T13:14:39.1833333+00:00
Chris Mason 0 Reputation points
answered 2025-02-18T21:22:19.3666667+00:00
Paul Rest 0 Reputation points
1 answer One of the answers was accepted by the question author.

Need tsql to find index usage on views

I have some views that have indexes and i want to get their usage - seeks, scan, lookups - but i cannot find the tsql code.

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.
114 questions
asked 2025-01-15T22:35:28+00:00
Grossnickle, Brenda 100 Reputation points
accepted 2025-02-18T21:04:54.8233333+00:00
Grossnickle, Brenda 100 Reputation points
0 answers

How can I connect SSMS to an SSRS instance using the connect dropdown?

Trying to connect to an SSRS instance via SSMS where the ReportServer database is on one server and the SSRS services are on a different server. SSMS is unable to connect, possibly because of firewall rules.

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,485 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,996 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.
14,485 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,996 questions
asked 2025-02-18T20:21:07.21+00:00
Richard Giesbrecht 0 Reputation points
0 answers

How can I connect SSMS to an SSRS instance using the connect dropdown?

Trying to connect to an SSRS instance via SSMS where the ReportServer database is on one server and the SSRS services are on a different server. SSMS is unable to connect, possibly because of firewall rules.

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,485 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,996 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.
14,485 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,996 questions
asked 2025-02-18T20:21:07.21+00:00
Richard Giesbrecht 0 Reputation points
0 answers

Deny URL access if link contains word "/cats" on IIS 10 for Report Server

Good day! I am writing with one question that has been bothering me for several months. IIS 10 and PowerBI Report Server are installed on our Windows Server 2019 server. Access to services is implemented via the URL:…

Internet Information Services
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,996 questions
asked 2025-02-18T19:24:05.1733333+00:00
Sergey Knyazev 0 Reputation points
3 answers

SSMS Import of MS Access accdb external component has thrown an exception (System.Data)

I've been using SQL Server Management Studio for some time to import tables from MS Access into SQL Server. Now I get an error External component has thrown an exception. (System.Data) when I choose an Access database to import from. This worked only a…

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,485 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
422 questions
asked 2024-12-10T09:58:07.5066667+00:00
Richard Williams 10 Reputation points
commented 2025-02-18T19:22:56.72+00:00
Awais_Saad 0 Reputation points
3 answers

Store proc body with select and update

We have store proc in azure sql db which is having select and update statement, with select we don't have any issue but while updating if we are updating less then 14 rows then it's working fine but if we have more then 14 rows then it is 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.
14,485 questions
asked 2025-02-11T15:36:10.77+00:00
Nikhil Somani 0 Reputation points
commented 2025-02-18T18:18:07.1766667+00:00
Mallaiah Sangi 0 Reputation points Microsoft Vendor
0 answers

Region-specific drives for a VM located in Azure AU region

Hi Team, We have a requirement from clients to have the data in the respective data drives, for example - client from US wants to have their data in a drive which is physically located in the azure data centre in US region. We are looking at partitioning…

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,364 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,379 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
3,088 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.
14,485 questions
asked 2025-02-06T23:25:40.6466667+00:00
Berchmans Marcelline 10 Reputation points
commented 2025-02-18T18:13:52.1866667+00:00
Keshavulu Dasari 3,370 Reputation points Microsoft Vendor
2 answers

How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ?

How to get the SQL server cumulative update version installed for Azure Arc Enabled Servers ? I would like to write a query to get which CU is installed on my sql servers managed with Azure Arc. I don't find the exact product version. For instance,…

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
478 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.
14,485 questions
Azure Update Manager
Azure Update Manager
An Azure service to centrally manages updates and compliance at scale.
345 questions
asked 2025-02-17T19:00:55.1133333+00:00
Jean-Marie Roger 0 Reputation points
answered 2025-02-18T18:10:54.0533333+00:00
Pranay Reddy Madireddy 2,085 Reputation points Microsoft Vendor
2 answers

An integration services catalog was not found on this server instance

Hi, One of our developers is getting the error in the title when trying to deploy an integration services package from his laptop using VS 2019. The SQL server is also 2019 (I think) We can confirm the catalog exists as other developers can connect and…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
asked 2025-02-17T08:47:10.6066667+00:00
Farid Ali 0 Reputation points
commented 2025-02-18T17:13:35.42+00:00
Yitzhak Khabinsky 26,376 Reputation points
0 answers

Invoke-SqlVulnerabilityAssessment VA1220 False Fail?

If I run the vulnerability scan on a SQL Server without a cert and force encryption set I get fails on VA1220: Database communication using TDS should protected through TLS Microsoft SQL Server can use Secure Sockets Layer (SSL) or Transport Layer…

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,485 questions
asked 2025-02-18T15:58:36.1333333+00:00
Saransvan 111 Reputation points
2 answers

Microsoft SQL Server Standard 2022, the term "Single Language" means what?

We have chosen below: Product Description : Microsoft® SQL Server Standard 2022 Single Language Now we wanted to know what is Microsoft SQL Server Standard 2022, the term "Single Language" means? Does it means it supports inly one language i.e.…

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,485 questions
asked 2025-02-10T06:42:51.7566667+00:00
Surya Jenna 0 Reputation points
edited the question 2025-02-18T15:57:49.48+00:00
Mike Bowen 1,791 Reputation points Microsoft Employee
3 answers

When attempting to add a second SQL VM to a SQL VM Group getting a ping failure

I can create the SQL VM Group successfully, add the first SQL VM to it and everything works as expected there. The cluster is created and the node is added to it. However, when I attempt to add a second SQL VM I get this error: Error code:…

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,485 questions
asked 2025-02-17T21:43:16.6166667+00:00
Rob Lee 0 Reputation points
commented 2025-02-18T14:45:26.77+00:00
Rob Lee 0 Reputation points
0 answers

Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed

Hi I have added a NewtonSoft. JSON dll in Script task, it is working locally, when deployed and trying to run through SQL Agent Job, getting error as "Could not load file or assembly 'Newtonsoft.Json, Version=13.0.0.0, Culture=neutral,…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
asked 2025-02-18T13:42:53.2+00:00
Ajay Jha 0 Reputation points
4 answers

Document for Backup Restore

Any document/link about backup and restore of MS SQL Server database using Visual Studio Code? Similar to the below one for azure data studio. https://learn.microsoft.com/en-us/azure-data-studio/tutorial-backup-restore-sql-server Thanks!

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.
14,485 questions
asked 2025-02-12T19:29:49.3433333+00:00
GP 16 Reputation points
answered 2025-02-18T12:24:37.8066667+00:00
GP 16 Reputation points
0 answers

How to fix sql server having a stuck ExportDatabase job at 1%, cancelling leads to stuck CancelInProgress instead

We were doing an ExportDatabase operation on our production database. This is part of our release pipeline, to do a backup before deploying new code. The github action timed out eventually since the export job got stuck at 1% and was stuck for 8 hours.…

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.
14,485 questions
asked 2025-02-18T08:04:09.8533333+00:00
Kalle Macklin 0 Reputation points
commented 2025-02-18T12:13:40.0266667+00:00
Kalle Macklin 0 Reputation points
1 answer

ADF: copy activity, ordinal mapping and Additional columns on source side.

Hi, I have a pipeline with a copy data activity. I would like to do an ordinal mapping, the source has all the columns needed on the sink side but I also want to add 2 Additional columns on source side which have dynamic content. something comes up…

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,485 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,257 questions
asked 2025-02-14T14:20:13.86+00:00
eg0087 0 Reputation points
commented 2025-02-18T11:21:31.7733333+00:00
Ganesh Gurram 4,085 Reputation points Microsoft Vendor
2 answers

Are Group Managed Service Accounts supported with SQL Server Reporting Services

I'm wondering if Group Managed Service Accounts (GMSAs) are supported in SQL Server Reporting Services now. I opened a concierge chat to find out and I was told yes but the link I was sent said it wasn't supported.…

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,996 questions
asked 2025-02-14T17:24:48.11+00:00
Robert Davidian 41 Reputation points
commented 2025-02-18T09:55:39.7366667+00:00
ZoeHui-MSFT 40,661 Reputation points
2 answers

Can I execute a report from Report Builder in my VS2022 VB.net WinForms application

I have been able to display a report on an asp webpage from my vs2022 vb.net webforms application but I can not display a report that has more than 1 table/dataset. Is this possible?

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,108 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.
14,485 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,996 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,780 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,108 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.
14,485 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,996 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,780 questions
asked 2025-02-11T23:38:43.0866667+00:00
BJ Harper 0 Reputation points
commented 2025-02-18T09:22:02.7733333+00:00
Jiachen Li-MSFT 33,451 Reputation points Microsoft Vendor
2 answers

Can I execute a report from Report Builder in my VS2022 VB.net WinForms application

I have been able to display a report on an asp webpage from my vs2022 vb.net webforms application but I can not display a report that has more than 1 table/dataset. Is this possible?

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,108 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.
14,485 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,996 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,780 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,108 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.
14,485 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,996 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,780 questions
asked 2025-02-11T23:38:43.0866667+00:00
BJ Harper 0 Reputation points
commented 2025-02-18T09:22:02.7733333+00:00
Jiachen Li-MSFT 33,451 Reputation points Microsoft Vendor