Microsoft Q&A

SQL Server

17,530 questions

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

17,530 questions with SQL Server-related tags

Sort by: Updated
0 answers

How do I setup a query while looking for a record with an apostrophe in it?

How do I setup a query while looking for a record with an apostrophe in it?

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,757 questions
asked 2023-09-07T17:33:47.6366667+00:00
Lopez, Ahiezer 196 Reputation points
1 answer

VBA: How to setup connection with Access to retrieve data into Excel?

Referring to following online database file, I would like to know on how to retrieve those data into Excel, and would like to know on how to setup the connection as well. Some sample coding is given as shown below Does anyone have any suggestions? …

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,757 questions
asked 2022-08-05T08:24:20.077+00:00
oemScript 81 Reputation points
commented 2023-09-07T17:32:50.9733333+00:00
Bob Carbonaro 0 Reputation points
1 answer

Getting error for standard logic app sql trigger: The 'ListCallbackUrl' API is not supported by triggers of type 'ServiceProvider'

I have a standard logic app that needs to use a sql trigger for when a row is inserted. I am using vnet integration to connect to a peered vnet that's in different tenant. When I first create the sql connection, it is able to connect to the database and…

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,355 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,757 questions
asked 2023-08-30T17:34:03.6533333+00:00
Phillip blackwell 0 Reputation points
edited an answer 2023-09-07T17:26:30.0433333+00:00
JananiRamesh-MSFT 10,241 Reputation points
2 answers

Buidling SQLqueries in dynamic content ADF

Im trying to use generic values for my SQL query. I have created parameters for a DB, schema and a table that should be passed into the FROM clause, and i ahve tried two approaches as can be seen in the SQL queries. But as is im getting thsi error: …

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,757 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,885 questions
asked 2023-09-01T08:49:42.4766667+00:00
Mathias Ravn Stephansen 0 Reputation points
commented 2023-09-07T17:24:42.6866667+00:00
ShaikMaheer-MSFT 34,286 Reputation points Microsoft Employee
2 answers

SQL Server Reporting Services 2019 - Home Folder Error - Could not load folder Contents. Something went wrong

Hi. As stated in the title, when I try to open report manager http://compreports/reports I got an error, Could not Load Folder Contents. Something Went Wrong I can add new folder but it is not visible If I search whatever folder 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,757 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 2021-01-08T04:07:19.897+00:00
Daim Yakub 1 Reputation point
answered 2023-09-07T17:19:45.2733333+00:00
Vinith Singh 0 Reputation points
2 answers One of the answers was accepted by the question author.

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,757 questions
asked 2023-09-05T09:39:54.1666667+00:00
Samantha r 966 Reputation points
accepted 2023-09-07T16:59:08.9466667+00:00
Samantha r 966 Reputation points
2 answers One of the answers was accepted by the question author.

lock escalation

Hi All, I am trying to understand the lock escalation behavior in Microsoft SQL Server 2017 (RTM-CU31). As per my knowledge, lock escalation is done to minimize the lock memory when it is exceeding 5000 locks. Here, in this example, I have create 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,757 questions
asked 2023-09-05T10:35:03.9733333+00:00
Samantha r 966 Reputation points
accepted 2023-09-07T16:57:33.5466667+00:00
Samantha r 966 Reputation points
0 answers

Importing DataFactory ARM Template failing for SQLServer ConnectionString

I am trying to clone a DataFactory to a different ResourceGroup. To do so I exported the ARM template from the source Resource Group and I would like to import it into the new one. I read here that you also need to recreate any self-hosted IR: If you…

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,757 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,885 questions
asked 2023-09-07T16:16:25.0333333+00:00
Francesco Pegoraro 0 Reputation points
edited the question 2023-09-07T16:30:22.64+00:00
Francesco Pegoraro 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,757 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,757 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,757 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,757 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,757 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,757 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,757 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
5,513 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,757 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,757 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
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,757 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