18,145 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

How to connect my c# application to my phpmyadmin database from my NAS?

Good day, I want to try to connect to my database in my NAS. Please take a look the image below. As you can see at the image, I want to access my database outside in my home network. I already installed phpmyadmin in my NAS, but the problem is I don't…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,700 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,899 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,391 questions
asked 2024-05-26T11:07:34.2566667+00:00
BgnerNprg207 226 Reputation points
answered 2024-05-26T16:57:45.0966667+00:00
Bruce (SqlWork.com) 57,966 Reputation points
3 answers

How to parse SOAP XML in SQL Server and show as table

DECLARE @xml XML ='<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"> <soapenv:Header /> soapenv:Body <ns0:GetListResponse xmlns:ns0="urn:Consultaurartmasiva1"…

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,899 questions
asked 2024-05-23T02:00:53.51+00:00
diego diaz 1 Reputation point
commented 2024-05-26T14:47:13.5166667+00:00
Yitzhak Khabinsky 25,206 Reputation points
2 answers

What is the function difference between MS SQL Standard and Express

What is the function difference between MS SQL Standard and Express in MS SQL 2017

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,899 questions
asked 2024-05-26T13:28:54.68+00:00
Miloslav Bustik 0 Reputation points
answered 2024-05-26T13:49:13.1633333+00:00
Sreeju Nair 11,856 Reputation points
1 answer

Removing database from AG

I have an AG. On secondary replica, if we remove database from AG, what will be the database status on primary replica

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,899 questions
asked 2024-05-26T09:31:01.73+00:00
Chaitanya Kiran 696 Reputation points
answered 2024-05-26T10:01:09.72+00:00
Erland Sommarskog 102.3K Reputation points
0 answers

How do I copy all columns properties with copy activity in data factory

Hi, I'm copying data from one DB to another DB with copy activity and auto create table. I noticed that when the table is creating on the target side it is creating with the column size and type but all the other properties are lost, for example…

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.
12,899 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,755 questions
asked 2024-05-26T07:29:16.98+00:00
OGINTZ Marina 85 Reputation points
1 answer

SQL error during install

Getting the following error when installing SQL express 2022: The file SQLEXPR_x64_ENU.exe version 16.0.1000.6 must be in the same directory as this installer. Place the file in this directory and try again.

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,899 questions
asked 2024-05-25T02:31:14.0666667+00:00
Joey Williams 0 Reputation points
answered 2024-05-25T21:39:14.4933333+00:00
Erland Sommarskog 102.3K Reputation points
2 answers

Is it correct to make connection string dynamic?

Hi, I'm currently working on a project which need data from other databases. The database where I'll get the datas are depends on users. Now I want to make my connectionString dynamic. Is it correct to make connection strnig dynamic. The user will enter…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
702 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,242 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,899 questions
asked 2024-05-20T19:12:10.4966667+00:00
Atilla Rüstəmli 0 Reputation points
commented 2024-05-25T17:16:49.98+00:00
Atilla Rüstəmli 0 Reputation points
2 answers One of the answers was accepted by the question author.

How to fix this error in Microsoft SQL: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query timeout expired...

Hello, Kindly advise how to solve below issue: we have one job that's failing is Microsoft SQL. This issue is affecting the Power BI reports as well. Below error is found: SQL job is failing. OLE DB or ODBC error: [DataSource.Error] Microsoft SQL: Query…

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,839 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,899 questions
asked 2024-05-04T22:07:43.62+00:00
Aya 20 Reputation points
accepted 2024-05-25T10:13:19.82+00:00
Aya 20 Reputation points
1 answer

Why isn't code working as an expression for parameters in SQL Server Reporting with connection to Databricks SQL Warehouse using Simba Spark

Error: For more information about this error navigate to the report server on the local server machine, or enable remote errors ---------------------------- Query execution failed for dataset 'DataSet1'. (rsErrorExecutingCommand)…

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
1,973 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,826 questions
asked 2024-05-24T20:44:13.19+00:00
Maxwell, Niki 0 Reputation points
answered 2024-05-25T02:54:38.21+00:00
hossein jalilian 4,285 Reputation points
2 answers

Unable to connect to private linked SQL server from azure web apps

I have a group of linux web apps with VNet Integration enabled on a subnet called web-tier and an azure server with private link configured on another subnet called data-tier. I have also added nsg rules to the data-tier subnet nsg to allow inbound…

Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
473 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,899 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,041 questions
asked 2024-05-21T15:35:47.5633333+00:00
ParthibanSekarUK-3136 0 Reputation points
commented 2024-05-24T23:26:41.8333333+00:00
ChaitanyaNaykodi-MSFT 23,501 Reputation points Microsoft Employee
2 answers

Can a deadlock issue be raise while running two select queries in sql server

