18,146 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

sql server, mailserver send error

어제까지 mssql 메일서버를 이용한 메일전송이 정상적으로 진행되었으나 금일 이후로 아래와 같이 에러가 발생합니다. 메일 서버 오류로 인해 받는 사람에게 메일을 보낼 수 없습니다. (계정 1(2023-02-13T16:03:37)을(를) 사용하여 메일을 보내고 있습니다. 예외 메시지: 메일 서버로 메일을 보낼 수 없습니다. (지정한 키가 사전에 없습니다.). 계정 2(2023-02-13T16:03:37)을(를) 사용하여 메일을 보내고 있습니다. 예외…

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,900 questions
asked 2023-02-13T08:23:36.3066667+00:00
박상준 20 Reputation points
commented 2024-05-26T23:53:25.51+00:00
인환 유 0 Reputation points
0 answers

جلب الحبيب العنيد🕌𝟬𝟬𝟮𝟬.𝟭𝟬𝟮𝟳𝟬𝟯𝟵.𝟮𝟱𝟰- جلب الحبيب المتكبر net

قم بمشاركة تفاصيل كافية حول المشكلة حتى يتمكن أعضاء المجتمع من إعادة إنتاج مشكلتك أو فهمها بشكل صحيح.?

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,900 questions
asked 2024-05-26T23:07:04.7333333+00:00
Fffg Fffgg 0 Reputation points
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,703 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,900 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,392 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,900 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,900 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,900 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,900 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,900 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,900 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,841 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,900 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,900 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,042 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,900 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,900 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,900 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,900 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,900 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,900 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,900 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