767 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

Find all the path between two nodes of Azure SQL database

I wan to get columns from association table in SELECT caluse , Is there any other way around for this? SELECT subgraph, subgraph as name, EntityTypecode ,aid,adisplaynbr FROM ( SELECT i1.EntityTypecode AS EntityTypecode, i1.EntityAssociationID…

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.
13,151 questions
asked 2024-06-26T21:37:52.4866667+00:00
priyanka 0 Reputation points
edited the question 2024-06-26T21:45:49.94+00:00
priyanka 0 Reputation points
0 answers

Custom logs for SQL databases running on Azure VM

Hi , I would like to capture the databases health and some other basic SQL databases configuration related to health and send them to Log analytics agent . This is specific to SQL Databases running on Azure SQL VM . What would be right approach to push…

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.
13,151 questions
asked 2024-06-26T06:51:51.8433333+00:00
Nikhil Verma 40 Reputation points
commented 2024-06-26T19:04:53.09+00:00
Oury Ba-MSFT 17,476 Reputation points Microsoft Employee
0 answers

What information do I need to use Microsoft Entra authentication methods in a local SSIS Package (other than MFA)

Hi, our team got an issue transferring to Microsoft Entra authentication methods in a local SSIS package to access data from Azure SQL Database from other teams. Backgroud: We used to use the userID and password using SQL server authentication methods…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,500 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,255 questions
asked 2024-06-25T22:56:26.4866667+00:00
David Liu (CSI INTERFUSION INC) 0 Reputation points Microsoft Vendor
commented 2024-06-26T18:45:08.89+00:00
GeethaThatipatri-MSFT 28,852 Reputation points Microsoft Employee
0 answers

Data Flow Cannot Support Error Redirection When Used in a Transaction Error

Hello, I'm attempting to leverage the built-in Transaction functionality but to no avail. I followed the MSFT Learn docs and enabled MSDTC on the database server (same server SSIS is running on). …

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,500 questions
asked 2024-06-26T17:57:05.28+00:00
libpekin 86 Reputation points
0 answers

Writing to the sink failing with error: Invalid column name 'true'

Hi, One of our dataflow is failing in production with following error: 'Job failed due to reason: at Sink 'sink1': Invalid column name 'true'. Invalid column name 'true'. The dataflow inserts records to a Synapse SQL server table. This was working…

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,151 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,969 questions
asked 2024-06-26T13:31:00.6866667+00:00
Subedi, Manish 40 Reputation points
commented 2024-06-26T16:03:20.4733333+00:00
BhargavaGunnam-MSFT 28,351 Reputation points Microsoft Employee
0 answers

SharepointListSource Issue in SSIS when Deploymed on SQL Server 2019

Hello, i have an SSIS Package project that was designed in 2015 and was working fine and deployed on the windows server 2012 R2 targeting SQL Server 2014.Now we are migrating to windows server targeting SQL Server 2019.I took the package and opened it in…

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,151 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,500 questions
asked 2024-06-21T15:50:35.61+00:00
Tumo Maraisane 0 Reputation points
edited the question 2024-06-26T08:35:08.98+00:00
Haoyan Xue_MSFT 21,656 Reputation points Microsoft Vendor
0 answers

System Database Backups for Azure SQL Managed Instance

I don't see the ability to backup system databases for Azure SQL Managed Instance. If the server was lost I would lose server logins, backup information. Is there any documentation regarding why we don't have to backup these databases, and the steps we…

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.
13,151 questions
asked 2024-06-21T20:35:16.1766667+00:00
Chancellor, Joe 0 Reputation points
commented 2024-06-26T06:22:50.09+00:00
ShaktiSingh-MSFT 14,201 Reputation points Microsoft Employee
0 answers

SSMA for DB2 to SQL migration errors - No Authorized routine named 'getvariable' of type 'Function' having compatible arguments was found.

While connecting to DB2 using SSMA getting below eeror : Error occured while collecting data . [Db2/LINUXX8664] SQL0440N No authorized routine named 'GetVariable" of type "Function" having compatible arguments was found. SQLSTAE-42884

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.
507 questions
asked 2024-06-25T15:27:36.86+00:00
Pinky Rajan 0 Reputation points
0 answers

Analysis Service very slow to connect in SQL Management Studio

Hi all, I have a SQL Server, SSAS and SQL Server Management Studio installed on the same PC. Connecting to the SQL Database Engine in SSMS is very fast. However, connecting to SSAS in SSMS is excruciatingly slow, even though it is just a localhost…

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,151 questions
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,258 questions
asked 2024-06-25T04:30:15.7066667+00:00
Norman K. F. Chow 80 Reputation points
0 answers

SQLPackage no longer revokes permissions on object when removed. How do I do that again?

Using SQLPackage we create a Deployment Script and a Rollback Script using DacPac's We have a Current Dacpac of what the current production server contains and then we have a Dacpac created out of Visual Studio with what it is currently. We create…

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,151 questions
asked 2024-06-24T22:25:46.49+00:00
Erick 0 Reputation points
0 answers

Why is my AdventureWorks not coming with the tabels included

When I download Adventureworks are renew, there are no tables included, any help would be great: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver16&tabs=ssms The OLTP one Many thanks

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,151 questions
asked 2024-06-23T06:33:10.6966667+00:00
Hazel Jessup 0 Reputation points
commented 2024-06-24T01:25:26.1833333+00:00
LiHongMSFT-4306 25,246 Reputation points
0 answers

How to read/write to a queue table that is consumed in "n" steps without deadlocks

I have a table queue consumed by 3 groups of processes (3 steps). Step 1 process a batch of records at step 0 and update the step to 1 Step 2 process a batch of records at step 1 and update the step to 2 Step 3 process a batch of records at step 2…

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,151 questions
asked 2024-06-20T20:46:27.9266667+00:00
Jean-Marc Lessard 0 Reputation points
commented 2024-06-21T05:47:15.5066667+00:00
LucyChenMSFT-4874 2,660 Reputation points
0 answers

Unable to see Data Share Invitation from resource provider

Hello, I am creating a SQL Database and this would be the 2nd one I made. The first one went smoothly, and I am now creating one for a client. When I am sent a Data Share Invitation, and hit the accept button, I receive an error: I also notice that…

Azure Data Share
Azure Data Share
An Azure service that is used to share data from multiple sources with other organizations.
49 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,151 questions
asked 2024-06-12T17:20:53.3266667+00:00
Dental Bright Group 0 Reputation points
commented 2024-06-19T04:05:03.99+00:00
PRADEEPCHEEKATLA-MSFT 83,886 Reputation points Microsoft Employee
0 answers

Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.

This is the error message I receive when I run a SSIS package. Only one particular server is causing this issue other servers are connecting and package is getting executed. Warning: SSIS Error Code DTS_W_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. …

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.
507 questions
asked 2024-06-19T02:01:51.49+00:00
Noopura Jaiswal 0 Reputation points
0 answers

SQL Server Server Hang when changing password with SQL Server Configuration Manager 2019

Hi All, Today we experienced a problem with SQL Server 2019 Configuration Manager while we were changing a password. Microsoft SQL Server 2019 (RTM-CU18) (KB5017593) - 15.0.4261.1 (X64) Sep 12 2022 15:07:06 Copyright (C) 2019 Microsoft Corporation …

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,151 questions
asked 2023-03-20T22:03:33.9033333+00:00
Abrams, Dan 86 Reputation points
commented 2024-06-17T14:52:38.2966667+00:00
Harry Larsick 0 Reputation points
0 answers

Best Practices Assessment for Azure-Arc SQL Server

Hi Team, We need to enable Best Practices Assessment (BPA) feature for azure arc enabled SQL servers in 2 subscriptions. What access at what scope is required for enabling this. I have contributor role at subscription level for one and could select the…

Azure Arc
Azure Arc
A Microsoft cloud service that enables deployment of Azure services across hybrid and multicloud environments.
363 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,151 questions
asked 2024-06-14T14:27:48.46+00:00
SujinaSJ-1789 251 Reputation points
0 answers

Columns of data type varbinary(max), varchar(max), or nvarchar(max) always assigned a NULL value when __$operation = 1 or __$operation = 3. how to resolve this.

Columns of data type image, text, and ntext are always assigned a NULL value when __$operation = 1 or __$operation = 3. Columns of data type varbinary(max), varchar(max), or nvarchar(max) are assigned a NULL value when __$operation = 3 unless the column…

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,151 questions
asked 2024-06-11T05:26:26.9866667+00:00
UDAY KIRAN 0 Reputation points
commented 2024-06-12T02:40:08.5466667+00:00
LiHongMSFT-4306 25,246 Reputation points
0 answers

Hey team, I am using uaa login url for custom authentication while accessing web reports.

The problem is that when I am using windows authentication, I am able to see the cookie for the ServiceState API, but if I configure it to use the custom authentication which is by using uaa as mode of authentication mechanism I am not able to see the…

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,854 questions
asked 2024-06-11T10:07:54.39+00:00
Vuppala, Sahit 0 Reputation points
commented 2024-06-11T10:11:17.6933333+00:00
Vuppala, Sahit 0 Reputation points
0 answers

MSSQL - Add Connection Errors

MSSQL Extension Version: v1.19.1 VSCode Version: 1.70.2 (Universal) OS Version: macOS 14.4.1 (23E224) After downloading SQL Server v1.19.1, I ran into the same initial error messages as this issue:…

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,151 questions
asked 2024-04-25T23:26:16.3733333+00:00
Max Zander Scialabba 0 Reputation points
commented 2024-06-09T10:45:35.2066667+00:00
Greg Low 1,660 Reputation points Microsoft Regional Director
0 answers

Issue with Batch Insertion using PreparedStatement in SQL Server

Hi, We are experiencing an issue while executing batch insertion using the preparedStatement.executeBatch() method in our Scala code. The problem is that it is inserting object references instead of actual values for VARCHAR columns. Below are the…

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,151 questions
asked 2024-06-07T08:03:58.87+00:00
Anjali Garg 5 Reputation points
edited the question 2024-06-07T08:15:13.6533333+00:00
Anjali Garg 5 Reputation points