Do we get a deadlock issue while running two select statements of two different table in sql server

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,899 questions
asked 2024-05-24T13:21:28.4666667+00:00
Khan-CW, P Ali Altaf 63769 0 Reputation points
answered 2024-05-24T21:01:59.62+00:00
Erland Sommarskog 102.3K Reputation points
4 answers One of the answers was accepted by the question author.

sql data store is causing errors on sql server 2022

We have recently upgraded our servers to SQL Server 2022, and are currently hosting three Microsoft SQL servers running version 16.0.4015.1. We have enabled the query store on all of our databases, with between 5 to 9 databases hosted per server. Since…

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,899 questions
asked 2023-04-04T12:24:49.7933333+00:00
Boon, Hendrik (GRQ-BGE) 35 Reputation points
commented 2024-05-24T20:50:08.84+00:00
Erland Sommarskog 102.3K Reputation points
2 answers

How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server)

How to check root cause of "Agent message code 20084. The process could not connect to Distributor" on a Pull subscription(SQL MI) and Publisher/Distributor (ON Prem SQL Server) The firewall and network settings looks fine. However we are…

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.
12,899 questions
asked 2024-05-21T13:10:34.7166667+00:00
Nitya V 40 Reputation points
commented 2024-05-24T18:31:16.7933333+00:00
Nitya V 40 Reputation points
4 answers

Transactional Replication on a SQL Managed instance as a subscriber with pull subscription

We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this

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.
12,899 questions
asked 2024-05-16T12:03:46.98+00:00
Nitya V 40 Reputation points
commented 2024-05-24T18:30:23.2033333+00:00
Nitya V 40 Reputation points
1 answer

Dataset format needed for azure blob storage

How do I select what format is right for me while moving documents from SQL Server to Azure blob storage using Azure Data Factory pipeline? The existing documents in the Blob storage show the type as Block Blob, but it doesn't show the format. I need to…

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,490 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,899 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,755 questions
asked 2024-05-24T13:53:47.7833333+00:00
Reema DSouza 0 Reputation points
commented 2024-05-24T16:11:06.9433333+00:00
Gowtham CP 1,420 Reputation points
1 answer

SSMS not flagging basic errors after IIF statement

DMF_SSMS_SQL_IIF_Err.pdf I just wanted to notify Microsoft of an error I believe I found with SSMS error notification. Going thru some scripts, I came across one that had a CASE and IIF in it. I accidently did a typo, no errors, but failed. I then…

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,899 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
asked 2024-05-20T15:07:50.28+00:00
AdamG Devl 0 Reputation points
commented 2024-05-24T16:02:35.9133333+00:00
AdamG Devl 0 Reputation points
1 answer

SSRS Report Subscription Windows Share File Option Failed

We have configured SSRS Report Subscription export report automatically and place the file in shared path location, we did all the configurations but getting error like "Failure writing file acctbalrw : The permissions granted to user '' are…

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,826 questions
asked 2024-05-24T14:47:14.9633333+00:00
Vinaya Velli 0 Reputation points
answered 2024-05-24T15:34:02.9833333+00:00
Olaf Helper 41,411 Reputation points
4 answers One of the answers was accepted by the question author.

SQL Server Snapshot Agent suddenly getting error 1130 when trying to connect to Azure File Storage

I have the following SQL Server Replication Setup Publisher server is an Azure SQL Managed Instance, Subscriber server is the same server Storage is Azure File Share I'm trying to setup replication from a database on a managed instance (DB_1) to another…

Azure Files
Azure Files
An Azure service that offers file shares in the cloud.
1,188 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,899 questions
asked 2024-05-20T14:03:49.28+00:00
Bert 20 Reputation points
accepted 2024-05-24T12:19:17.9933333+00:00
Bert 20 Reputation points
4 answers

Microsoft.ReportingServices.ReportViewerControl.WebForms version 150.1404.0 returns invalid HTML for Reserved.ReportViewerWebControl.axd?ResourceStreamID=Blank.gif

The HTML returned by the reporting services viewer is missing the " at the end of the src attribute. It's resulting in: <img…

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,826 questions
asked 2020-10-22T16:44:23.957+00:00
Alan Waiss 31 Reputation points
commented 2024-05-24T10:46:53.24+00:00
Tomas Wall 0 Reputation points
4 answers

how to specify folder for backup command when using sqlcmd

Sql Server 2019 express edition. I am trying to setup a backup (temporarily) using task scheduler in windows 10. I have sqlcmd as the command. I have -S mymachine\sqlexpress -U myuser -P myuserpass -i c:\mytools\backupdbcommand.sql In the…

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,899 questions
asked 2023-06-07T20:59:19.81+00:00
Darryl Hoar 141 Reputation points
answered 2024-05-24T10:12:12.04+00:00
Shanto Islam 0 Reputation points