Azure SQL Database
An Azure relational database service.
5,909 questions
2 answers
@@ROWCOUNT issue
Hi there, I had the below code and it worked fine in counting the records inserted and logging insert counts. CREATE PROCEDURE ProcessCustomer AS BEGIN DECLARE @RowsInserted INT; -- Insert into the final table and capture row count …
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 69%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
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?
asked 2025-01-07T15:40:00.9233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
commented 2025-01-13T16:42:23.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 60%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Mahesh Kurva
1,700
Reputation points Microsoft Vendor
2 answers
SQL Azure Failover Group Deployment Fails - Gateway Timeout
I've been trying to create a failover group for a SQL Azure Database Pool (DTU model). The failover database (in location East US) has the same configuration (credentials and service level) as the primary database (in location South Central US). When…
asked 2025-01-11T00:53:39.0666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(108.80000000000001, 37%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
Drew F
1
Reputation point
commented 2025-01-13T15:41:58.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
4,020
Reputation points Microsoft Vendor
1 answer
Request for Insights on Enabling CDC with ADR on Azure SQL Managed Instance
I am reaching out to check if anyone has prior experience or insights on enabling and managing these features together in Azure SQL Managed Instance. Specifically, we are interested in understanding: • Any challenges or considerations when enabling CDC…
asked 2025-01-10T06:30:36.1366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 46%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Satya Varaprasad
1
Reputation point
commented 2025-01-13T15:39:28.49+00:00
NIKHILA NETHIKUNTA
4,020
Reputation points Microsoft Vendor
1 answer
Backup and restore for Azure SQL database using sqlpackage.
I am using sqlpackage to export and import my Azure SQL Database as .bacpac files. My database contains: User-defined schemas and tables SQL Agent-related objects, such as jobs and the ##MS_JobAccount## user External users, such as service principals…
asked 2025-01-09T07:03:12.3266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 60%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Palash Mathur
60
Reputation points
commented 2025-01-13T15:38:44.56+00:00
NIKHILA NETHIKUNTA
4,020
Reputation points Microsoft Vendor
2 answers
Azure SQL server database pricing
I would like to know if the pricing of Azure SQL Server depends on the individual database we create in it or if there is an option at the server-level plan to make unlimited databases in one SQL server.
asked 2025-01-09T03:12:58.3666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 12%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETS%3C/text%3E%3C/svg%3E)
TP021 [Sailesh Kumar]
0
Reputation points
commented 2025-01-13T15:37:21.52+00:00
NIKHILA NETHIKUNTA
4,020
Reputation points Microsoft Vendor
0 answers
Azure SQL Database - on master - long execution of a query program TdService
On Azure SQL Database in Azure there is a really long query running (many days). The details: database_name master program_name TdService It looks like a bug from an Azure SQL Service. On diagnostics while trying to send a support ticket: The…
asked 2025-01-13T14:30:08.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 69%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RaTheMigthy
0
Reputation points
commented 2025-01-13T15:30:18.13+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 4%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sina Salam
15,011
Reputation points
1 answer
Impact of Increasing database size on existing data ?
Hi, we are planning to increase database size as we have run out of space but just wondering the impact of this change on the existing data. Will there be any data loss ?
asked 2025-01-13T11:21:18.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Turkar, Riya-ZA
0
Reputation points
edited the question 2025-01-13T15:23:54.8866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
VarunTha
10,775
Reputation points Microsoft Vendor
2 answers
Getting error creating database in SQL Elastic Pool, but can do it through the portal
I have a SQL Elastic Pool, MyPool, configured with 200 eDTUs and 800 GB storage It contains a database, DBPrimary, with data space used = 127 GB, max storage = 300 GB I have another database outside of the pool, DBProd, with data space used = 117 GB, Max…
asked 2024-12-26T21:50:02.2966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 99%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Joe DeNicola
0
Reputation points
answered 2025-01-13T15:13:58.2433333+00:00
Sina Salam
15,011
Reputation points
1 answer
One of the answers was accepted by the question author.
Question about GA for Next-gen GP for Azure SQL Managed Instance
Hi, Public-preview for Next-gen GP for Azure SQL Managed Instance is available since 21 March 2024, especially support for 32TB (https://techcommunity.microsoft.com/t5/azure-sql-blog/introducing-azure-sql-managed-instance-next-gen-gp/ba-p/4092647). Are…
asked 2024-10-08T13:19:07.2333333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 15%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Marcin Kycia
20
Reputation points
commented 2025-01-13T14:06:57.8366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBJ%3C/text%3E%3C/svg%3E)
Biju Joy
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Unable to Disable Active Trial for Microsoft Defender for SQL in Azure – How to Cancel and Stop Billing
Hello, I am facing an issue where I am unable to disable an active trial for Microsoft Defender for SQL in my Azure account. I have already turned off Cloud Workload Protection (CWP) and see that the Defender for SQL plan is marked as "off,"…
asked 2025-01-09T17:28:53.0933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 5%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Kristiyan Vasilev
20
Reputation points
accepted 2025-01-13T10:20:40.43+00:00
Kristiyan Vasilev
20
Reputation points
1 answer
Guidance With Azure DMS Tool For Maria DB Database Migration
Hello, I am currently working on a Database migration project migrating data from a MariaDB database hosted on AWS over to an Azure SQL DB as part of a cloud consolidation program using an IPsec VPN tunnel. While Azure Database for MariaDB would seem…
asked 2025-01-10T15:48:06.91+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 13%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Marc Hedgley
165
Reputation points
commented 2025-01-13T09:34:22.9766667+00:00
Marc Hedgley
165
Reputation points
1 answer
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises SQL Server
Hi, Interestingly, I was able to create a linked server in the reverse direction—from the on-premises SQL Server to my Azure SQL MI—using a remote login and password for authentication. However, when I attempt to establish the link from Azure SQL MI to…
asked 2025-01-10T13:05:06.25+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 15%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EG%3C/text%3E%3C/svg%3E)
GP
16
Reputation points
commented 2025-01-13T09:16:07.0033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 49%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVK%3C/text%3E%3C/svg%3E)
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
2 answers
✗ Microsoft.SqlServer.Prose.Import.BcpProcessException: Error inserting data into table.
As I understand it, the issue is when importing csv files on Azure Data Studio, the data type is a string and has to convert to another data type. But the error can't convert the string to another data type, how am I supposed to bypass this if I can only…
asked 2025-01-08T13:10:34.2833333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 36%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERT%3C/text%3E%3C/svg%3E)
Ryan Tay
5
Reputation points
commented 2025-01-13T08:39:08.4333333+00:00
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor
1 answer
Identify the SQL query causing spikes
Our MS SQL database in Azure runs at only a few percent DTU - except for occasional spikes to 100%. How do I find out which query is causing the spikes?
asked 2025-01-12T17:25:00.53+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 9%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EME%3C/text%3E%3C/svg%3E)
Mike Edge
0
Reputation points
commented 2025-01-13T08:37:48.98+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(198.4, 69%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESR%3C/text%3E%3C/svg%3E)
Sai Raghunadh M
1,760
Reputation points Microsoft Vendor
1 answer
How to fix issue - The server principal is not able to access the database under the current security context.
I have a Data Factory (DF) and SQL Managed Instance (MI) with 2 databases "dbx" and "dby". Using script activity, my DF executes my stored procedure (SP) written in X. When SP performs a merge from dbx.Table1 to dby.Table1 -->…
asked 2025-01-07T03:09:06.5133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 70%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC1%3C/text%3E%3C/svg%3E)
CyrusDaguro-1527
5
Reputation points
commented 2025-01-13T06:28:25.5866667+00:00
Sai Raghunadh M
1,760
Reputation points Microsoft Vendor
2 answers
When a new database is created database_service_objectives table isn't updated with the new row for that DB
We are resetting the data in database by deleting the existing database and creating a new database with the same name. However database_service_objectives table isn't creating a new row with the latest database_id. the previous database_id is still…
asked 2025-01-08T10:46:19.2966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 60%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKN%3C/text%3E%3C/svg%3E)
KALAHASTI N MaheshKumar
0
Reputation points
edited a comment 2025-01-13T06:16:43.79+00:00
Sai Raghunadh M
1,760
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
How to fix code throwing exception : Microsoft.Data.SqlClient.SqlException: 'Login failed for user '
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
Azure SQL Database
An Azure relational database service.
5,909 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,282 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,188 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
8,150 questions
asked 2025-01-03T00:29:43.2+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 13%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKB%3C/text%3E%3C/svg%3E)
Krishna Basavaraj K S
20
Reputation points
edited the question 2025-01-13T06:03:32.1033333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(166.4, 27%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Raja Pothuraju
10,760
Reputation points Microsoft Vendor
2 answers
Columnstore dmv sys.column_store_segments some columns always NULL Azure Database
Within an Azure SQL database, I have a clustered column store index (many millions of records), with a number of columns of which are mainly INT based. When I interrogate the dmv sys.column_store_segments, the columns [has_nulls], [min_data_id] and…
asked 2024-12-02T16:30:23.0233333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 23%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAO%3C/text%3E%3C/svg%3E)
Arthur Olcot
5
Reputation points
commented 2025-01-12T18:03:52.19+00:00
Erland Sommarskog
115.1K
Reputation points MVP
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…
asked 2025-01-06T04:56:22.5866667+00:00
Mohana Reddy
80
Reputation points
commented 2025-01-10T08:48:42.06+00:00
Vijayalaxmi Kattimani
905
Reputation points Microsoft Vendor