17,559 questions with SQL Server-related tags

Sort by: Updated
0 answers

Azure Data Factory connection failure

Hi I am getting the below error connecting a table from the SQL Server OnPremises to Azure Data Factory. However I have established a connection with SQL Server and Azure Data Factory using the integration runtime and the connection is working well.…

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,402 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,268 questions
asked 2024-03-16T14:04:45.7833333+00:00
Sivakumar Rajabather 20 Reputation points
commented 2024-03-19T08:55:54.41+00:00
phemanth 4,450 Reputation points Microsoft Vendor
1 answer

some questions related to Ola hallengren maintenance scripts

Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone has the answers, please do reply. In which order the rebuild and update stats run. Is it based on tables sorted by name or something else? Is there a way 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,402 questions
asked 2024-03-19T06:14:55.4033333+00:00
Samantha r 1,326 Reputation points
answered 2024-03-19T08:25:41.0533333+00:00
Christoph Muthmann 101 Reputation points
1 answer One of the answers was accepted by the question author.

Is Azure SQL trigger for Functions is generally available for SQL Server hosted on Azure VM

I see that the Azure SQL trigger is now generally available on Azure SQL Database. Here is the link: https://azure.microsoft.com/en-us/updates/general-availability-azure-sql-updates-for-latejanuary-2024 Is it also generally available for SQL Server…

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,402 questions
asked 2024-02-28T14:09:43.76+00:00
Kalyan Babu Basa 20 Reputation points
accepted 2024-03-19T07:56:35.9233333+00:00
Kalyan Babu Basa 20 Reputation points
1 answer

SQL Server Data Quality Client Application keep raising exception

Hello While creating matching policy with Data Quality Services Client application I have encountered the following error message:  As the log says it's related to type serialization issue Microsoft.Ssdqs.Infra.Utilities.BlockedTypeException:…

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,402 questions
asked 2024-03-18T09:12:38.65+00:00
Marek Mądrawski 0 Reputation points
edited a comment 2024-03-19T07:56:04.5033333+00:00
Marek Mądrawski 0 Reputation points
1 answer

SQL Server Enterprise update - Not using more than 128GB RAM

Hi All, We have upgraded SQL Server 2019 Standard Edition to Enterprise edition when it had 128GB Ram. Then the VM was powered off and memory was upgraded to 256GB. After powering it back on SQL Server is not using more than 128GB Ram which is the MAX…

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,402 questions
asked 2024-03-18T16:46:40.1866667+00:00
Carlos D 46 Reputation points
answered 2024-03-19T07:34:22.8766667+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

Indexing on Subscriber

I want to create index directly on subscriber in azure sql replication. Is it possible to do it without affecting the Publisher?

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,402 questions
asked 2024-03-14T07:09:55.77+00:00
Utkarsh upadhyay 0 Reputation points
commented 2024-03-19T07:28:38.44+00:00
Utkarsh upadhyay 0 Reputation points
1 answer

SSRS 2022 subscription - user can't enter a Comment

My user can create a subscription but if she tries to enter anything in the Comment field, she sees an error message "A delivery error has occurred". Looking in the log on the Report Server, I found this message: One of the extension parameters…

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,756 questions
asked 2024-03-17T21:46:00.3+00:00
Nick Ryan 191 Reputation points
answered 2024-03-19T06:47:11.1533333+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

How can i get admin access in sql server express

In my freshly installed sql server expressI can not administrate the server! How can I get admin of my sql server express instance?

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,402 questions
asked 2024-03-19T06:09:26.4933333+00:00
Robert Lalyko 0 Reputation points
answered 2024-03-19T06:33:10.6833333+00:00
Olaf Helper 39,886 Reputation points
1 answer

existing ssrs reports work however when we try to create a new or modify the existing file it won't work

existing ssrs reports work however when we try to create a new or modify the existing file it won't work. It throws the error Value does not fall in the certain Range Database using - Postgres SQL Connector - PGNP OLEDB Provider This issue happened even…

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,756 questions
asked 2024-03-18T22:49:05.2+00:00
Charan Reddy 0 Reputation points
answered 2024-03-19T05:43:19.33+00:00
ZoeHui-MSFT 31,271 Reputation points
2 answers One of the answers was accepted by the question author.

Unable to preview the file in Azure Data Factory - Failure

