6,673 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
1 answer One of the answers was accepted by the question author.

Could you please suggest the list of software needed to register and use a custom component in data tools tool box using VS2019 in x64

Issue Description: Facing issue in setting up and running SSIS in debug mode in VS2015 that can recognize 64-Bit C# custom components in Data Tools Tool box. Created MyCustomComponent.dll by referencing below dlls. Took the dlls from…

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.
495 questions
asked 2024-04-08T12:34:26.1366667+00:00
SAILANATHAN Balaji 20 Reputation points
commented 2024-05-08T09:19:14.1533333+00:00
SAILANATHAN Balaji 20 Reputation points
4 answers One of the answers was accepted by the question author.

Is there a 64 bit SSMS?

I‘ve already downloaded and installed SQL Server and SSMS on my computer and then I noticed that the SSMS running on my computer is a 32-bit program. I wonder if there a 64-bit SSMS, for I didn't find it anawhere, including the MicroSoft offical webpage.…

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,777 questions
asked 2021-09-29T11:48:06.173+00:00
子明 李 21 Reputation points
commented 2024-05-07T10:37:11.39+00:00
Vladimir Bazanov 0 Reputation points
3 answers One of the answers was accepted by the question author.

Power BI Reporting Server on Standard DB Engine

Is it possible for the .pbix files to work correctly when the Power BI reporting server (PBIRS) is installed on a Standard DB Engine? According to the below link, it looks contradictory as while it states that Standard edition is possible, it also…

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,808 questions
asked 2024-05-01T18:27:45.1366667+00:00
Jessy 20 Reputation points
accepted 2024-05-07T09:24:20.3433333+00:00
Jessy 20 Reputation points
2 answers One of the answers was accepted by the question author.

Integration service on dedicated SQL instance

Based on an assessment I did on a client's server, I have to move all the integration services to a dedicated machine. We decided to separate ETL and data on two machines. My question is: having a dedicated instance, how do I manage the memory CAP on…

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,777 questions
asked 2024-05-06T09:26:30.6333333+00:00
Alen Cappelletti 931 Reputation points
accepted 2024-05-07T07:29:42.83+00:00
Alen Cappelletti 931 Reputation points
4 answers One of the answers was accepted by the question author.

How to install sql server on windows 11 using UTM on mac,

Hello everyone Please help me. I am stuck here for 2 days. I am trying to install sqlserver 2022 on windows 11 using UTM on mac m1. I am getting this error.

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,777 questions
asked 2023-01-25T16:38:55.61+00:00
Malik Allahyar Nawabi 20 Reputation points
commented 2024-05-07T02:53:33.55+00:00
Merna 0 Reputation points
4 answers One of the answers was accepted by the question author.

SSIS Error when deploying package, the locale identifier LCID is not supported by SQL Server

Hi I am unable to deploy my project from Visual Studio to SSISDB. I have tried to change my localename and locale as well as my region. I have also made MYSQL Server login local but the below error still persists. Can anyone provide guidance TITLE: SQL…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
716 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,777 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2021-05-03T11:51:51.583+00:00
Lynn Carelse 21 Reputation points
answered 2024-05-06T23:54:14.06+00:00
Santiago Guerrero Toro 0 Reputation points
3 answers One of the answers was accepted by the question author.

Connect to Linked Server Database using Azure Data Factory

Hi! I have a database that is a linked server of another. I can connect and copy data of the main database in ADF. But is it possible to also copy data from the linked server database? If yes, how would I do this?

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,777 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,625 questions
asked 2024-05-02T09:28:02.6766667+00:00
Keren Osler 60 Reputation points
accepted 2024-05-06T06:19:21.2933333+00:00
Keren Osler 60 Reputation points
1 answer One of the answers was accepted by the question author.

SQL SSIS on Separate Server

Hi, I'd like to confirm if we need a another SQL license for the server where SSIS will be installed aside from the primary SQL Server? Thank you, Jovsp

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,777 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2024-05-06T02:30:31.79+00:00
ovsp 166 Reputation points
accepted 2024-05-06T05:39:01.97+00:00
ovsp 166 Reputation points
2 answers One of the answers was accepted by the question author.

How to handle text file with delimiter as ~|~ in SSIS Package

I received text file from external vendor with appears to be Pipe Delimited but it has very unusual character before and after Pipe (|). I am using SSIS Package (VS 2019) to import the data into SQL Server database 2019. I am using SQL Agent Job to…

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,777 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2024-05-04T00:46:30.9766667+00:00
Villa 186 Reputation points
accepted 2024-05-06T01:03:42.22+00:00
Villa 186 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to add a index hint to a simple query

I have a table with milions of records CREATE TABLE documents ( id bigint primary key, external_system nvarchar(50), external_docid nvarchar(50)) and non clustered filtered unique index CREATE UNIQUE INDEX documents_ix19 ON…

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,777 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,555 questions
asked 2024-05-02T07:44:45.3166667+00:00
Jan Vávra 251 Reputation points
commented 2024-05-03T20:56:33.33+00:00
Erland Sommarskog 101.4K Reputation points MVP
1 answer One of the answers was accepted by the question author.

Problem with FINDSTRING in SSIS Expression

