New answers tagged

0 votes

DBCC CHECKDB Error 2706

Looks like this is a bug and has been fixed in 2017 CU30 and 2019 CU17. Error 2706 occurs when you run DBCC CHECKDB WITH EXTENDED_LOGICAL_CHECKS against a database by using the Table-Valued Function (...
  • 1
2 votes
Accepted

SQL Server XQuery Namepace

Have a look at Add namespaces to queries using WITH XMLNAMESPACES Your query should look something like this with xmlnamespaces('http://www.opengis.net/gml' as gml, 'http://www....
0 votes
Accepted

SQL Server 2016 Transactional Replication with Service packs on 2 Servers

Yes, service packs and minor version differences actually don't usually matter as far as Replication compatibility is concerned. And with Transactional Replication, the requirement is that the ...
  • 28.6k
0 votes
Accepted

Shrinking LDF with replication

We had to assume MSSQL log file are a broken system at this point and had to act before loosing anything. No help from Microsoft support could figure this out. Our current working solution was ...
  • 111

Top 50 recent answers are included