Hi All,

I need to know whether we can run the psssqldiag through command prompt
and collect the information? If so how?

Thanks in advance,
Prad

I have used pssdiag a couple of times when I was working on a support case
for Microsoft.  They sent pssdiag.exe and some configuration files my way.
I ran the exe via the command prompt and then sent the resulting files to
them.  If you are working with Microsoft on a support case they should give
you all the information that you need.

Show quoteHide quote

See if this helps:
http://msdn.microsoft.com/sql/default.aspx?pull=/library/en-us/dnsqldev/html/sqldev_12072004.asp

Show quoteHide quote

Profiler and set fmtonly On issue
Simple DB Tool
Crosstabs queries
Detecting Tables with no recent activity
SQL reporting services - issues