Microsoft Q&A

SQL Server

17,529 questions

A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.

17,529 questions with SQL Server-related tags

Sort by: Updated
1 answer

Fast Cash Customer Care For Helpline Number*/9046093185*/904-609-3185*/just Call me.

Peacock Leann Leann Leann Leann FL mall Leann

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,885 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
10,394 questions
Exchange Server Management
Exchange Server Management
Exchange Server: A family of Microsoft client/server messaging and collaboration software.Management: The act or process of organizing, handling, directing or controlling something.
6,787 questions
asked 2023-09-07T16:12:16.45+00:00
Vhjn Fygck 0 Reputation points
answered 2023-09-07T16:12:33.8733333+00:00
Vhjn Fygck 0 Reputation points
11 answers

Can adomd .net core connect to an SSAS endpoint from Linux?

Hi, I've a C# .Net Core 3.1 application, using the latest adomd .net core client, that successfully connects to an SSAS server and retrieves data when run on a Windows (Win10) platform. I've compiled it as portable, specific with libraries, and specific…

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,155 questions
asked 2021-01-17T23:46:51.343+00:00
Richard Oakham 1 Reputation point
answered 2023-09-07T16:08:36.2866667+00:00
Руслан Черненко 0 Reputation points
5 answers

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired

Hi, I have installed SQL Server 2019 on Linux platform and had done all the necessary steps and I was able to login to SQL Server via sqlcmd some time ago but suddenly I have started seeing below error when connecting to SQL Server via sqlcmd. i have…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2021-09-15T07:09:20.237+00:00
Sanjeev Gupta 21 Reputation points
answered 2023-09-07T15:34:09.03+00:00
Jajati Keshari Dev 0 Reputation points
2 answers

SSIS feasibility with key pair authentication for an OLEDB connection

Hi , I want to know if we can connect to another MS SQL DB using key pair authentication using an OLEDB connection with the help of SSIS. If not possible, how to achieve the same in ODBC connection? Any help would be greatly appreciated Regards

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,203 questions
asked 2021-10-30T10:03:10.48+00:00
Kunjibettu, Bharath Kumar 1 Reputation point
edited a comment 2023-09-07T14:58:31.2466667+00:00
Josef A 0 Reputation points
2 answers

Any roadmap to increase storage for the SQL MI Business critical Database?

I've noticed that the current storage size for the business-critical premium series database is capped at a maximum of 5.5 TB. I'm curious if there are any plans to expand this storage capacity in the near future. Additionally, I'm wondering if there's 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.
10,756 questions
Azure Disk Storage
Azure Disk Storage
A high-performance, durable block storage designed to be used with Azure Virtual Machines and Azure VMware Solution.
467 questions
asked 2023-08-16T13:54:24.6033333+00:00
MuthuKasi-MSFT 0 Reputation points Microsoft Employee
accepted 2023-09-07T13:57:07.29+00:00
MuthuKasi-MSFT 0 Reputation points Microsoft Employee
3 answers

VAR Char to Dollar Format

I have a column [totalAmount] and want to convert so that the amount is in US Dollar format. Example: 9729.20 and I want it to read $9729.20 in display.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2023-09-06T19:32:31.7033333+00:00
Lauren Sloan 0 Reputation points
answered 2023-09-07T13:56:50.9833333+00:00
Naomi 7,361 Reputation points
0 answers

OnError Exception,

Hi, Where to identify the reason, due to the details below? at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 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.
8,838 questions
Visual Studio Debugging
Visual Studio Debugging
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Debugging: The act or process of detecting, locating, and correcting logical or syntactical errors in a program or malfunctions in hardware. In hardware contexts, the term troubleshoot is the term more frequently used, especially if the problem is major.
825 questions
asked 2023-09-07T02:11:05.96+00:00
Peter_1985 2,096 Reputation points
commented 2023-09-07T13:53:36.98+00:00
Jiale Xue - MSFT 9,011 Reputation points Microsoft Vendor
2 answers

Visual Studio 2022 ARM - SQL Server Object Explorer (Microsoft.Data.SqlClient.TdsParser threw an exception)

I am attempting to connect to ANY SQL server database via VS 2022 ARM's SQL Server Object Explorer - it simply states Microsoft.Data.SqlClient.TdsParser there an exception. I also get the same exception when using the EF Core Powertools. My consulted…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2023-04-26T09:29:08.7433333+00:00
John 5 Reputation points
commented 2023-09-07T12:39:43.5233333+00:00
Yaniv C 0 Reputation points
1 answer

SQL Audit on Azure SQL Managed Instance - Retention Days?

Fellow DBA's I have been using SQL Audit for years on-premise. Moving to cloud. Since the SQL Audit will use blob with a URL Path, and we no longer user number of files as well as rollover count, I do not understand how to interpret Retention Days. 1 -…

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.
10,756 questions
asked 2023-09-06T15:12:22.67+00:00
Mark Gordon 781 Reputation points
commented 2023-09-07T11:50:08.7766667+00:00
Mark Gordon 781 Reputation points
1 answer

Unable to connect the sql server using windows authentication from asp.net application

