If 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
Part 11 of our series on "Microsoft Windows PowerShell and SQL Server 2008 AMO" discusses how to generate a script for given dimension of the Analysis Service database to XMLA format file.
2009-05-01
2,122 reads
To continue this series on Introduction to Windows PowerShell for the SQL Server DBA, this tip will look at the pipeline and output processing.
2009-03-23
3,574 reads
Learn how to restore an Analysis Services database to the same or different location, from a database backup file with password protection.
2009-02-24
1,756 reads
Part 8 of our discussion on how to check SQL Server using Windows PowerShell examines how to get the SQL Server connection information.
2008-11-12
2,668 reads
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
2008-11-04
2,834 reads
