Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,451 questions
0 answers
Microsoft sql studio - dark mode enabling.
do we have a dark mode on Microsoft SQL Server Management Studio ?, of so, can anyone help me on how to get that enabled.
![](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, 70%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
3 answers
One of the answers was accepted by the question author.
Locking comparison SQL Server 2017 versus SQL Server 2022
We upgraded from SQL Server 2017 to SQL Server 2022. With SQL Server 2022 we are experiencing a lot more and longer locks. When long lasting locks happens, a lot of process are getting suspended. As soon that the lock is resolved, the processes are like…
asked 2024-04-22T12:53:22.4133333+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, 18%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Paolo Taverna
51
Reputation points
answered 2024-04-23T22:06:29.7833333+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, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Bruce (SqlWork.com)
55,366
Reputation points
0 answers
Please wait for the user profile service problem
As, i am using sql server 2019 in windows server 2019, while login it got stuck in Please wait for the user profile service and please wait for the profsvc. As i cannot connet my server to internet due to security protocols. This problem happen each day…
asked 2024-04-23T02:55:00.8966667+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(105.60000000000001, 26%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUD%3C/text%3E%3C/svg%3E)
Uttam Defence
0
Reputation points
commented 2024-04-23T21:23:18.6266667+00:00
Erland Sommarskog
100.9K
Reputation points MVP
1 answer
OLEDB varchar max not working
Having issues with OLEDB when writing a SQL Query that compares value with VARCHAR(MAX) column for inclusion. I'm wondering if the way that OLEDB connects to a database causes the issue or if it's the adapter itself. Edit: The query below by example…
asked 2024-04-23T03:49:13.6966667+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(19.2, 44%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKF%3C/text%3E%3C/svg%3E)
k ford
0
Reputation points
commented 2024-04-23T21:22:17.2233333+00:00
Erland Sommarskog
100.9K
Reputation points MVP
0 answers
How to fix mentioned error
as soon as possible
asked 2024-04-23T09:11:51.0633333+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, 73%, 29%)' 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)
Anandhswarupp
20
Reputation points
commented 2024-04-23T21:16:55.2766667+00:00
Erland Sommarskog
100.9K
Reputation points MVP
1 answer
SQL Patches KB5035434 installation failure - Failed to retrieve data for this request
When install SQL Server 2019 RTM GDR patches (KB5035434), I've got below error, anyone could help, thanks! Overall summary: Final result: The patch installer has failed to update the shared features. To determine the reason for…
asked 2024-04-23T11:24:16.74+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(163.2, 60%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELC%3C/text%3E%3C/svg%3E)
Laurence Cheung
0
Reputation points
answered 2024-04-23T21:13:51.9633333+00:00
Erland Sommarskog
100.9K
Reputation points MVP
3 answers
Is it Possible or is there a way to use the database you have been working on the developer option for production?
Can I migrate the database I made on the developer version to the express version or is there a way to use the database you created using the developer version for production purposes, say if you can transfer my database to the express version or pay for…
asked 2024-04-23T12:11:55.2666667+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(156.8, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBG%3C/text%3E%3C/svg%3E)
Betselot Getahun
0
Reputation points
answered 2024-04-23T21:08:49.9966667+00:00
Erland Sommarskog
100.9K
Reputation points MVP
0 answers
EDI cross reference table
Any suggestions on building and maintaining a table in SQL server that will be used to cross refence for EDI?
asked 2024-04-19T19:37:38.3733333+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
40
Reputation points
commented 2024-04-23T20:18:20.91+00:00
Jonathan Brotto
40
Reputation points
1 answer
Migrate On prem to Azure Sql Managed instance
I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance. I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without…
Azure Database Migration service
Azure Database Migration service
An Azure service designed to help simplify, guide, and automate database migrations to Azure.
279 questions
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
937 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,676 questions
asked 2024-04-23T17:46:35.1533333+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(108.80000000000001, 74%, 20%)' 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)
Shreedevi Sendarapatti Ramamoorthy
0
Reputation points
answered 2024-04-23T19:01:49.98+00:00
GeethaThatipatri-MSFT
27,017
Reputation points Microsoft Employee
0 answers
Unable to install SQL Server (setup.exe). Exit code 2147467259
Are you able to provide some guidance on how I can install SQL to my laptop? I also tried custom setup and got another error (Also asked). But if I go through basic setup, this is the error. Please find attached: Detail.txt
asked 2023-08-28T12:08:47.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(192, 86%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
LeoK
0
Reputation points
commented 2024-04-23T18:42:36.35+00:00
Karen Lopez
6
Reputation points MVP
0 answers
how to fix an ERROR 500 on SSRS 2019 Enterprise edition
The Microsoft Web SSRS portal have Error 500 time to time. sometimes we have the following error: The report execution 1kowwtmibuga4m45d4wt55ai has expired or cannot be found. (rsExecutionNotFound). The SSRS is installed on Windows server 2022…
asked 2024-04-23T18:40:14.1566667+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(25.6, 32%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVC%3C/text%3E%3C/svg%3E)
Valderrama Casas, Jaime
0
Reputation points
asked 2024-04-23T18:40:14.1566667+00:00
Valderrama Casas, Jaime
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Upgrade OS and SQLServer to 2019
Any issues while upgrading both OS from 2012 to 2019 and SQLserver from 2014 to 2019? We would like to proceed with inplace upgrade. How long does it typically take to upgrade SQLserver
![](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(51.2, 55.00000000000001%, 14%)' 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)
3 answers
SQL SERVER 2022 - certificate error when creating a job for integration services
In a test environment with SQL Server 2022 Developer Edition, I am trying to create a job to run an SSIS package. These same packages have been successfully tested in SQL 2019. When trying to create the job, configuring it as follows: General / Owner :…
asked 2024-04-10T03:35:21.82+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(278.4, 98%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Marcio Matos
0
Reputation points
commented 2024-04-23T18:14:16.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(32, 78%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Brian
0
Reputation points
2 answers
Sql Server cluster on K8S
Hi all, I am learning about deploying sql server on k8s. I have read documents as below: https://pradeepl.com/blog/kubernetes/deploying-sql-server-on-kubernetes/…
asked 2023-12-28T10:10:41.2133333+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, 17%, 29%)' 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)
Jack Chuong
331
Reputation points
answered 2024-04-23T17:12:23.95+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, 25%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDB%3C/text%3E%3C/svg%3E)
Don Boxley
0
Reputation points
2 answers
How to check SSRS version by querying database?
Hello, Is there a way to query SSRS version currently installed using TSQL? In sql server 2019 there is a table 'ProductInfoHistory' and it looks like it keeps the history but I have noticed that it is not consistent and I do not see it updated when I…
asked 2024-04-22T18:08:28.3033333+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, 98%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mughees, Muhammad
0
Reputation points
commented 2024-04-23T16:47:12.0933333+00:00
Mughees, Muhammad
0
Reputation points
0 answers
VS 2022 ReportViewer Error: "The report cannot be displayed. The report viewer could not find a report definition."
Please help me with this problem I'm having. I'll start by explaining my problem: I need to load reports, and for that I'm using the native reports of VS 2022. Here's what I've done so far: I created my .xsd file called DataSetInformes.xsd I added my…
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,825 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,676 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,223 questions
asked 2024-04-23T16:21:18.7333333+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(134.4, 18%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERC%3C/text%3E%3C/svg%3E)
Roberto Carlos Melgar Dorado
20
Reputation points
asked 2024-04-23T16:21:18.7333333+00:00
Roberto Carlos Melgar Dorado
20
Reputation points
3 answers
Error Installing Application on Another Computer: Invalid Connection String
Good evening dear community, I am bringing up my problem again since I have not been able to find a solution. To the point: I created a small application with a single Windows Forms form. It has its own connection string to the database and an example…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,357 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,676 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,223 questions
asked 2024-02-25T00:40:15.0533333+00:00
Roberto Carlos Melgar Dorado
20
Reputation points
answered 2024-04-23T16:08:38.42+00:00
Roberto Carlos Melgar Dorado
20
Reputation points
3 answers
How to audit instance changes and Profiler usage?
Greetings. I have a vendor with unlimited access to our most important SQL box, and that's not about to change. The best I can do here is track whatever they do. I've already got some tools in place for DB changes, as well as user/ login modifications.…
![](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(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
1 answer
SQL Server Connection for Python Flask Application
I have a python flask webapp and when the page is loading, connects to our SQL Server DB and saves certain tables as Panda data frames. This operation must happen as the page is loaded in. I am having issues connecting to my Server and database. Locally,…
asked 2024-04-18T11:34:48.8833333+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(272, 73%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Ahad Anjum
20
Reputation points
commented 2024-04-23T13:37:58.59+00:00
Ahad Anjum
20
Reputation points
8 answers
One of the answers was accepted by the question author.
Hide SQL DB's Users do Not have Access to
I know I can set the permission to Deny "View all DB's" but I need users who are mapped to their DB's to be able to see them in SSMS. Thoughts?
![](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, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER4%3C/text%3E%3C/svg%3E)