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:…
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?
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…
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?
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…
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…
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.…
I have reset windows and when I reinstall sql server 2012 I still cannot install it, how can I fix it?
I got errors "Database Engine Services" and "SQL Server Replication" Failed
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
Can I download SQL Express on Mac computer?
Hello, Can I download SQL Server on my Mac? Thanks!
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…
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…
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?
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…
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.…
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…
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…
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…
I would like some advice on how to use a query to get the total size of each disk drive.
When I try to get the total size of each disk drive using sp_OAGetProperty in mssql, I cannot get a value greater than 17,592,186,040,320 for large drives. I would like to ask for advice on a solution that can be checked using a query. And I don't want…
Can't install SQL Server 2022 Express on new laptop - "wait on the database engine recovery handle failed"
Hello, I tried to install SQL Server 2022 Express on my new laptop. All prerequisites are fulfilled. At the end of the installation I get this error: error message.jpeg The log file of the installation is here: SSEI-Expr_20240315163124.txt Any…