Best regards. I have a problem when I am trying to use the FINDSTRING function in SSIS of Visual Studio 2022. It gives me the following error, even when I try to use the reference examples from the Microsoft page…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2024-05-02T21:57:47.1666667+00:00
Jorge Hernán Ramírez Jaramillo 20 Reputation points
commented 2024-05-03T15:00:17.74+00:00
Jorge Hernán Ramírez Jaramillo 20 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to install Microsoft SQL server 2022

Hi, Recently, I was trying to install Microsoft SQL Server, but the installation stops and this problem appeared I found a summery.txt file in this direction [C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log] and that's what was on it: …

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,777 questions
asked 2024-04-29T22:50:10.5966667+00:00
Mohamed El Sayed Mohamed 20 Reputation points
accepted 2024-05-03T11:30:34.9566667+00:00
Mohamed El Sayed Mohamed 20 Reputation points
1 answer One of the answers was accepted by the question author.

ADF pipeline with upsert throwing error "The data type text cannot be used as an operand to the UNION, INTERSECT or EXCEPT operators because it is not comparable"

ADF pipeline writing data from AZURE sql to on prem SQL Server with upsert operation. TEXT fields are part of target system, Even though TEXT fields are not selected in select query and are not mandatory fields still throwing error. I cannot change…

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,777 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,625 questions
asked 2024-04-27T01:42:51.18+00:00
Shantanu Dekapurwar 20 Reputation points
commented 2024-05-02T11:59:42.78+00:00
Shantanu Dekapurwar 20 Reputation points
1 answer One of the answers was accepted by the question author.

extend Azure SQL always on availability group to on prem

I have an Azure SQL always on availability group with 2 servers, i need to add another on-prem node to the AG. Azure SQL AG deployed in a single subnet with DNN listener, and i already have S2S connectivity between Azure and on-prem. do i have to migrate…

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.
12,777 questions
asked 2024-04-15T13:47:40.6133333+00:00
Abdalrahman Allahham 40 Reputation points
accepted 2024-05-02T07:31:40.3033333+00:00
Abdalrahman Allahham 40 Reputation points
2 answers One of the answers was accepted by the question author.

Passing NULL date parameters in SQL Server

I'm trying to write a SQL query that retrieves all records from a table, but I also want to be able to filter the results by date range. I'm using stored procedures to execute the query, and I'm passing date parameters to the stored procedure. However,…

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,777 questions
asked 2024-05-01T02:59:30.6933333+00:00
Roberto Carlos Melgar Dorado 80 Reputation points
accepted 2024-05-02T01:09:28.71+00:00
Roberto Carlos Melgar Dorado 80 Reputation points
3 answers One of the answers was accepted by the question author.

SQL Server feature Database Engine Services failed to install

Hi, So, I'm trying to install SQL Server 2019 Developer Edition (the Custom install) and I chose to install the features Database Engine Services, Analysis Services and Integration Services. Everything succeeded except for the Database Engine…

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,777 questions
asked 2021-09-23T20:39:05.98+00:00
cece 116 Reputation points
commented 2024-05-01T07:48:21.96+00:00
SmokeNougat 0 Reputation points
1 answer One of the answers was accepted by the question author.

Azure SQL Server Database serverless or Elastic pool

I'm just getting started with Azure SQL Database and have some questions about pricing. I currently have about 7 databases in use with a free student subscription plan for a development environment. Most of the databases are only used occasionally when…

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.
12,777 questions
asked 2024-01-24T05:27:17.96+00:00
Viet Quoc 20 Reputation points
commented 2024-05-01T04:44:51.51+00:00
Viet Quoc 20 Reputation points
2 answers One of the answers was accepted by the question author.

Dynamic data masking with deterministic values

I would like to check for data masking solution when reading data from a SQL Server database. To elaborate further, the data elements should be encrypted/masked when a set of users querying the tables. The data stored at rest should be clear (i.e.…

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,777 questions
asked 2024-04-24T06:20:07.5333333+00:00
Aravindhan Ravichandran 20 Reputation points
commented 2024-04-30T20:48:19.8966667+00:00
Erland Sommarskog 101.4K Reputation points MVP
4 answers One of the answers was accepted by the question author.

Opening sql files opens new instance of SSMS 18.

Hi, I installed SSMS 18.7.1 in my new laptop and every time I open a new .sql file via double click on it, it opens a new SSMS instance. Its very frustrating. I have repaired SSMS and tried to reinstall again but nothing helped! But if someone had…

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,777 questions
asked 2020-12-08T10:06:35.6+00:00
Vishal Mittal 36 Reputation points
commented 2024-04-30T13:52:43.05+00:00
Marc Scirri 21 Reputation points
2 answers One of the answers was accepted by the question author.

Download link for Microsoft.ACE.OLEDB.12.0

We need the Microsoft.ACE.OLEDB.12.0 32 bit install, can someone please provide a link. We need the functionality to import excel files in via SSMS so the 32 bit driver is required

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,777 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
asked 2024-04-19T14:09:09.57+00:00
Thomas Davies 20 Reputation points
commented 2024-04-30T08:34:46.6166667+00:00
Thomas Davies 20 Reputation points