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
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…
asked 2023-05-24T13:14:39.1833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 74%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Chris Mason
0
Reputation points
answered 2025-02-18T21:22:19.3666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 94%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
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.
asked 2025-01-15T22:35:28+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 2%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGB%3C/text%3E%3C/svg%3E)
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.
asked 2025-02-18T20:21:07.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 57.00000000000001%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERG%3C/text%3E%3C/svg%3E)
Richard Giesbrecht
0
Reputation points
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.
asked 2025-02-18T20:21:07.21+00:00
Richard Giesbrecht
0
Reputation points
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:…
asked 2025-02-18T19:24:05.1733333+00:00
Sergey Knyazev
0
Reputation points
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…
asked 2024-12-10T09:58:07.5066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 11%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERW%3C/text%3E%3C/svg%3E)
Richard Williams
10
Reputation points
commented 2025-02-18T19:22:56.72+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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…
asked 2025-02-11T15:36:10.77+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 30%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENS%3C/text%3E%3C/svg%3E)
Nikhil Somani
0
Reputation points
commented 2025-02-18T18:18:07.1766667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
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…
asked 2025-02-06T23:25:40.6466667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 57.00000000000001%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Berchmans Marcelline
10
Reputation points
commented 2025-02-18T18:13:52.1866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 6%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
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,…
asked 2025-02-17T19:00:55.1133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 61%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jean-Marie Roger
0
Reputation points
answered 2025-02-18T18:10:54.0533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 20%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPR%3C/text%3E%3C/svg%3E)
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…
asked 2025-02-17T08:47:10.6066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 92%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFA%3C/text%3E%3C/svg%3E)
Farid Ali
0
Reputation points
commented 2025-02-18T17:13:35.42+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
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…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(147.20000000000002, 11%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
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.…
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:…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 8%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
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,…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 37%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAJ%3C/text%3E%3C/svg%3E)
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!
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
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.…
asked 2025-02-18T08:04:09.8533333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 76%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
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…
asked 2025-02-14T14:20:13.86+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 79%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EE%3C/text%3E%3C/svg%3E)
eg0087
0
Reputation points
commented 2025-02-18T11:21:31.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
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.…
asked 2025-02-14T17:24:48.11+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 28.999999999999996%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 73%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBH%3C/text%3E%3C/svg%3E)
BJ Harper
0
Reputation points
commented 2025-02-18T09:22:02.7733333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
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