f you have 2 node SQL Cluster or mirroring, may need to check all the
servers are on same windows hotfix or not. There is an easy way to
check it in PowerShell.
If both Servers are on same hotfix then there will no output. If not it will show which KB is missing on which Server.
**You must have Sysadmin privilege to the SQL server.
$node1 = gwmi win32_quickfixEngineering -ComputerName Server1
$node2 = gwmi win32_quickfixEngineering -ComputerName Server2
Compare-Object -ReferenceObject $node1 -DifferenceObject $node2 -Property HotFixId
If both Servers are on same hotfix then there will no output. If not it will show which KB is missing on which Server.
**You must have Sysadmin privilege to the SQL server.
$node1 = gwmi win32_quickfixEngineering -ComputerName Server1
$node2 = gwmi win32_quickfixEngineering -ComputerName Server2
Compare-Object -ReferenceObject $node1 -DifferenceObject $node2 -Property HotFixId
No comments:
Post a Comment