19,297 questions with SQL Server-related tags

Sort by: Updated
Updated Created Answers
0 answers

How to increase memory for sp_execute_external_script commands running Java resources

I am running the sp_execute_external_script stored procedure on SQL Server 2022 on a VM running Windows Server 2022. I am constantly running into memory issues and need a way to increase the amount of memory assigned to this stored procedure…

Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,930 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,866 questions
asked 2024-10-19T18:26:15.7133333+00:00
nt390457 0 Reputation points
2 answers One of the answers was accepted by the question author.

SQL Express 2022 Installation Error 2068119551 on Windows 10 Home.

Hi, I'm having some trouble installing SQL Express - 2019 too, but most recently attempted 2022 in case that solved the issue - onto my laptop. I keep getting the error '2068119551' saying it cannot perform an 'unauthorised operation' after downloading…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,642 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,866 questions
asked 2024-10-17T17:15:23.27+00:00
18LHopwood 20 Reputation points
commented 2024-10-19T16:23:13.94+00:00
18LHopwood 20 Reputation points
4 answers

SQL Server Connection Error (Win32Exception: Unknown error (0x89c5010a))

I am encountering an issue while attempting to establish a connection to SQL Server. The following error message is displayed: Win32Exception: Unknown error (0x89c5010a) SqlException: A network-related or instance-specific error occurred while…

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,866 questions
asked 2024-10-04T07:48:13.05+00:00
Haleniuk Maksum 10 Reputation points
commented 2024-10-19T11:56:20.1533333+00:00
Julie Campbell 0 Reputation points
2 answers

Install SQL Server without Azure Anything

I am trying to install an instance of SQL Server Express 2022 on my Windows 11 machine, for my own use locally. I tried SQLLocalDB and that had it's own myriad of issues. I had to disable my Windows firewall which is disturbing. Then it almost gets…

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,866 questions
asked 2024-10-19T02:06:06.7766667+00:00
Julie Campbell 0 Reputation points
answered 2024-10-19T04:40:57.5066667+00:00
Julie Campbell 0 Reputation points
2 answers

Collation error when running a import job after migrating database

Firstly, I'm not very experienced with SQL so apologies in advance for any incorrect terminology. We have a bespoke application which reports data to SQL express at 5 different sites. These databases are linked to a SQL 2012 server and a job runs for…

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,866 questions
asked 2024-10-18T07:54:50.3+00:00
Graham Thackery 11 Reputation points
commented 2024-10-18T21:55:18.12+00:00
Erland Sommarskog 111.8K Reputation points MVP
1 answer

How to fix this SQL Server error Could not obtain information about Windows NT group/user 'FANSHAWE\jdonoghue', error code 0x54b. (Framework Microsoft SqlClient Data Provider)

Ho to fix this SQL server error : Could not obtain information about Windows NT group/user 'FANSHAWE\jdonoghue', error code 0x54b. (Framework Microsoft SqlClient Data Provider)

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,866 questions
asked 2024-10-18T10:44:04.6433333+00:00
Donoghue, James 0 Reputation points
answered 2024-10-18T21:46:45.5066667+00:00
Erland Sommarskog 111.8K Reputation points MVP
1 answer

Problemas com versão do SQL server

Tenho um servidor executando o SQL Server 2016 Standard Edition e estou precisando voltar um backup nele mas está dando divergência nas versões, como faço para realizar a atualização que aceitaria o meu Backup anterior?

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,866 questions
asked 2024-10-18T19:08:21.7833333+00:00
TI HPF 0 Reputation points
answered 2024-10-18T21:43:36.5866667+00:00
Erland Sommarskog 111.8K Reputation points MVP
0 answers

My table wont show anymore data past the first 1000

Hello all, I'm using ssms ver9 w/ windows auth, and database server type. I'm having trouble see the most recent data. I'm using Rockwell factory talk to write data but, noticing its only showing the fist 1000 rows. According to ssms I haven't had a…

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,866 questions
asked 2024-10-18T19:20:35.1733333+00:00
Austin Hunter 0 Reputation points
commented 2024-10-18T21:40:02.7+00:00
Erland Sommarskog 111.8K Reputation points MVP
0 answers

Sql server Configuration Manager da server açarken hata veriyor.

Sql server Configuration Manager da server açarken hata veriyor. Nasıl çözerim ?

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,866 questions
asked 2024-10-17T13:21:31.5266667+00:00
İbrahim Aydemir 20 Reputation points
commented 2024-10-18T21:35:57.01+00:00
Erland Sommarskog 111.8K Reputation points MVP
1 answer One of the answers was accepted by the question author.

How to fix Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine. Suddenly stopped working.

I am trying to use SQL Server Import Export Wizard to load some basic spreadsheets into a MS Sql database. I use this process monthly, with no issue. This month, I am receiving the errir "Microsoft.ACE.OLEDB.12.0 provider is not registered on the…

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,579 questions
asked 2022-02-16T05:15:01.683+00:00
Holly Osburn 36 Reputation points
commented 2024-10-18T20:14:06.0533333+00:00
Mathiba, Lerato (ML) 0 Reputation points
1 answer One of the answers was accepted by the question author.

How to Access SQL Server Docker (Running on MAC) from Power BI (Running on Parallels)