Hi Team, Please find the details below. Current Infrastructure Setup: AzurewebappVM AzureDBVM Created new Windows domain account (ABC\Test) in the on-premises Active directory. Merged on-premises activity directory and Azure Active Directory…

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
1,616 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.
10,756 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,512 questions
asked 2023-09-06T08:04:26.6666667+00:00
Thyagarajulu B M 121 Reputation points
edited a comment 2023-09-07T10:41:08.2566667+00:00
Ben Gimblett 1,840 Reputation points Microsoft Employee
2 answers

Get Data before starting date

as last solution , as last solution , https://learn.microsoft.com/en-us/answers/questions/1359033/expected-output-required Condition ,if O_Value and O_Date is not null against item in itemmasterfile table, then qty from Probale table against relevant…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 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,515 questions
asked 2023-09-07T05:23:07.1666667+00:00
akhter hussain 3,246 Reputation points
commented 2023-09-07T10:10:05.1033333+00:00
akhter hussain 3,246 Reputation points
2 answers One of the answers was accepted by the question author.

Go To Definition (F12) in SQL Server Management Studio does nothing

Dear all, I am using SQL Server Management Studio 19 (fresh install) locally on my Windows 10 machine with my admin SQL user. Now I am trying to click on a table definition in my SQL query and press F12 (Go to definition default keymap) and it does…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2023-09-07T08:10:53.6566667+00:00
Cedric Altermatt 0 Reputation points
accepted 2023-09-07T09:43:05.18+00:00
Cedric Altermatt 0 Reputation points
2 answers

blocking scenario

Hi All, I am seeing a session is blocking another session which is started much later. I am saying this based on start_time and duration columns using sp_whoisactive. is it possible or its a timing issue? Can anyone explain how that's possible? DELETE…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2023-09-05T09:39:54.1666667+00:00
Samantha r 966 Reputation points
commented 2023-09-07T09:26:07.7966667+00:00
AniyaTang-MSFT 8,961 Reputation points Microsoft Vendor
1 answer

Transactional replication not replicating with 'The process is running and is waiting for a response from the server' error after adding new article

Hi I have a Transactional Replication setup which is working fine since long time. It is a Pull subscription. I got a new requirement to replicate a large article which is 10GB. allow_anonymous & immediate_sync are set to false by default. I added…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2023-09-05T13:38:51.3733333+00:00
Sowjanya Gopal 20 Reputation points
commented 2023-09-07T09:25:28.99+00:00
AniyaTang-MSFT 8,961 Reputation points Microsoft Vendor
1 answer

Disable Log In in SSRS

I want to log in to the SSRS web portal, but it asks for a user ID and password as shown on the screen. What should I enter?

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,515 questions
asked 2023-09-05T15:22:53.0066667+00:00
Ryo Nishikawa 0 Reputation points
commented 2023-09-07T09:24:45.9866667+00:00
AniyaTang-MSFT 8,961 Reputation points Microsoft Vendor
2 answers

SQL server 2022 database size?

SQL server 2022 database size?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2023-09-05T22:21:45.95+00:00
John Stupala 0 Reputation points
commented 2023-09-07T09:23:56.53+00:00
AniyaTang-MSFT 8,961 Reputation points Microsoft Vendor
0 answers

SQL Server Express 2022 failure installation (Through Virtual machine)

Does anyone know how to fix this? I want to install SQL express 2022, For context: I installed a Virtual machine inmy laptop. VM windows 11 Pro. for me to run a school related project. My windows 10 isn't working for this project - especially the SQL…

SQL Server on Azure Virtual Machines
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
5,832 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.
10,756 questions
Azure Virtual Desktop
Azure Virtual Desktop
A Microsoft desktop and app virtualization service that runs on Azure. Previously known as Windows Virtual Desktop.
1,157 questions
asked 2023-09-07T08:33:22.75+00:00
Bia M 0 Reputation points
commented 2023-09-07T09:20:08.78+00:00
Bia M 0 Reputation points
1 answer

How to limit the memory usage of the sqlserver of the windows built-in WID database for WSUS

Experts:I have deployed a WSUS using the windows built-in database WID. But after running, I found that a process “sqlserver” completely filled the memory, resulting in insufficient server memory,WSUS down!Can I how to limit the memory of…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,756 questions
asked 2023-09-07T07:08:25.8466667+00:00
俊杰 綦 0 Reputation points
answered 2023-09-07T07:23:23.6833333+00:00
Olaf Helper 32,546 Reputation points
1 answer

I am failing to install SQL Server 2022 because of a missing RegEntry file, Im getting this error 'Cannot find registry key 'SOFTWARE\Microsoft\Microsoft SQL Server\160\ConfigurationState'.

.NET
.NET
Microsoft Technologies based on the .NET software framework.
1,954 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.
10,756 questions
asked 2023-09-06T05:20:12.7833333+00:00
Dave Budah 0 Reputation points
commented 2023-09-07T07:22:50.7733333+00:00
Dave Budah 0 Reputation points
1 answer

What is the diffence between Window server and Azure SQL?

Hello. I wonder to know the difference between Window server and Azure sql. Does Microsoft web site has any links for these question?

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.
10,756 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
10,394 questions
asked 2023-09-07T03:05:38.64+00:00
은아 김 0 Reputation points
answered 2023-09-07T07:05:11.8933333+00:00
Olaf Helper 32,546 Reputation points