SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,147 questions
2 answers
AlwaysON issue v2
Hello! There are two newly installed SQL Server 2022 Standard servers installed from the same ISO(say SQL1 and SQL2), OS = WinServer 2022 Standard (for both servers, same ISO), both added to the domain with the single domain controller named DC1. Here's…
asked 2024-12-06T14:46:03.6333333+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(214.4, 91%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHA%3C/text%3E%3C/svg%3E)
Hram Admin
40
Reputation points
answered 2024-12-06T17:38:08.36+00:00
Hram Admin
40
Reputation points
3 answers
Azure Resource Graph Explorer - Retrieving DTU Percentage
I am trying to use Azure Resource Graph Explorer to obtain a list of databases along with their DTU percentage. However, my query returns NULL for the DTU_percentage column. Is it possible to retrieve this information? Thanks in advance
asked 2024-12-02T14:51:25.14+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, 78%, 38%)' 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)
Suthii09
0
Reputation points
commented 2024-12-06T16:12:33.18+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(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
495
Reputation points Microsoft Vendor
2 answers
SQL backup failing every night
Hello All, SQL backup is failing every night with different error. As i am new to DPM, Unfortunatelly i could not understand why it is failing. Could someone help me, how to fix it ? Error: The replica of SQL Server 2017 database…
asked 2024-12-06T13:19:05.5866667+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(188.79999999999998, 70%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rajeswaran Sundarsingh
20
Reputation points
edited an answer 2024-12-06T15:35:14.0933333+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, 57.99999999999999%, 13%)' 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)
Amardeep Saini
1,335
Reputation points Microsoft Employee
0 answers
AlwaysON issue
Hello! There are two newly installed SQL Server 2022 Standard Edition servers (say SQL1 and SQL2), both installed from the same iso, with the OS also installed from the same ISO (Windows Server 2022 Standard), both are member of the domain with the…
asked 2024-12-06T14:33:31.1433333+00:00
Hram Admin
40
Reputation points
asked 2024-12-06T14:33:31.1433333+00:00
Hram Admin
40
Reputation points
2 answers
Transparent Data Encryption (TDE) on AlwaysON Availability Group
I’ve been tasked with securing SQL Server data and log files (MDF and LDF) using Transparent Data Encryption (TDE) across all SQL Servers in our environment, which consists of over 85 instances. This is a significant undertaking, and I’m concerned about…
asked 2024-12-05T16:58:35.36+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, 12%, 40%)' 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)
Augie
0
Reputation points
commented 2024-12-06T09:26:01.49+00:00
Erland Sommarskog
113.5K
Reputation points MVP
1 answer
One of the answers was accepted by the question author.
Stack Dump on SQL Server
Hi expert, Stack dump has been generated as attached when failover AOG enforcement occurred... any suggestion to getting solution with this information? great appreciation for all reply regards, UrBel SQLDump0052.txt
![](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, 96%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EU%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Unable to install SQL server
Detail.txt Summary.txt I couldnt make out the log file, Could you help me figure out what i should do to install this server, I will try to install a 2019 server and try again, but any help is appriciated, 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(310.4, 59%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
1 answer
How can I update the data source (Azure Storage) for Azure Analysis Services without using the SQLServer module or the Invoke-ASCmd method, preferably using Python?
I am looking for a way to achieve this using Python. Please suggest any tools, libraries, or approaches that can facilitate this, such as using REST APIs or handling XMLA directly. A step-by-step explanation or references would be greatly appreciated.
asked 2024-12-03T10:34:09.55+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(3.2, 80%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
T, Charandeep
0
Reputation points
answered 2024-12-06T07:27:52.5133333+00:00
T, Charandeep
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Reading SQL Transaction log
Hi Expert, I've added new *LDF file, but I would like old *LDF can't be used anymore\inactive, so all transaction will be recorded into new *LDF i've just created... then, how to know transaction recorded into new *LDF? thanks for all respond great…
2 answers
Unable to restore database in ssms
Getting below error while i am trying to restore a database in SSMS. TITLE: Microsoft SQL Server Management Studio An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ADDITIONAL…
asked 2024-12-05T10:23:45.48+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, 83%, 39%)' 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)
Ahuja, Muskan
0
Reputation points
answered 2024-12-06T06:35:00.69+00:00
ZoeHui-MSFT
38,621
Reputation points
3 answers
i am getting this error
please give me some solution for SqlConnection, SqlCommand and Clear ()
Windows Forms
Windows Forms
A set of .NET Framework managed libraries for developing graphical user interfaces.
1,908 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,977 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,147 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,753 questions
asked 2024-11-30T11:08:29.9066667+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(204.8, 22%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESD%3C/text%3E%3C/svg%3E)
sayali dhanawade
20
Reputation points
edited the question 2024-12-06T06:28:48.6433333+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(73.60000000000001, 90%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZL%3C/text%3E%3C/svg%3E)
Zhi Lv - MSFT
32,561
Reputation points Microsoft Vendor
1 answer
Application getting logout frequently - ASP.NET session has expired or could not be found - Microsoft.ReportViewer.WebForms
Dear all, we are getting below error frequently from few days without any deployment on production environment, unable to find the solution. even after increasing session time out and tried various suggestions on internet still facing the same issue.…
Internet Information Services
Internet Information Services
Microsoft web server software.
1,702 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,538 questions
Windows Server 2012
Windows Server 2012
A Microsoft server operating system that supports enterprise-level management, data storage, applications, and communications.
1,606 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,950 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.
11,106 questions
asked 2024-12-05T08:06:48.54+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(217.60000000000002, 24%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Rupesh Musale (Ext)
0
Reputation points
commented 2024-12-06T03:14:57.8166667+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, 0%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXP%3C/text%3E%3C/svg%3E)
XuDong Peng-MSFT
10,836
Reputation points Microsoft Vendor
1 answer
Migrating Publication database in Transaction Replication to another server
Hi. We need to migrate Publication database (SQL 2017) in Transaction Replication from old server (windows 2016) to new server (windows 2019). Please let me know if below approach works. Setup log shopping to migrate Publisher database from old server…
asked 2024-12-05T07:54:02.4066667+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(12.8, 44%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESG%3C/text%3E%3C/svg%3E)
Sowjanya Gopal
20
Reputation points
answered 2024-12-06T02:45:59.84+00:00
Greg Low
1,850
Reputation points Microsoft Regional Director
1 answer
Finding the Next Appointment Record
Hello everyone and thanks for the help in advance. I need to develop a report for a physician's office that tracks how many patients made follow up appointments after a first appointment. In other words, lets say a patient had an appointment today and…
![](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(208, 34%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
Not able to connect to a database in SSMS 19.1
TITLE: Connect to Server Cannot connect to WTIN05700927L. ADDITIONAL INFORMATION: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the…
asked 2024-12-05T12:02:06.4333333+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(70.4, 84%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBC%3C/text%3E%3C/svg%3E)
Bharathiraaja Chandrasekaran
0
Reputation points
edited a comment 2024-12-06T01:59:55.01+00:00
LiHongMSFT-4306
29,111
Reputation points
3 answers
Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?
My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…
![](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, 26%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
3 answers
Is there a roadmap for Analysis Services Linked Servers in Azure SQL Managed Instance?
My clients rely heavily on being able to query an Analysis Services Linked Server in SQL Server Enterprise. I'm aware this is not currently possible in SQL MI, which means I can't consider migrating any clients there. I'm not looking for alternative…
1 answer
Database schema change of result in query sql server
How we can get database schema change result in query sql server? Is there any tool ? Suppose we do any change in schema. I want the result of that change in query.
asked 2023-11-16T22:31: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(265.6, 69%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kanav Sharma
25
Reputation points
commented 2024-12-05T22:05:46.39+00:00
Erland Sommarskog
113.5K
Reputation points MVP
1 answer
How to fix an error System.TypeLoadException: in an swagger api project ?
System.TypeLoadException: Method 'get_LockReleaseBehavior' in type 'MySql.EntityFrameworkCore.Migrations.Internal.MySQLHistoryRepository' from assembly 'MySql.EntityFrameworkCore, Version=0.0.0.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d' does…
asked 2024-10-11T08:15:59.3133333+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(227.2, 53%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Mathis De Sousa
0
Reputation points
commented 2024-12-05T20:42:51.56+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(115.19999999999999, 80%, 21%)' 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 Ralph Daudi
0
Reputation points
1 answer
Customized ODBC permission registry setting lost
Hi engineer, We find that this “Authenticated Users” setting in the ODBC.INI permission is lost We upgraded those PC OS to Windows 10 Prof 22H2 a few months ago. Do you know if OS upgrade to Windows 10 Prof 22H2 will reset ODBC this registry settings?
asked 2024-12-02T09:30:06.26+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(281.6, 34%, 37%)' 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)
Victor Cheung
0
Reputation points
commented 2024-12-05T17:05:13.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(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,070
Reputation points Microsoft Vendor