18,145 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
2 answers

How can I sync data from a source database table without primary key to the destination database table with primary key

Hi all, If the source MS SQL SERVER 2017 database table does not have primary key but destination MS SQL SERVER 2019 database table has primary key, what is the best way or method to make both tables data in sync? Please take into consideration that…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-23T01:45:18.7933333+00:00
Cindy See 166 Reputation points
edited an answer 2024-05-24T09:43:33.26+00:00
LucyChenMSFT-4874 1,430 Reputation points
0 answers

Transfer documents from sqlserver in varbinary to Azure Blob storage

I am looking to move a large set of documents from a Managed Instance of SQL Server database where the documents are saved in varbinary data type on the sql server table. The ADF dataflow I created doesn't let me select a Azure Blob 'Binary' as the sink…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,753 questions
asked 2024-05-23T16:42:11.0466667+00:00
Reema DSouza 0 Reputation points
edited a comment 2024-05-24T08:05:09.94+00:00
Harishga 4,250 Reputation points Microsoft Vendor
2 answers

framework realated question

what is frame in framework for .net applicatons like .net framework 3.5 and what it indicates for frames

Entity Framework Core
Entity Framework Core
A lightweight, extensible, open-source, and cross-platform version of the Entity Framework data access technology.
702 questions
ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,317 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.
12,899 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.
10,390 questions
ASP.NET API
ASP.NET API
ASP.NET: A set of technologies in the .NET Framework for building web applications and XML web services.API: A software intermediary that allows two applications to interact with each other.
306 questions
asked 2024-05-10T16:37:37.01+00:00
Siddangoud Bharamagoudar 61 Reputation points
commented 2024-05-24T07:17:27.83+00:00
Lan Huang-MSFT 26,526 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

Service Broker Queue - Receive

Hi, I want to read SQL service broker messages and push to Azure service bus. And my .net core application is used for the same. Currently I am using 'receive' command. The problem with 'receive' is that the message is getting deleted from service broker…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-22T11:18:16.0366667+00:00
Santhi Dhanuskodi 165 Reputation points
commented 2024-05-24T06:08:25.3733333+00:00
Santhi Dhanuskodi 165 Reputation points
3 answers

create sp to populate table from one db to another

Hi, how to create Store procedure to populate data from one database table to another database table and do we need to refresh or it will auto sync

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
Azure Database for PostgreSQL
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,826 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,249 questions
asked 2024-05-21T02:56:37.6+00:00
Vineet S 185 Reputation points
commented 2024-05-24T06:02:16.3066667+00:00
ShaktiSingh-MSFT 13,996 Reputation points Microsoft Employee
1 answer

Alternative to Attunity CDC

Looking at blog SQL Server Integration Services (SSIS) Change Data Capture Attunity feature deprecations I am getting confused what to do with all packages using CDC components. Also, question is what to do with new development of incremental update…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
asked 2024-05-23T09:56:32.68+00:00
Nebojsa Ilic 35 Reputation points
answered 2024-05-24T05:51:17.53+00:00
ZoeHui-MSFT 33,626 Reputation points
1 answer

Troubleshooting SQL Server Replication Error During Version Upgrade

How can we resolve a Replication error that occurs when trying to include certain tables in a Publication after migrating from SQL Server 2012 to SQL Server 2019? Removing the affected articles is a temporary solution, but the issue persists for 10…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-22T03:50:56.0266667+00:00
Vanitha Dodla (MINDTREE LIMITED) 40 Reputation points Microsoft Vendor
commented 2024-05-24T05:40:37.05+00:00
LucyChenMSFT-4874 1,430 Reputation points
1 answer

How To send mail with attachment from SQL MI

Hi Team, I am using msdb.dbo.sp_send_dbmail to send mail from sql mi. I need to send this mail with attachment. Since SQL MI does not support file attachment i am looking for the alternatives. I have one https service like https://test/getfile service…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-17T08:52:23.3666667+00:00
Radhakrishnan, Yadu Krishnan (Allianz Technology) 0 Reputation points
commented 2024-05-24T05:39:12.2233333+00:00
LucyChenMSFT-4874 1,430 Reputation points
1 answer

Problems with AlwaysOn, HADR_LOGPROGRESS_SYNC waits and missing log block

