Azure SQL Database
An Azure relational database service.
5,428 questions
0 answers
Microsoft Applied Skill 4 - Failure to create Databases 1-4
While attempting the "Migrate SQL Server Workloads to Azure SQL Database" it failed to create Databases: DB1, DB2, DB3, and DB4. While DB5 was a partial. Has anyone else had this happen to them? What steps have you taken to resolve this…
asked 2024-07-14T02:43:10.5333333+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(118.4, 92%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jacob Shuster
0
Reputation points
commented 2024-07-24T20:45:16.85+00:00
Jacob Shuster
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Azure - SQL Server on VM: backup DBs directly to blob storage RAGZRS
I'm managing AG of 4 nodes in AZ VMs. SQL Server version is 2016 CU19, largest DB is ~2 TB. Right now we are using Ola Hallengren's scripts with options as below: @MaxTransferSize = 4194304 @NumberOfFiles = 5 (or 10) And backing up to blob…
asked 2021-02-19T03:47:15.717+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, 60%, 32%)' 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)
Vlad Kirov
101
Reputation points
commented 2024-07-24T18:06:55.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(80, 34%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMW%3C/text%3E%3C/svg%3E)
Michael Williams
0
Reputation points
0 answers
Azure Synapse "Message Type Not Found" error when running stored procedure: Appears when lines of code reach certain line length
Hi, We need some technical guidance from either a Azure Synapse specialist to resolve an issue which we are unable to understand / fix despite running through the sql logic bit-by-bit, line-by-line. Any guidance or help would be much appreciated. We have…
asked 2024-07-22T17:24:40.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(288, 76%, 37%)' 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)
Michael King
0
Reputation points
commented 2024-07-24T17:34:49.14+00:00
Michael King
0
Reputation points
0 answers
Lift and Shift SQL server database backups on Azure
HI, Can we schedule daily database backups on Azure portal for lift and shift SQL server which is in AZURE. Thank you
![](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(220.8, 94%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
SSMA - Convert adhoc DML and DDL queries
Hello, Does Microsoft SQL Server Migration Assistant (SSMA) provide a way to convert an ah-doc DML or DDL query from DB2 z/OS syntax to MS SQL Server? By other means, I have an application that today has queries that execute on a DB2 z/OS and after the…
asked 2024-07-24T17:03:00.64+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, 56.00000000000001%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESN%3C/text%3E%3C/svg%3E)
Santo, Nuno
0
Reputation points
asked 2024-07-24T17:03:00.64+00:00
Santo, Nuno
0
Reputation points
0 answers
What to do about "window.$RSjQuery is not a function" in Reserved.ReportViewerWebControl.axd
I inherited an ASP.NET Web Forms project that uses RDLC. It was using the Microsoft.ReportViewer 11.0.3366.16 NuGet package and my task has been to upgrade it to the Microsoft.ReportingServices.ReportViewerControl.WebForms 150.1652.0 NuGet. By…
asked 2024-07-24T15:34:12.08+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(249.60000000000002, 97%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKL%3C/text%3E%3C/svg%3E)
Kevin Lipscomb
0
Reputation points
asked 2024-07-24T15:34:12.08+00:00
Kevin Lipscomb
0
Reputation points
0 answers
Why is SSRS Report Subscription - Shared Schedule dropdown unsorted?
When when creating/changing a SSRS Report Subscription at the point where we need to select a Shared Schedule from the available list, the dropdown that opens is Unsorted and would be nice to have them sorted the same way that they are when Schedules are…
asked 2024-07-24T15:19:56.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(6.4, 54%, 10%)' 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)
Nenea Nelu
66
Reputation points
asked 2024-07-24T15:19:56.53+00:00
Nenea Nelu
66
Reputation points
0 answers
Installing IBMi Access Driver on Azure Data Factory Integration Runtime
Hello, I've been trying to install the Windows version of the IBM i Access Driver on a Data Factory Integration Runtime through adding a script (main.cmd) and the desired installer in a Blob Container This script seems to work perfectly locally but when…
asked 2024-07-24T07:19:18.0966667+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(188.79999999999998, 97%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Alexandru Moise
0
Reputation points
commented 2024-07-24T14:20:12.52+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, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
12,615
Reputation points Microsoft Vendor
1 answer
Cannot uninstall SQL Server Integration Services Projects after VS version 16.0.0 (offline) update
Hi MS, We got a Visual Studio version 16.0.0 (Offline) and SQL Server Integration Services Projects installed. I updated VS to version 16.11.0 from an offline layout. I moved on to trying to update the SQL Server Integration Services Projects version…
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,883 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,525 questions
Visual Studio Extensions
Visual Studio Extensions
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Extensions: A program or program module that adds functionality to or extends the effectiveness of a program.
193 questions
asked 2024-07-24T06:47:23.6766667+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(76.8, 1%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETM%3C/text%3E%3C/svg%3E)
Timbol, Mary
0
Reputation points
edited an answer 2024-07-24T13:45:13.7533333+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(249.60000000000002, 10%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAX%3C/text%3E%3C/svg%3E)
Anna Xiu-MSFT
27,816
Reputation points Microsoft Vendor
2 answers
How to cleanup Python directories Launchpad service
I have installed the Python 3.7 machine learning feature in SQL Server but the memory growth is huge after executing several Python scripts. When you execute a SQL job with a python statement the launchpad creates folders in the…
asked 2023-02-07T15:50:18.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(284.8, 54%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEB%3C/text%3E%3C/svg%3E)
Eric Bezemer
191
Reputation points
commented 2024-07-24T11:26:58.1233333+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(188.79999999999998, 82%, 28%)' 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)
RandomGuy123
0
Reputation points
3 answers
One of the answers was accepted by the question author.
How to access database by External Datasource using Service Principal Name(SPN)
I am seeking a solution for cross-database access via an external data source using Service Principal credentials. Specifically, I want to perform Transact-SQL queries from one database to another using Service Principal credentials. To achieve this, I…
asked 2024-07-21T14:42:53.0533333+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(67.2, 65%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Devendra Parmar
20
Reputation points
commented 2024-07-24T10:39:48.5633333+00:00
Devendra Parmar
20
Reputation points
0 answers
Analysis Services reads data from a data source, but gives connection error while processing multidimensional analysis
I have built an Analysis Services Multidimensional project using Microsoft Visual Studio Professional 2022 with the SQL Server Analysis Services 16.0 extension connected to Analysis Services on a remote SQL Server 2019 instance. The Visual Studio…
asked 2024-07-24T09:58:05.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(60.8, 52%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EGG%3C/text%3E%3C/svg%3E)
Goglio, Gianluigi [NMS Group]
20
Reputation points
asked 2024-07-24T09:58:05.98+00:00
Goglio, Gianluigi [NMS Group]
20
Reputation points
2 answers
Customer Best Practices Assessment: exclude checks/false positives
Is there any way to customize the BPA in Azure ARC for SQL to exclude certain checks or to flag issues as false positives? I've got certain issues being flagged by the BPA however these can't be resolved as the application accessing the database requires…
asked 2024-07-19T09:42:13.16+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(243.2, 0%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBB%3C/text%3E%3C/svg%3E)
Berend Broekhoff
0
Reputation points Microsoft Employee
answered 2024-07-24T09:35:35.1333333+00:00
Berend Broekhoff
0
Reputation points Microsoft Employee
2 answers
Failed to Create Maintenance Plan in SQL Server 2019 show Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap)
Hi, I have been trying to create maintenance plan using maintenance plan wizard in SSMS. As i go through the plan, the prompt show error 'Saving maintenance plan failed' with Exception from HRESULT: 0xC0014001 (Microsoft.SqlServer.DTSRuntimeWrap). The…
asked 2024-07-22T06:12:07.33+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, 57.00000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMD%3C/text%3E%3C/svg%3E)
Muhammad Danial Nu'man Noorman
0
Reputation points Microsoft Vendor
commented 2024-07-24T09:27:25.52+00:00
LucyChenMSFT-4874
2,995
Reputation points
2 answers
How to create Excel Connection to a SQL database
This connection must be validated by a SQL login to ensure the contents of your databases remain secure. The connection can be refreshed to update the content from the SQL database.
asked 2024-07-18T20:11:35.03+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(172.8, 54%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJJ%3C/text%3E%3C/svg%3E)
Jhon jr
0
Reputation points
commented 2024-07-24T08:20:55.21+00:00
LucyChenMSFT-4874
2,995
Reputation points
1 answer
Issue with SQL Server compatibility level 2022 and sp_executesql
One of our customers running SQL standard edition 2022 wanted to explore setting their database's compatibility level to 2022; but when they do this, at least one of our queries fails to return metadata. So they have to keep the compatibility level at…
asked 2024-07-19T20:07:28.8033333+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(288, 95%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEA%3C/text%3E%3C/svg%3E)
Eckels, Adam
0
Reputation points
commented 2024-07-24T08:20:20.6566667+00:00
LucyChenMSFT-4874
2,995
Reputation points
2 answers
How can I find my SQL server License to upgrade Report Server Configuration Manager
Our version of Report Server Config Manager is on Evaluation. We license an Azure sql server from Office365 but I cannot find the license key. I need to upgrade the RSCM but it's requiring a key.
asked 2024-07-22T16:24:00.86+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, 75%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Mt Rose Administrator
0
Reputation points
edited a comment 2024-07-24T08:19:36.8066667+00:00
LucyChenMSFT-4874
2,995
Reputation points
1 answer
Resource Governor questions.
https://www.sqlshack.com/sql-server-2014-resource-governor/ Greetings. I'm using the link above to configure Resource Governor. I run some queries to max out the RAM usage but my PerfMon counters dont elevate the way theirs do. I can see RAM usage…
asked 2024-07-23T22:05:40.0066667+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(44.800000000000004, 26%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
chrisrdba
381
Reputation points
answered 2024-07-24T08:15:25.4333333+00:00
LucyChenMSFT-4874
2,995
Reputation points
1 answer
SQL Agent job step outcome mentions "This security ID may not be assigned as the owner of this object."
Hello, I created a SQL 2016 Agent job which copies & replaces .bak files from Source Files Location to a Network Disk Share Target Files Location that are 1 day old as follows: robocopy G:\Source_Files_Location…
asked 2024-06-17T18:41:45.6+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, 45%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
techresearch7777777
1,801
Reputation points
commented 2024-07-24T07:49:28.91+00:00
Erland Sommarskog
106.8K
Reputation points
8 answers
SSMS takes 10-20 + minutes to open
When I open SSMS, I can l look at see it in Task manager like it is running but it doesn't open for quite some time after that. Sometimes 20 minutes or more. Processor Intel(R) Core(TM) i7-8750H CPU @ 2.20GHz 2.21 GHz Installed RAM 32.0 GB…
asked 2021-06-02T21:42:09.04+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(201.6, 96%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TalComoSoy88
11
Reputation points
commented 2024-07-24T07:14:55.75+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(147.20000000000002, 41%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEY%3C/text%3E%3C/svg%3E)
Edward Young
0
Reputation points