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…
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…
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…
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…
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…
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)
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?
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 Configuration Manager da server açarken hata veriyor.
Sql server Configuration Manager da server açarken hata veriyor. Nasıl çözerim ?
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…
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…
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…
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…
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…
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…
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…
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…
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.
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
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…