Hi Folks! Need help from you ! We have some issues with AlwaysOn synchronisation on high load system and we can it repeat on PROD and LT environmets(not depend from hardware). Configuration: SQL Seerver 2019 EE CU24 Prod- 4 nodes (2 synchronous mode…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-23T13:55:55.1133333+00:00
Viacheslav Nikonorov 0 Reputation points
edited an answer 2024-05-24T05:32:08.2633333+00:00
LucyChenMSFT-4874 1,430 Reputation points
1 answer

SQL Access Strategy

I would like a strategy for the use of Azure SQL with our cloud environment. The DB is in azure SQL. I would like to come up with a solution for giving access to developers and extended/other teams for dev/support needs. WE have to add users and give…

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,473 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.
12,899 questions
asked 2024-05-23T06:06:17.2233333+00:00
Santhi Dhanuskodi 165 Reputation points
commented 2024-05-24T05:19:17.94+00:00
ShaktiSingh-MSFT 13,996 Reputation points Microsoft Employee
1 answer

How to install SQL Server 2022 on Ubuntu Server 24.04 LTS

I couldn't find a proper way to install the SQL Server 2022 on Ubuntu Server 24.04 LTS, I tryed to use the microsoft SQL Server 2022 from Ubuntu 22.04 repo, but couldn't get the service running properly. I ended with this service status (see print). Is…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-24T00:46:20.3866667+00:00
Michael F. Assis 0 Reputation points
edited an answer 2024-05-24T03:22:43.5866667+00:00
MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
2 answers

Getting Access error while trying to enable TCP/IP in Sql server configuration manager

Hi All, I wanted to enable TCP/IP protocols in SQL server configuration manager in my local but getting access denied error Can any one please let me know how to resolve this issue and enable the protocols

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-23T12:01:17.4166667+00:00
Anvitha Boyapati (V) 0 Reputation points
answered 2024-05-24T02:57:33.4066667+00:00
MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
1 answer

does report builder work with AWS RDS MySQL database instances

Hi, I am trying to use ms Report builder with a AWS RDS MySQL database, but am struggling to set up the datasourse. Can you help ? Thanks

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,826 questions
asked 2024-05-23T08:27:01.32+00:00
Roisin O Byrne 0 Reputation points
answered 2024-05-24T02:34:50.7933333+00:00
ZoeHui-MSFT 33,626 Reputation points
0 answers

Deploy SSIS project to SQL Server but fails and causes SQL Server to stop

Hello, I am trying to deploy a SSIS project and have already created the Integration Service Catalogs folder necessary. However, when the deployment happens, it fails and gives the following error message A transport-level error has occurred when…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
asked 2023-12-01T01:11:21.2333333+00:00
Yu, Xueke (JP - AB 余 雪柯) 0 Reputation points
commented 2024-05-24T02:16:25.3866667+00:00
Ruel G. Cabusas 205 Reputation points
0 answers

SQL Agent SSIS job step fails with "The login is from an untrusted domain and cannot be used with Integrated authentication"

A user raised an issue with me today where a SQL Agent SSIS job step was failing with: Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication The SSIS step was using an SSIS subsystem proxy rather than 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.
12,899 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
asked 2023-09-15T16:28:42.2066667+00:00
Peter Bishop 161 Reputation points
commented 2024-05-24T02:12:27.6066667+00:00
Ruel G. Cabusas 205 Reputation points
0 answers

why ssms 20.1 Cannot Open ?

Why my ssms 20.1 that was downloaded on 04/14/24, always run the same popup page message as in the attatchment ? if i choose repaired and wait it finishes and then reboot the computer, the same popup message pops again. Even that I have uninstall 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.
12,899 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,826 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,287 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
asked 2024-04-14T12:05:02.8866667+00:00
Angele Tantiana 5 Reputation points
commented 2024-05-24T02:06:34.9966667+00:00
Ruel G. Cabusas 205 Reputation points
1 answer

SQL View to select data dynamically

Hello I have a requirement to create a SQL view that dynamically selects data from one of two tables, T1 and T2, based on the current date. Here's the requirement: When the current date is between the 21st of this month and the 7th working day ( 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.
12,899 questions
asked 2024-05-23T13:47:41.2266667+00:00
Rohit 226 Reputation points
commented 2024-05-24T01:54:19.3766667+00:00
CosmogHong-MSFT 23,796 Reputation points Microsoft Vendor
3 answers

Unable to connect SQL server to Azure data factory

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'DESKTOP-1J7NBOS', Database: 'DataWarehouse', User: 'ak2'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows 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.
12,899 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,753 questions
asked 2024-05-20T20:53:22.6433333+00:00
Sibbinath, Akhil 0 Reputation points
edited a comment 2024-05-24T01:33:42.48+00:00
MikeyQiao-MSFT 655 Reputation points Microsoft Vendor
1 answer

Which .NET Framework versions can be used for installing Microsoft Report Builder

My question refers to this page: https://www.microsoft.com/en-us/download/details.aspx?id=53613 I need to install Microsoft Report Builder. According to the install instructions, it says .NET framework version 4.6 needs to be installed first. If I…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 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,826 questions
asked 2024-05-23T18:58:01.4433333+00:00
Benjamin 0 Reputation points
edited an answer 2024-05-24T01:29:48.7266667+00:00
ZoeHui-MSFT 33,626 Reputation points
1 answer One of the answers was accepted by the question author.

Need help migrating sql to azure synapse.

I m trying to migrate my SQL database into a schema to Azure Synapse database. im not sure on how to do this migration, any help in pointed me to the right direction is appreciated.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,899 questions
asked 2024-05-23T15:17:00.2533333+00:00
jancy 20 Reputation points
accepted 2024-05-23T22:04:18.7533333+00:00
jancy 20 Reputation points