I am running a Microsoft SQL Cluster.
Serer 2003 X-64 Enterprise SP2 R2
SQL 2005 64 bit
I can run the query tonight when the users are off and post the results. I did not run a query last night I relied on what SSMS was telling me .
I ran the SSMS from each server last night when it was the active node.
I logged into server 1 and the SSMS showed server 1 at SP3 when it was the active node.
I failed the cluster over to server2 logged in, and SSMS showed server2 at SP2 .
If SSMS is returning the wrong pathc level how can it be corrected?