PRB: SQLDiag Output Incomplete Against Clustered Server

• Microsoft SQL Server version 7.0

SYMPTOMS

When a server is set up with SQL Clustering, the output from SQLDiag is incomplete.

WORKAROUND

Use the following steps to get all information provided by SQLDiag:

1. Connect to the virtual server using Query Analyzer.



2. Run the following command to obtain the SQL Server information:

   
   xp_cmdshell '<shared drive>\mssql7\binn\sqldiag -E -O<local drive>\SQLdiag.txt' 




3. Run the following from a command prompt to get the system information:

   
   winmsd \\<nodename> /a /f  

   Executing the code creates a file, nodename.txt, in the directory from which winmsd was executed. For further information on winmsd parameters, run the following from a command prompt:

   
   winmsd /? 

REFERENCES

Additional query words:

Keywords : kbSQLServ700
Version : winnt:7.0
Platform : winnt
Issue type : kbprb