19,759 questions with SQL Server-related tags

Sort by: Updated
1 answer

Facing issues for the mismatch definitions of some methods from SQLEditors.dll used in SSMS 21

I am trying to consume the SQLEditors.dll from SSMS 21 and SSMS20 in my C# code however getting the compilation issue due to incorrect format of library as error : D:\BuildAgentB\work\fb305f1670873990\VersionSpecific.CommonFiles\NewQueryWriter.cs(83,…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,030 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.
14,258 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.
11,171 questions
asked Jan 6, 2025, 6:11 AM
Vaibhav Pol 10 Reputation points
answered Jan 8, 2025, 9:34 AM
Hongrui Yu-MSFT 3,725 Reputation points Microsoft Vendor
1 answer

Wealth Snap Customer'S Care Number . 09172420532//9172420532 Call

Best way home from work tomorrow and see if I can get a package

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,258 questions
asked Jan 8, 2025, 9:32 AM
Wealth Snap 0 Reputation points
answered Jan 8, 2025, 9:33 AM
Wealth Snap 0 Reputation points
3 answers

On-prem MS SQL server 2016 migration to Azure SQL Server Managed database Instances path

Hi Team, We are currently planning to migrate our On-prem MS SQL Server 2016 to Azure SQL Server Managed Database Instances. The source will be our On-prem MS SQL Server 2016, and the target is the Azure SQL Server Managed Database Instances. I have a…

Azure SQL Database
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
543 questions
asked Jan 6, 2025, 12:53 PM
Patankar, Narottam 20 Reputation points
commented Jan 8, 2025, 9:31 AM
Vijayalaxmi Kattimani 900 Reputation points Microsoft Vendor
3 answers

Retrieving Admin Credentials for SQL Server Database Backup

Connecting to a database from SQL Server Management Studio with normal authentication is not allowing backup operations. An ex-employee who was the admin did not provide any credentials. As a result, backup cannot be taken, and attempts to assign roles…

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,201 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.
14,258 questions
asked Jan 6, 2025, 4:56 AM
Mohana Reddy 80 Reputation points
commented Jan 8, 2025, 9:26 AM
Mohana Reddy 80 Reputation points
0 answers

SQL Server timeout exception azure hyrbrid connection

We have web applications with Function apps, Web Apps and API management services. SQL database is located in an on-premise SQL database server. Function apps connect to the SQL database via an Azure Hybrid connection. Suddenly we received the following…

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,283 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.
14,258 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,133 questions
asked Jan 8, 2025, 9:09 AM
Amal Edirisinghe 0 Reputation points
edited the question Jan 8, 2025, 9:16 AM
Amal Edirisinghe 0 Reputation points
0 answers

SQL Server timeout exception azure hyrbrid connection

We have a Web application with Azure functions, a web app and an API manager. SQL database is located on an on-premise SQL database server. Functions apps connecting on-premise database via Azure hybrid connection. Suddenly we got the following 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.
14,258 questions
Azure Static Web Apps
Azure Static Web Apps
An Azure service that provides streamlined full-stack web app development.
1,032 questions
asked Jan 8, 2025, 9:03 AM
Amal Edirisinghe 0 Reputation points
edited the question Jan 8, 2025, 9:16 AM
VarunTha 10,605 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

SQL server with Trace flags 2371 and 7745

Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…

Azure Database Migration service
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.
14,258 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
543 questions
Azure Database Migration service
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.
14,258 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
543 questions
asked Dec 20, 2024, 10:18 AM
Sanjeev K 40 Reputation points
accepted Jan 8, 2025, 8:15 AM
Sanjeev K 40 Reputation points
1 answer One of the answers was accepted by the question author.

SQL server with Trace flags 2371 and 7745

Hi Team, We are migrating the SQL server databases to Azure managed instance . The DMA reported that 2371 and 7745 trace flags enabled on SQL instance. i think 2371 and 7745 trace flages auto enabled on Managed instance. Please let me know if changes…

Azure Database Migration service
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.
14,258 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
543 questions
Azure Database Migration service
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.
14,258 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
543 questions
asked Dec 20, 2024, 10:18 AM
Sanjeev K 40 Reputation points
accepted Jan 8, 2025, 8:15 AM
Sanjeev K 40 Reputation points
2 answers

How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '<token-identified principal>'. The server is not currently configured to accept this token.'

Hi All, I'm encountering an issue while trying to connect to an Azure SQL Database using Microsoft Entra Authentication (formerly Azure AD). I am using DefaultAzureCredential in my .NET application to authenticate and retrieve the access token, but…

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.
14,258 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.
11,171 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,133 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
22,742 questions
asked Jan 3, 2025, 12:29 AM
Krishna Basavaraj K S 0 Reputation points
answered Jan 8, 2025, 8:12 AM
krishna basavaraj savasuddi 20 Reputation points
1 answer

How to Extend a drive on an Azure VM

Guys, we have a VM on azure that runs sql server. Recently I increased the disc size of F drive from 1TB to 2TB on the azure portal. When I went to extend the drive from Disc Managment tool - I get the message that says I will end up converting the disc…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
8,201 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.
14,258 questions
asked Jan 7, 2025, 9:43 PM
ZBal 0 Reputation points
edited a comment Jan 8, 2025, 6:57 AM
Mounika Reddy Anumandla 1,380 Reputation points Microsoft Vendor
0 answers

Ensure that the server is running Period Analysis Services Processing

