Transactional Replication on a SQL Managed instance as a subscriber with pull subscription
We are doing a transactional Replication to a SQL Managed instance (subscriber) with pull subscription from On-Prem(Publisher/Distributor) We are seeing uninitialized subscription on the replication monitor. How can we troubleshoot this
i have few snapshot transactions, now i need to put nolock/read uncommit for perticular table
hi, I have few snapshot transactions , now my admin has informed me that put no lock in all tables in snapshot transactions, as it was blocking locking deadlocking with others. so I suggested to put read uncommited instead of snapshot when u are…
Issue with Excel Destination character size in SSIS
I am trying to export data from a database table in SQL server 19.1 version to a Excel file using SSIS 2019 excel destination task. One of the fields 'External Notes' coming from SQL database is VARCHAR(5000). I can export everything to excel but the…
SQL Server Maintenance Plan: Cleanup Task
Hello! Some time ago I noticed that my two maintenance plans were working incorrectly: the cleanup tasks that must have been deleting files older then 2 weeks had not been really deleting anything and my oldest files were ~29.02.2024. The reason was that…
Custom skill integration Azure AI Search
0 I have a requirement to crawl an Azure SQL server from Azure AI search. The SQL server exists in different VNET and I have created a Shared Private Link to connect. The Indexer works fine without any problem. As soon as I add a custom webapi skill the…
Error code 0x2AF9 When trying to connect to docker created mssql server with ODBC drivers
I am using Microsoft made images like mcr.microsoft.com/azure-sql-edge or mcr.microsoft.com/mssql/server:latest within docker to create a test environment server. I have installed ODBC drivers from Microsoft as well (17 & 18) and am trying to connect…
How to restore SQL server 2019 database backup (.bak) to SQL server 2017.
Hi, In one of our legacy project we are using SQL Server 2017 database, and in this we need to restore backup (.bak) taken from SQL Server 2019 database. While database restore (taken from 2019) in SQL server 2017 we are getting incompatibility error. …
How to sql dump generation on sql server 2008 ?
Good morning, I use SQL SERVER 2008 R2 and for a few days now I have had disk C filling up due to the generation of SQLDUMP files in the log directory. Can you give me the procedure to disable the generation of these files please. Thanks in advance.
“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQL Server 2014 is almost complete
“wait on the database engine recovery handle failed . check the sql server error log for potential causes ” message appearing when the installation of SQ L Server 2014 is almost complete
Best practice on performing maintenance on a 2 node SQL Server Cluster with no witness.
Hello, We have a two-node SQL Server Cluster with no witness. Each month we patch the secondary server, then perform a failover and then patch the new secondary server. We do nothing special to tell the cluster that a node is going offline for patching.…
how to fix "Event ID 1309 from source ASP.NET 4.0.30319.0 cannot be found" Could not find file 'C:\Windows\TEMP\fsd3ypse.dll'.
Event code: 3005 Event message: An unhandled exception has occurred. Event time: 4/29/2024 10:23:20 AM Event time (UTC): 4/29/2024 5:23:20 PM Event ID: 9b963c660c6142f28d1ee5d6ff0786a3 Event sequence: 61229 Event occurrence: 6 Event detail code: 0…
How To send mail with attachment from SQL MI
Hi Team, I am using msdb.dbo.sp_send_dbmail to send mail from sql mi. I need to send this mail with attachment. Since SQL MI does not support file attachment i am looking for the alternatives. I have one https service like https://test/getfile service…
dacpac project .sqlproj creation. errors with multiple schemas
i have SQL Server database, with objects defined under two schemas, Schema 1 - dbo. Schema 2 - pr. Tables - dbo.person, dbo.orders, pr.person , pr.orders, pr.sales SP= dbo.getpersons, dbo.getdata, pr. salesinfo. when imported the data into .sqlproj…
How to install SQL Server in windows 11? I'm getting error code : 2061893606 while installing.
Could you plz help me with this error. how to fix it..?
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
AKS deployed application to access on-prem server
Hi, I want to connect to on-prem sql server from a .net application which is deployed in AKS. We already have Azure relay/hybrid connection setup for the same, but that requires azure app service. I am looking for options to connect from AKS deployed…
SQL Server - Question marks inserted with Hebrew collation
SQL Server 2019, Developer edition, Windows 10. The client is SSMS 18. When database is created with Hebrew collation, for example, Hebrew_CI_AI, there is no problem, Hebrew strings are inserted and being read as they are. When database is created…
Microsoft programmability model that
libraries to access data on Microsoft 365 services.
Creating Dataset in VS2020 using SQL query rather than visual designer
I'm creating .rdlc reports using the extension in Visual Studio 2022, but when creating Datasets, I'm only able to do using the graphical designer and cannot create or edit Datasets by writing my own SQL. What am I missing?
How to troubleshoot “SQL Server is terminating because of fatal exception C0000005 . Error code 17311
We have a legacy version SQL Server MSSQL 2008 , where we are getting an error “SQL Server is terminating because of fatal exception C0000005 " SQL Service gets stopped frequently on every Sunday. Unable to find solution for the above error , can I…