Thank you for  valuable suggestions.

yes , it is required in real time.

when a source table has any insertions that should be transfer and update at target table.

datatype is datetime

Thank you !!

Thank you.

will sqlserver service\database work if i try to install SP2 and if it fails for some reason.?

Thank you.

I am confused whether  SP2 has installed or not.

Do i need to install SP2 for MSSQLSERVER selection and followed by  CU12 installation?

when i run the SP2 , it shows that MSQLSERVER section is "incompletely installed" and shared features section shows "installed".

PFA the screenshots.

shall i run the sp2 for MSQLSERVER selection?

yes it is sql2016 sp2.

select @@version

Microsoft SQL Server 2016 (SP2) (KB4052908) - 13.0.5026.0 (X64) Mar 18 2018 09:11:49 Copyright (c) Microsoft Corporation Enterprise Edition: Core-based Licensing (64-bit) on Windows Server...

Just realized that ,actually we did't install the SP2 separately.

Installed sqlserver2016 enterprise  and sp2 together with same installer file.

Can we still run the SP2 patch and select shared features ?

Thank you. I will re-path with SP2 only for  shared features, then apply the CU.

we don't have Always On Availability Groups configured .

PFA the summary log.

Hi,

Installed the same CU12 in other servers(sqlserver2016 sp2 standard) without any issue.

But its failing on the server sqlserver2016 sp2 Enterprise edition.

Not understanding the exact cause. Any suggestions here .

Please find...

Thank you !!

Hi Jeffrey,

thank you for your response.

I tried with your suggestion but it gives different error below.

script:

$dt=get-date -format "_yyyymmmd_HHmss"

Invoke-Sqlcmd -Query "SELECT * FROM XXXXXXX" -ServerInstance "LocalHost"

$fileName = "D:\folder\data$(dt).csv" |

Export-Csv -Path $fileName...