Hello, I have am getting below error while running a job.. I am able to connect the SSAS server with the jobowner, Source: Period Analysis Services Processing Task Description: A connection cannot be made. Ensure that the server is running. End…

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,303 questions
asked Jan 8, 2025, 6:50 AM
Bilal H. Bhatt 116 Reputation points
1 answer

How to export data from SQL Server SSIS to Parquet file format and compress it using Snappy

the challenge is to export data from SQL Server SSIS to Parquet file format and compress it using Snappy. The expected list of tables to exported to Parquet file are 650.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,625 questions
asked Jan 7, 2025, 6:57 PM
Mohammed Aslam Yousuf Hussain 0 Reputation points
answered Jan 8, 2025, 2:33 AM
ZoeHui-MSFT 39,271 Reputation points
4 answers One of the answers was accepted by the question author.

Invalid output when trying to invoke stored-procedure returning output from entityframework core -

Hi gents, can you sort out the following for me. Let me explain the scenario in detail. I have a MSSQL stored procedure that returns me output value. The output value is of int type. Stored Procedure: CREATE procedure…

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
770 questions
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.
109 questions
Entity Framework Core Training
Entity Framework Core Training
Entity Framework Core: A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.Training: Instruction to develop new skills.
5 questions
asked Jan 6, 2025, 5:02 PM
P. G. Choudhury 81 Reputation points
edited the question Jan 8, 2025, 1:40 AM
Jack J Jun 24,626 Reputation points Microsoft Vendor
2 answers

Connecting an On-Premises SQL Server Database with Azure OpenAI Services

Hello, We want to integrate our on-premises SQL Server database with Azure OpenAI services to enable a feature in our web application that allows querying the database using natural language (English). Could you please suggest any documentation or video…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,258 questions
Azure OpenAI Service
Azure OpenAI Service
An Azure service that provides access to OpenAI’s GPT-3 models with enterprise capabilities.
3,490 questions
asked Jan 7, 2025, 9:50 AM
Avinash Vyas 0 Reputation points
answered Jan 7, 2025, 10:20 PM
Erland Sommarskog 114.9K Reputation points MVP
1 answer

Timeline for Release of NEXT GEN Feature for Managed Service in Azure

What is the timeline for the release of the NEXT GEN feature for managed service in Azure? It has been in testing since March 2024. When will it be out of preview mode for general use?

Azure SQL Database
Azure Managed Applications
Azure Managed Applications
An Azure service that enables managed service providers, independent software vendors, and enterprise IT teams to deliver turnkey solutions through the Azure Marketplace or service catalog.
157 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.
14,258 questions
asked Jan 7, 2025, 3:40 PM
Joy, Biju 0 Reputation points
answered Jan 7, 2025, 8:15 PM
Mahesh Kurva 1,625 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Must declare the scalar variable "@n"

Receive the above error generated by the code below. Dim objCommand As SqlCommand = New SqlCommand Dim Connection1 As New SqlConnection(ConnectionString) objCommand.CommandText = "UPDATE names " & "SET n.cc_date = @n.cc_date,…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
4,030 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.
14,258 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,762 questions
asked Jan 7, 2025, 4:18 PM
SuperCoder 136 Reputation points
commented Jan 7, 2025, 6:00 PM
Dan Guzman 9,246 Reputation points
0 answers

How to Register 2 Iaas Sql Server Instances in an Always On Availability Group configuration to recovery services vault

I have 2 Azure VM's and installed SQL Server on both and create an Instance on in an Always On Availability Group. The 2 vm's are not clustered that it there is no WSFC so the failover process is a manual. I am configuring this Instance to backup to a…

Azure Backup
Azure Backup
An Azure backup service that provides built-in management at scale.
1,331 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.
14,258 questions
asked Jan 7, 2025, 2:32 PM
Asare, Kwabena (ZA) 0 Reputation points
commented Jan 7, 2025, 2:36 PM
Asare, Kwabena (ZA) 0 Reputation points
1 answer One of the answers was accepted by the question author.

Can I replicate a failover SQL cluster to Azure VMs?

I have a client who has 2 SQL Server VMs running as a failover cluster for SQL. We are looking for a way to continuously replicate this to Azure VMs. I read through 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.
14,258 questions
asked Jan 6, 2025, 6:38 PM
Brad Wolff 0 Reputation points
commented Jan 7, 2025, 2:17 PM
Brad Wolff 0 Reputation points
1 answer

I have an application which sends table data from ibmias400 tables . How to collect messages and process it according to table names from messages and load it into delta parquet files/SQL tables and use it for reporting purposes?

I have an application which sends table data from ibmias400 tables . How to collect messages and process it according to table names from messages and load it into delta parquet files/SQL tables and use it for reporting purposes?

Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
669 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.
14,258 questions
Azure Event Grid
Azure Event Grid
An Azure event routing service designed for high availability, consistent performance, and dynamic scale.
411 questions
asked Dec 20, 2024, 5:55 AM
Suraj Surendran 60 Reputation points
edited the question Jan 7, 2025, 1:11 PM
Nikhil Duserla 3,720 Reputation points Microsoft Vendor
1 answer

SSRS2022 Custom Header Problem

Hi Guys, I found SSRS2022 16.0.1116.12 Custom Headers…

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,965 questions
asked Jan 7, 2025, 2:59 AM
Wilson Shen 0 Reputation points
answered Jan 7, 2025, 6:38 AM
ZoeHui-MSFT 39,271 Reputation points