INF: Sqldiag.exe Can be Included in an MSDE Custom Setup

Article translations Article translations
Article ID: 243811 - View products that this article applies to.
This article was previously published under Q243811
Expand all | Collapse all

On This Page

SUMMARY

When you install the Microsoft Data Engine (MSDE) from the MSDE redistribution package, you will not get diagnostic tools such as Sqldiag.exe.

This behavior is by design. However, customers can obtain the Sqldiag.exe file from the SQL Server Developer Edition that ships with MSDE for Visual Studio CD (\x86\binn\sqldiag.exe or \alpha\binn\sqldiag.exe) and package that tool in their setup programs.

MORE INFORMATION

The Sqldiag.exe tool is intended to expedite and simplify information gathering by Microsoft Product Support Services.

For MSDE, the sqldiag.exe utility gathers and stores diagnostic information into the \Mssql7\Log\Sqldiag.txt file. This output file includes error logs, output from sp_configure and additional version information. It also stores the contents of the query history trace (if running) in the Mssql7\Log\Sqldiag.trc file.

REFERENCES

For additional information on using the SQLDiag tool, see the "sqldiag Utility" topic in SQL Books Online.

For additional information on installing MSDE, see the Readme.txt file in the MSDE Web download package or in the MSDE CD.

For more information about installing and distributing MSDE using an Installer application, see the following:
http://download.microsoft.com/download/vstudio60ent/Update/6/WIN98MeXP/EN-US/msdeinst.exe
For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
234626 SAMPLE: Setup1.exe Fully Automating MSDE Setup with the Package and Deployment Wizard (PDW)
Resources for developers building applications with MSDE, including white papers, general additional FAQS, and sample code can be found at the following:
http://msdn.microsoft.com/vstudio/msde

Properties

Article ID: 243811 - Last Review: October 17, 2003 - Revision: 2.2
APPLIES TO
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft Data Engine 1.0
Keywords: 
kbbug kbinfo KB243811

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com