18,111 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 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,869 questions
asked 2024-05-21T13:10:34.7166667+00:00
Nitya V 40 Reputation points
edited the question 2024-05-21T17:32:09.3766667+00:00
Nitya V 40 Reputation points
1 answer One of the answers was accepted by the question author.

What is Function app pricing Y1 means?

Hello , I used azure function app for deployment. What is pricing of this service. My billing statement does not show anything related that. What is "Y1" ????

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,359 questions
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,254 questions
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,197 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,869 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,001 questions
asked 2023-08-14T11:41:48.9133333+00:00
Shrikant Alone 20 Reputation points
commented 2024-05-21T17:12:25.4066667+00:00
Mike 0 Reputation points
0 answers

Why does impersonation (Execute as) work in a User database and not in the master database in Azure SQL DB?

Execute As User = 'User1' doesn't work in the Azure SQL DB master database. User1 account created in the master database and in a user database. Execute As User works in the user database and in the master database, receives the error: Msg 15517, Level…

Azure SQL Database
SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
49 questions
asked 2024-05-21T17:00:07.2233333+00:00
Jerimy Stanley 0 Reputation points
edited the question 2024-05-21T17:06:51.3+00:00
Jerimy Stanley 0 Reputation points
5 answers One of the answers was accepted by the question author.

Microsoft SQL Server Bulk Insert NOT failing when inserting bigint values into int column

We recently had an identifier column move from int values to bigint values. An ETL process which loads these values was not updated. That process is using SQL bulk insert, and we are seeing incorrect values in the destination table. I would 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.
12,869 questions
asked 2023-01-11T19:14:45.4966667+00:00
Sees, William T 20 Reputation points
answered 2024-05-21T16:55:07.22+00:00
Sees, William T 20 Reputation points
1 answer

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.
471 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,869 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,001 questions
asked 2024-05-21T15:35:47.5633333+00:00
ParthibanSekarUK-3136 0 Reputation points
commented 2024-05-21T16:03:37.8666667+00:00
ParthibanSekarUK-3136 0 Reputation points
2 answers

Reclaiming free space from TempDB in azure sql managed instance

the TempDB on my azure sql managed has grown to 350 GB but 99% of that space shows as unused. i tried to shrink the database and individual files but the server is not freeing up the space. the space is still reserved for tempdb. Microsoft docs is…

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,869 questions
asked 2024-05-17T12:34:07.53+00:00
HusainIbrahem-6130 0 Reputation points
edited an answer 2024-05-21T15:39:16.77+00:00
GeethaThatipatri-MSFT 27,892 Reputation points Microsoft Employee
0 answers

where do I get an ifilter for outlook .msg files that I can install for SQL Server to use it

I want to install the Office Outlook MSG IFilter onto a SQL Server box, so that SQL Server can find/search .msg files. However on the SQL Server box (again on windows 10) , no Office applications are to be installed. Just SQL Server If I try and…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
10,777 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,869 questions
asked 2024-05-21T14:48:14.5133333+00:00
K Gillis 0 Reputation points
commented 2024-05-21T15:32:16.4233333+00:00
K Gillis 0 Reputation points
1 answer

SSRS CSV export issue

I have a SSRS report with dynamic column and also Column display order is getting handle through parameter "ColumnOrder". Once I generate the report it works fine and based on column order it display columns on report. Once I export it to CSV…

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,869 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,821 questions
asked 2023-08-25T13:16:20.0366667+00:00
Arvind Singh Gusain 5 Reputation points
commented 2024-05-21T14:36:22.26+00:00
Karthiga Murugan 1 Reputation point
4 answers

Security update for SQL Server 2019 CU25

Hi, I would like to clear up some confusion regarding security updates for SQL Server 2019. If Security update for SQL Server 2019 CU 25 KB5036335 is pushed out by our System Engineers team to a server, does that mean it includes the Cumulative Update…

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,869 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,260 questions
asked 2024-05-14T17:31:21.2833333+00:00
David D. Lengar 0 Reputation points
commented 2024-05-21T14:05:11.5966667+00:00
David D. Lengar 0 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.
701 questions
ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,232 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,869 questions
asked 2024-05-20T19:12:10.4966667+00:00
Atilla Rüstəmli 0 Reputation points
commented 2024-05-21T13:57:04.57+00:00
Atilla Rüstəmli 0 Reputation points
0 answers

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

