New answers tagged


If its a named instance, use the instance name and enable the SQL Browser service. Or you can try configuring client aliases on all the servers. EG


I encountered this issue while migrating a publication that includes some scalar UDFs from SQL 2016 to SQL 2019. Changing the database settings on the publisher database did not resolve the issue. And since the subscribers include older versions of SQL Server, adding "WITH INLINE=OFF" is not an option in the function definition. So my solution is to force ...


Yes. See the documentation for a detailed list of steps. SQL Server Replication, change data capture (CDC), and change tracking (CT) are supported on Always On availability groups. Always On availability groups helps provide high availability and additional database recovery capabilities.

Top 50 recent answers are included