I am trying to access a SQL Server database through Power BI (in a "Parallels" virtual environment) that is running in Docker on my MacBook. HOW SHOULD I CONFIGURE TO GAIN ACCESS ? I want to be able to access this database within Power…

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,866 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
118 questions
asked 2024-10-16T15:55:15.9833333+00:00
Alan Figueroa 20 Reputation points
accepted 2024-10-18T18:58:31.51+00:00
Alan Figueroa 20 Reputation points
1 answer

SSRS 2019 Subscription Email Bug. Email Priority setting defaults to "Normal" after saving subscriptions as "Low" and "High" priority.

Hello, I seem to be experiencing a bug when creating an email subscription in SSRS 2019. When I set the email priority to "Low" or "High" and Save, I do indeed receive an email marked as either Low or High priority. The issue occurs…

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,928 questions
asked 2023-02-08T17:39:25.9933333+00:00
Lys 0 Reputation points
commented 2024-10-18T18:27:33.01+00:00
Chris Lafrance 0 Reputation points
1 answer

Failover Cluster DNS changes/updates

Hi All, We have a failover cluster in place for our SQL environment. I have noticed that when it fails over it creates a new DNS record for the new IP of the SQL listener. I have removed all the DNS records, created one and then I have set up the DNS…

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,866 questions
Windows Server Clustering
Windows Server Clustering
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Clustering: The grouping of multiple servers in a way that allows them to appear to be a single unit to client computers on a network. Clustering is a means of increasing network capacity, providing live backup in case one of the servers fails, and improving data security.
1,003 questions
asked 2024-10-16T10:04:58.8+00:00
Jason P 141 Reputation points
commented 2024-10-18T15:45:06.18+00:00
Ben Miller-(DBADuck) 110 Reputation points MVP
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,866 questions
asked 2024-06-24T22:25:46.49+00:00
Erick 0 Reputation points
commented 2024-10-18T15:27:43.67+00:00
Erick 0 Reputation points
2 answers

Error in CDC Capture job, "Could not find stored procedure 'sys.sp_ins_dummy_lsn_time_mapping_with_replnoop' "

My team and I have CDC enabled on a table that doesn't frequently receive updates. Each week the table could receive around 5k new rows. We're currently running SQL 2022 Enterprise Edition. Previously SQL 2022 was on RTM and the CDC Capture job worked…

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,866 questions
asked 2024-10-07T21:31:23.8166667+00:00
Godwin, Colby 0 Reputation points
answered 2024-10-18T14:57:05.0766667+00:00
Erland Sommarskog 111.8K Reputation points MVP
2 answers One of the answers was accepted by the question author.

Cannot drop a Columnstore Index

I have a clustred Columnstore Index on a big table (5 billion rows), that I want to drop. So I understand that dropping a clustered columnstore index will convert the columnstore table to a heap. When I do this, DROP INDEX, I get an error message…

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,866 questions
asked 2024-10-15T19:27:42.2366667+00:00
Fredrik M 226 Reputation points
commented 2024-10-18T14:48:50.8866667+00:00
Erland Sommarskog 111.8K Reputation points MVP
2 answers One of the answers was accepted by the question author.

How to use the format string function in the column properties to do custom formatting

Hello,   I have a date_key column with data type whole number and formatted as Text as shown below.     I want to apply this same logic to the date_key column in another table for my measure to work. I don't remember how to use the custom formatting and…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
454 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,285 questions
asked 2023-08-28T17:32:41.98+00:00
Cperer 21 Reputation points
commented 2024-10-18T14:39:12.8266667+00:00
Mattias Kuosku 0 Reputation points
1 answer

Stored Procedure from Redshift to Report builder

Am trying to call a stored procedure from AWS Redshift DB to Report builder. But not able to execute the stored procedure when i give the procedure name under stored procedure section in report builder. Let me know how to achieve this.

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,928 questions
asked 2024-10-17T15:31:12.26+00:00
N, Rubini 0 Reputation points
commented 2024-10-18T14:04:01.7866667+00:00
Michael Taylor 54,401 Reputation points
0 answers

VA2107 - Remove members who should not have access to the database role

ALTER ROLE [UserRole] DROP MEMBER [Principal], is this the correct remediation script for VA2107

Azure SQL Database
Azure Role-based access control
Azure Role-based access control
An Azure service that provides fine-grained access management for Azure resources, enabling you to grant users only the rights they need to perform their jobs.
814 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,866 questions
asked 2024-10-17T06:20:38.8533333+00:00
Biswas, Sauvik 0 Reputation points
commented 2024-10-18T14:03:16.1366667+00:00
NIKHILA NETHIKUNTA 2,790 Reputation points Microsoft Vendor
0 answers

SQL server databases migration to Azure SQL VM using Azure Data studio

Hello, I am migrating the SQL server databases to Azure SQL VM using Azure data studio but step 6 - validating the connectivity failed with below error. I am able to connect to SQL server using SSMS from same server. I can be able to see the…

Azure Database Migration 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.
13,866 questions
Azure Data Studio
Azure Data Studio
A cross-platform database tool for data professionals using on-premises and cloud data platforms on Windows, macOS, and Linux.
118 questions
asked 2024-10-16T12:12:27.3866667+00:00
Sanjeev Koppella 0 Reputation points
edited a comment 2024-10-18T13:41:33.8066667+00:00
Mahesh Kurva 245 Reputation points Microsoft Vendor