Azure SQL Database
An Azure relational database service.
5,459 questions
0 answers
more number of rows in database
HI, How to get view which has more number of rows in to it in sql server database
![](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(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
0 answers
After upgradation of SQL server from 2016 to 2022 we are unable to connect with azure storage account using polybase managed identity.
Hi, We have implemented Poly base mechanism to retrieve data from azure storage to SQL Server. However, we are able to connect with storage account using poly base with SAS token in SQL server 2016. As per the documentation SQL server 2022 supports Poly…
asked 2024-07-31T11:42:24.5666667+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(179.20000000000002, 4%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETC%3C/text%3E%3C/svg%3E)
Tarun Chinni (TATA CONSULTANCY SERVICES LTD)
0
Reputation points Microsoft Vendor
asked 2024-07-31T11:42:24.5666667+00:00
Tarun Chinni (TATA CONSULTANCY SERVICES LTD)
0
Reputation points Microsoft Vendor
1 answer
How to connect DB2OLEDB provider data link (SQLSERVER) to one DB2/AS400 with SSL/TLS
Hi there, Target: use DB2OLEDB provider from SQL Server data link to connect to one DB2/AS400 database using port 448 (SSL/TLS) I have one Windows Server 2019 and one SQL Server 2019 installed. I have also instaled Data Access Tool version 7 that…
![](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(137.6, 98%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
1 answer
MS SQL Server SELECT not showing all fields in tables, how to fix?
We use an Azure Synapse SQL server, which contains a copy of our data from a Postgresql server, and I'm trying to list all the table names and fields in each table and display them in a viz in Power BI. Since I'm doing work in PBI this makes it…
Azure
Azure
A cloud computing platform and infrastructure for building, deploying and managing applications and services through a worldwide network of Microsoft-managed datacenters.
1,112 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.
13,389 questions
asked 2024-07-31T09:56:03.7+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(294.40000000000003, 77%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Chuck Roberts
65
Reputation points
answered 2024-07-31T10:43:54.0633333+00:00
Olaf Helper
43,411
Reputation points
0 answers
When following SSIS Tutorial on microsoft learn I receive a data type error
I have following the Microsoft Learn SSIS tutorial and am currently on https://learn.microsoft.com/en-us/sql/integration-services/lesson-1-6-adding-and-configuring-the-lookup-transformations?view=sql-server-ver16 , trying to follow the below step: My…
![](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(64, 22%, 16%)' 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)
2 answers
How to preserve customizations made to views in the 'catalog' schema?
In order to suppress sensitive variables from appearing in the Integration Services Catalogs' execution reports, we have made alterations to views in the 'catalog' schema of the SSIS DB. These customizations are overwritten when SQL Server patches are…
asked 2024-07-30T14:27:25.44+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, 59%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFK%3C/text%3E%3C/svg%3E)
Fitts, Keith (EOL)
0
Reputation points
answered 2024-07-31T09:29:58.41+00:00
ZoeHui-MSFT
35,556
Reputation points
3 answers
One of the answers was accepted by the question author.
Ho to delete SSRS Reports from Portal, when they don´t exist anymore?
Hi, I´m trying to delete an SSRS Report, which is already not present anymore. I deleted it in already in the Project. But it is still listed in SSRS Portal. when I click on the 3 dots for managing the report I get this error. How to delete the…
asked 2024-07-31T06:41:18.78+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(41.6, 96%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDK%3C/text%3E%3C/svg%3E)
Dennis KAUFMANN
0
Reputation points
commented 2024-07-31T09:15:42.5133333+00:00
Dennis KAUFMANN
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Correct way to disable login for SA account??
We need SA to be database owner but reduce potential security issues. I've been told one thing to do is to disable the login permission for the SA account. However, in looking this up I'm confused...everything is t-sql code and it's not clear whether…
asked 2021-07-12T12:23:10.95+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(3.2, 84%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
DisabledLivesMatter
141
Reputation points
commented 2024-07-31T09:03:47.5633333+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(57.599999999999994, 63%, 15%)' 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)
נירה גזית
0
Reputation points
1 answer
Unable to install SQL Server 2022 after uninstalling it. Error: 2147467259
I was having some problems with an older version of SQL Server and SSMS so I decided to just uninstall both of them and try a fresh installation of both. But I get this error 2147467259 message when I try to install SQL Server. Here is one of the files…
asked 2024-07-31T00:15:21.0566667+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, 97%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EER%3C/text%3E%3C/svg%3E)
Eitham Roda
0
Reputation points
commented 2024-07-31T08:28:01.24+00:00
Erland Sommarskog
107.4K
Reputation points MVP
0 answers
Data factory and Dedicated SQL pool with azure pipelines are failing without any issue and it is succeeding with running pipeline multiple times
Hi Team, Azure pipelines are failing without any reason and if we run multiple times it is succeeding. can any one please guide me anything I've to update in azure pipelines.
asked 2024-07-31T06:30:32.02+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(3.2, 59%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
sai pavan
20
Reputation points
edited the question 2024-07-31T08:23:49.71+00:00
Erland Sommarskog
107.4K
Reputation points MVP
2 answers
SQL SERVER 2019 STD AG group filling transaction log up
Hi I have a problem with our High Availability environment, since we have upgraded the servers to Windows 2022 datacentre version, Using WSFC the High Availability seems to continually holding the transaction log file open, it grew to 150gb, which I…
asked 2024-07-30T11:08:55.8666667+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(51.2, 31%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Clive Wightman
126
Reputation points
commented 2024-07-31T08:15:11.16+00:00
Clive Wightman
126
Reputation points
1 answer
Need Macro that will update the date in a sql script entered via GET DATA/SQL in Excel to refresh data in worksheets
I have a sql script that pulls data into a spreadsheet. I need to setup a means for end users to enter a different date into that script and then be able to refresh the output based on the new date.
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,706 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,883 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,732 questions
asked 2024-07-30T16:35:44.6533333+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, 75%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFK%3C/text%3E%3C/svg%3E)
Fantasia, Korena
0
Reputation points
edited the question 2024-07-31T07:35:09.8633333+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(153.6, 89%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJL%3C/text%3E%3C/svg%3E)
Jiachen Li-MSFT
29,416
Reputation points Microsoft Vendor
1 answer
Unable to connect target database which is onprem MS SQL Server in Datafactory
Cannot connect to SQL Database. Please contact SQL server team for further support. Server: '20.81.184.76 1433', Database: 'Target', User: 'target'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the…
asked 2024-07-30T12:43:13.8466667+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(220.8, 7.000000000000001%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
Rajeev Kumar
0
Reputation points
edited the question 2024-07-31T05:59:22.21+00:00
KapilAnanth-MSFT
41,876
Reputation points Microsoft Employee
2 answers
sql server in virtual machine is not starting
After the recent service issue in azure, my sql server in virtual machine is not responding to start/stop. Stuck in provisioning state failed status. Tried reapply and redeploy as well as deallocation. Nothing works
asked 2024-07-30T23:09:51.2266667+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, 9%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Muhsin
0
Reputation points
answered 2024-07-31T05:21:36.1066667+00:00
Olaf Helper
43,411
Reputation points
2 answers
Find duplicate rows in SQL
I don't mind the approach but was I was looking for a PO within my database and found duplicate rows. Like, have a way to catch these.
asked 2024-07-30T18:52:30.0133333+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(294.40000000000003, 82%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJB%3C/text%3E%3C/svg%3E)
Jonathan Brotto
220
Reputation points
answered 2024-07-31T05:16:00.2333333+00:00
Olaf Helper
43,411
Reputation points
1 answer
Error while trying to update Always Encrypted column using a stored procedure
In our development environment, one dedicated machine is set as SQL Server Database server. All other development machines are connected to this server as clients using SQL Server Management Studio. Facing some issues after implementing "Always…
asked 2024-07-26T11:55:34.62+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, 73%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EUG%3C/text%3E%3C/svg%3E)
Usha George
0
Reputation points
commented 2024-07-31T04:19:38.1866667+00:00
Usha George
0
Reputation points
3 answers
sqlcmd Login failed for user
I just set up SQL Server Express a Windows PC and added a couple SQL user logins, a database, a linked database, and a stored procedure. I can login via SSMS (on the same computer) with the SQL user creds, connect to the linked database, and run the…
asked 2024-07-29T14:23:06.8933333+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, 15%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
Mindea
0
Reputation points
commented 2024-07-31T03:07:31.89+00:00
MikeyQiaoMSFT-0444
1,925
Reputation points
1 answer
Unable to process the existing user settings and will overwrite the file with user settings from this session.
I have local install of sql server 2022, with Analysis server & MSRS features enabled, when I launch the management studio, I get the error message below, any suggestions on how to suppress the message ? Thanks Jay Unable to process the existing…
asked 2024-07-30T16:36:54.4966667+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(121.6, 65%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Jay Tabatabai
20
Reputation points
answered 2024-07-31T02:53:38.6+00:00
MikeyQiaoMSFT-0444
1,925
Reputation points
2 answers
Facing issues to connect with synapse workspace/azure sql db via oauth
I want to connect to and access my Synapse Workspace and SQL Pool using OAuth. For this purpose, I have created an app in Azure and assigned the following API permissions: Microsoft Graph: Directory.Read.All (Delegated) Directory.ReadWrite.All…
asked 2024-07-15T05:04:01.89+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, 23%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
SUBHAM KUMAR
0
Reputation points
commented 2024-07-31T02:52:57.67+00:00
SUBHAM KUMAR
0
Reputation points
1 answer
Migrating SSIS 2016 to SSIS 2022 (Oracle Attunity to Oracle Connector v1.2) LDAP
We're upgrading from SQL Server 2016 to SQL Server 2022. Our current SSIS packages utilize Oracle Attunity drivers to extract data from an external Oracle database using the LDAP protocol. We plan to switch to the Microsoft Oracle Connector v1.2…
asked 2024-07-30T02:28:18.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(176, 35%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EW%3C/text%3E%3C/svg%3E)
windows_mss
0
Reputation points
edited the question 2024-07-31T01:53:53.99+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(140.8, 78%, 23%)' 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)
Tianyu Sun-MSFT
29,691
Reputation points Microsoft Vendor