Hi, I have created a pipeline in Azure Data Factory to migrate a table from MS SQL Server and loaded the table in Azure Data Factory. But unable to preview the table and getting the below error. Please look into this and help me to get this fixed.…

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,402 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,268 questions
asked 2024-03-16T15:57:23.7833333+00:00
Sivakumar Rajabather 20 Reputation points
accepted 2024-03-19T05:29:42.5766667+00:00
Sivakumar Rajabather 20 Reputation points
2 answers One of the answers was accepted by the question author.

Getting error when trying to import an excel file to mssql server 2022 (ssms-19)

TITLE: SQL Server Import and Export Wizard The operation could not be completed. ADDITIONAL INFORMATION: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) BUTTONS: OK

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,402 questions
asked 2023-10-13T04:52:54.18+00:00
Dhanesh Kumar 40 Reputation points
commented 2024-03-19T04:37:59.9333333+00:00
Meenakshi - 0 Reputation points
0 answers

Can I download SQL Express on Mac computer?

Hello, Can I download SQL Server on my Mac? 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.
12,402 questions
asked 2024-03-19T03:56:51.2233333+00:00
TG-9754 0 Reputation points
0 answers

SSIS Oracle destination insert commit size.

Hi, Which property in Oracle destination gives the same result as OLEDB Maximum Insert commit size functionality. right now, Script component is concatenating multiple rows together instead of one row per batch. Simply I want script component output…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
asked 2024-03-12T05:50:24.12+00:00
Zaim Raza 0 Reputation points
commented 2024-03-19T03:46:28.4333333+00:00
Zaim Raza 0 Reputation points
2 answers

How is it possible to set the minimum amount of CPU for a database inside a pool in Azure?

Good afternoon, For some time now, we have been experiencing issues regarding resources in a database pool. as a first solution we decided to increase the amount of vCore to improve processing, for a few days everything went well, but today a strange…

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,402 questions
asked 2023-07-20T17:15:05.3566667+00:00
Bruno Silva 5 Reputation points
commented 2024-03-19T03:34:14.98+00:00
I N 0 Reputation points
1 answer

Can SSRS 2019 consume data from databases on SQL server 2022?

Is is possible for SSRS 2019 to consume data from databases created with SQL server 2022?

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,402 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,756 questions
asked 2024-03-18T14:18:43.8+00:00
Rob Attrill 0 Reputation points
answered 2024-03-19T03:17:57.79+00:00
ZoeHui-MSFT 31,271 Reputation points
2 answers

How to uninstall sql and its packages?

I tried to use SQL Server Integration Services, but it wasn't working at all, I was running on administrator and I checked it was installed. So I tried to uninstall everything to reinstall and it keeps saying "setup failed". It starts to…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
asked 2024-03-17T12:57:34.0733333+00:00
Office 0 Reputation points
answered 2024-03-19T02:27:05.0866667+00:00
ZoeHui-MSFT 31,271 Reputation points
1 answer

Load CSV file with slightly different schemas during each run

I have a CSV file with Column headers as the first line but often sometimes the column position will vary but will be available in a different place. Please help me to advise how to load this dynamic schema change in CSV file to SQL server tables.…

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,402 questions
asked 2024-03-18T17:01:42.6+00:00
commented 2024-03-19T02:22:45.69+00:00
CosmogHong-MSFT 21,146 Reputation points Microsoft Vendor
1 answer

using lag/lead with SQL Server

Struggling with a query using LAG: My goal is to get ONE record per customer and show the CURRENT value of a field and the PREVIOS value of a field all in the same record. I guess I'm going about it all wrong. My current query and a snippet of results 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,402 questions
asked 2024-03-18T20:40:07.4433333+00:00
Dom 706 Reputation points
answered 2024-03-19T02:20:30.7966667+00:00
CosmogHong-MSFT 21,146 Reputation points Microsoft Vendor
4 answers

Microsoft.ace.oledb.12.0 provider is not registered for VS 2022 and run64bitRuntime disabled

I recently upgraded my sql server from 2019 to 2022. And also start to use Visual studio 2022. Because there is some excel destination or source file in the SSIS package, I got some errors like Microsoft.ace.oledb.12.0 provider is not registered. I see…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
asked 2024-03-15T21:53:36.26+00:00
Anne 276 Reputation points
answered 2024-03-19T02:01:31.4533333+00:00
ZoeHui-MSFT 31,271 Reputation points
0 answers

After upgrade to SQL Server, what does "Register your servers" mean?

In the "Next Steps" part of below link: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-sql-server-using-the-installation-wizard-setup?view=sql-server-ver16 "After you upgrade to SQL Server, complete 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,402 questions
asked 2024-03-19T01:30:24.8+00:00
kuya 0 Reputation points