SQL Express Server Installation Documentation

I am curious if there is any official documentation on installing SQL Express. Let me know if this is the case. Thank 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.
12,869 questions
asked 2024-05-21T12:45:01.2033333+00:00
Carter Benike 0 Reputation points
answered 2024-05-21T13:14:53.8933333+00:00
Zahid Butt 556 Reputation points
4 answers

Sql service account password reset under SQL server alwayson

Hi,   I have two nodes with N1 and N2 in two different datacenters...now I need to change password for the service account for SQL service- can someone help me with -what pre-requisites needed and what need to be ensure smoothly to be peform with minimal…

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,869 questions
asked 2024-01-26T12:28:23.93+00:00
S_NO 21 Reputation points
answered 2024-05-21T12:53:55.3166667+00:00
S_NO 21 Reputation points
2 answers

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,179 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,869 questions
asked 2024-05-20T14:03:49.28+00:00
Bert 0 Reputation points
edited an answer 2024-05-21T12:35:07.1433333+00:00
Anand Prakash Yadav 6,465 Reputation points Microsoft Vendor
2 answers

question about deploying SSIS

Hi I have made a project of SSIS with VS 2022, and i need to deploy it and make it to be excuted once per day. It seems that I need to deploy it on sql server.when I click the property of the project ,in Target server version , the lowest is 2016,…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,464 questions
asked 2024-05-21T07:22:16.6666667+00:00
Martin Wang 101 Reputation points
answered 2024-05-21T12:33:10.04+00:00
Yitzhak Khabinsky 25,201 Reputation points
0 answers

SQL Server 2022 Reporting Services 16.0.8886.1775 does not render map points correctly

Version 16.0.8784.14010 renders correctly. The Visual Studio SSRS extension 3.0.10 also renders the report correctly. Seems to be a bug in the latest version 16.0.8886.1775. Helped me to downgrade to version 16.0.8784.14010.

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,821 questions
asked 2024-05-21T12:13:20.97+00:00
Vavra Roman MT-CZ 0 Reputation points
2 answers

Migrate On prem to Azure Sql Managed instance

I am planning to migrate the on-premises SQL server on virtual machines to an Azure SQL managed instance. I am looking for a migration plan that can help with the above migration, which will list the compatibility and options to move the data without…

Azure Database Migration service
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
994 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,869 questions
asked 2024-04-23T17:46:35.1533333+00:00
Shreedevi Sendarapatti Ramamoorthy 0 Reputation points
commented 2024-05-21T11:12:40.8266667+00:00
Shreedevi Sendarapatti Ramamoorthy 0 Reputation points
2 answers

Can't connect to Azure Sql with SSMS or Azure Data Studio

I used to be able to get to me Azur Sql database via SSMS (Sql Server Management Studio) or Azure Data Studio but now I can't. Firewall rule error The server you specified x does not exist in any subscription in y Either you have signed in with an…

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,869 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
100 questions
asked 2024-05-20T16:55:23.8433333+00:00
John Marsing 0 Reputation points
edited an answer 2024-05-21T11:11:23.7966667+00:00
GeethaThatipatri-MSFT 27,892 Reputation points Microsoft Employee
1 answer

Registering SQL Central management server using powershel

HI, Can we automate register Central Management Server using powershell? I'm unable to find any documentation regarding the this?. Rest of the steps are automated through poweshell. As part of the testing the script I have deleted the registered Central…

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,869 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,140 questions
asked 2024-05-21T08:48:35.2733333+00:00
Ummer, Fazil 0 Reputation points
commented 2024-05-21T10:35:44.4066667+00:00
Ummer, Fazil 0 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,869 questions
asked 2024-05-16T12:03:46.98+00:00
Nitya V 40 Reputation points
edited a comment 2024-05-21T09:51:28.67+00:00
Nitya V 40 Reputation points