Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,536 questions
4 answers
Query on SQL Server HA and DR
Hi All, we have configured sql server always on failover cluster (two nodes) and both DB nodes are hosted on same DC. Application is using Listener IP to connect DB. HA: Avoid service impact during planned or unplanned events DR: Business continuity As…
asked 2024-06-06T14:04:31.94+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(137.6, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
PraveenKumar
216
Reputation points
answered 2024-06-07T11:27:25.0166667+00:00
Alex Bykovskyi
1,831
Reputation points
1 answer
One of the answers was accepted by the question author.
No Rows Message in Report Builder is not turning Red color in exported .pdf file
Hi All, I have developed on main report which contains many subreports in Report Builder. I have set the No Rows Message in Main report as well as Sub Report. No Rows message color made to Red Color. But problem is that, While run the main report and…
asked 2024-06-06T15:35:16.94+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(185.6, 4%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBK%3C/text%3E%3C/svg%3E)
BIDYUT KARMAKAR
20
Reputation points
commented 2024-06-07T10:32:21.1833333+00:00
BIDYUT KARMAKAR
20
Reputation points
0 answers
Issue with Batch Insertion using PreparedStatement in SQL Server
Hi, We are experiencing an issue while executing batch insertion using the preparedStatement.executeBatch() method in our Scala code. The problem is that it is inserting object references instead of actual values for VARCHAR columns. Below are the…
asked 2024-06-07T08:03:58.87+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(22.400000000000002, 7.000000000000001%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Anjali Garg
5
Reputation points
edited the question 2024-06-07T08:15:13.6533333+00:00
Anjali Garg
5
Reputation points
1 answer
One of the answers was accepted by the question author.
Set up valuable Indexes on a table
I have a really big transaction table, billions of rows, and I need some kinds of Indexes to make it useful. Right now there is a clustred columnstore index on the table, and a nonclustred on ID, but I guess I need some nonclustred to make the table…
![](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(89.60000000000001, 19%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFM%3C/text%3E%3C/svg%3E)
2 answers
How to install SQL Server 2022 on Ubuntu Server 24.04 LTS
I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…
asked 2024-05-24T00:46:20.3866667+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(198.4, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMF%3C/text%3E%3C/svg%3E)
Michael F. Assis
15
Reputation points
commented 2024-06-07T07:57:18.2166667+00:00
MikeyQiaoMSFT-0444
1,085
Reputation points
3 answers
One of the answers was accepted by the question author.
SQL Server wrongly using Inner Join instead of Left join.
I am working on SQL Server version 2019 with compatibility mode = 150. There is a scenario where I am using two tables TableA & TableB. Where I have to pull records which are not present in TableB but present in TableA. So I have created a simulation…
asked 2024-06-07T04:33:29.9166667+00:00
Vikrant Ashokrao More
20
Reputation points
accepted 2024-06-07T07:08:59.42+00:00
Vikrant Ashokrao More
20
Reputation points
3 answers
Is It Possible To Call HTTPClient From SSIS Script Task?
Hi, I have the following code in my SSIS script task: However, if I put a break point on the client.SendAsysnc, the code goes right by it. Then if I take out the break point and do a break point after execution, the SSIS project just stops running. …
asked 2024-06-06T17:37:15.7233333+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(307.2, 76%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPD%3C/text%3E%3C/svg%3E)
Paduck, Daniel
0
Reputation points
answered 2024-06-07T06:24:10.11+00:00
ZoeHui-MSFT
34,351
Reputation points
1 answer
Creating Dataset in VS2020 using SQL query rather than visual designer
I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?
asked 2024-05-08T11:12:55.34+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(195.2, 1%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Thomas Benson
0
Reputation points
edited the question 2024-06-07T06:10:02.7133333+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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
27,091
Reputation points Microsoft Vendor
3 answers
SQL Server Backup and Restore
Hi All, Currently we are taking two backups for the same DB - one from sql agent (custom script without copy_only option) and another one from third party backup tool (without copy_only). The backup strategy is same for both. .. Full backup: every day…
asked 2024-06-06T13:51:20.86+00:00
PraveenKumar
216
Reputation points
edited an answer 2024-06-07T05:52:26.69+00:00
LucyChenMSFT-4874
2,010
Reputation points
1 answer
Additional Cost for Verify Function in SQL DB Backups to Blob Storage
I have a plan to move my SQL backups directly to Blob Storage and want to know what additional costs I may encounter when using the Verify function in my T-SQL query. I have read that Verify may increase costs tenfold, but I need more detail and…
asked 2024-06-06T20:53:53.0733333+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(198.4, 35%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJA%3C/text%3E%3C/svg%3E)
Jordan Algar
0
Reputation points
answered 2024-06-07T04:14:43.0233333+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(99.2, 90%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Adharsh Santhanam
1,525
Reputation points
2 answers
Error installing SQL Server 2019
Can someone advise why I am getting this error and how I can fix it? Thank you
asked 2024-06-05T19:44:54.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(310.4, 34%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Mona Patni
0
Reputation points
edited an answer 2024-06-07T02:08:14.5833333+00:00
LucyChenMSFT-4874
2,010
Reputation points
asked 2024-06-06T14:43:46.38+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(67.2, 7.000000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
Jean C. Melendez
0
Reputation points
answered 2024-06-07T01:55:34.5366667+00:00
CosmogHong-MSFT
24,186
Reputation points Microsoft Vendor
1 answer
Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536
Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 100009. Maximum rows: 65536
asked 2024-06-06T13:49:36.94+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, 9%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAD%3C/text%3E%3C/svg%3E)
Ashok Dubey
0
Reputation points
answered 2024-06-07T01:53:53.99+00:00
ZoeHui-MSFT
34,351
Reputation points
3 answers
Mssql express installation failure
I am trying to install sql express on my laptop but i am unable to i have attached the error message and error file Summary_DESKTOP-JU2JTT1_20240604_154222.txt
asked 2024-06-04T14:48:02.3+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(176, 47%, 27%)' 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)
Samuel
0
Reputation points
edited an answer 2024-06-07T01:50:53.6166667+00:00
LucyChenMSFT-4874
2,010
Reputation points
1 answer
One of the answers was accepted by the question author.
How know all the columns in a MS SQL table
How know all the columns in a MS SQL table?
asked 2024-06-04T14:24:08.5333333+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(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
140
Reputation points
edited the question 2024-06-07T01:24:52.6966667+00:00
CosmogHong-MSFT
24,186
Reputation points Microsoft Vendor
2 answers
Error on report after upgrading to build 16.0.1115.92
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). In early May…
asked 2024-06-04T18:20:06.8033333+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(252.8, 15%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Alex M
10
Reputation points
commented 2024-06-07T01:21:22.77+00:00
ZoeHui-MSFT
34,351
Reputation points
1 answer
One of the answers was accepted by the question author.
Sql server licensing
I have sql server on a server. This is connected to 5 PCs and these PCs take information from 15 devices and save it in the database. I wanted to know if I have to purchase 15 CAL or if I am fine with 5
asked 2024-06-06T18:26:34.6733333+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, 84%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGC%3C/text%3E%3C/svg%3E)
GARCIA CAÑETE JUAN MANUEL
20
Reputation points
accepted 2024-06-06T22:20:03.52+00:00
GARCIA CAÑETE JUAN MANUEL
20
Reputation points
4 answers
How do I hide subreport option from the Reportin g Services screen?
I am a SSRS newbie, so pardon simple questions. I created two main reports. One report has hidden reports within. The other report has sub-reports. When I deployed the programs to Reporting Services, the sub-reports appear as selection options. How do I…
asked 2024-05-14T17:35:37.34+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(259.20000000000005, 71%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Stephen Schleyer
40
Reputation points
answered 2024-06-06T18:11:49.4+00:00
Stephen Schleyer
40
Reputation points
6 answers
SSRS UnhandledReportRenderingException
Current environment: SSRS: 16.0.1115.92 SQL Server instance: Microsoft SQL Server 2019 (RTM-CU26) (KB5035123) - 15.0.4365.2 (X64) Enterprise Edition (64-bit) on Windows Server 2016 Datacenter 10.0 <X64> (Build 14393: ) (Hypervisor). When we…
2 answers
One of the answers was accepted by the question author.
How to reset the password of SA account?
I forgot the password of SA user account. When I login with Windows Authetication, try to reset the password and it told me that I do not have permission. The BUILTIN\Users only have public server role. It won't allowed you to add the sysadmin role. Can…
![](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(134.4, 12%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
![](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(163.2, 85%, 25%)' 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)