TechNet Webcast: Troubleshooting Microsoft SQL Server 2000 (Level 200) Friday, February 04, 2005 – 9:30 AM – 11:00 AM Pacific Time

Friday, February 04, 2005 - 9:30 AM - 11:00 AM Pacific Time

Bryan Von Axelson, TechNet Presenter, Microsoft Corporation

In this session we show how to review SQL Server logs, SQL Server events in Event Viewer, and create a Database Maintenance plan that backs up and optimizes your SQL Server databases. We will also discuss how to use SQL Server troubleshooting tools such as SQLDiag.exe, the Database Consistency Checker, and use troubleshooting stored procedures. Finally we will create and then troubleshoot a block in SQL Server using troubleshooting tools and the SQL Server Profiler.

Comments (2)

  1. Oluyemi Abidemi says:

    Please i need assistance in re-installing my SQL software. It was gving me an error message that reads SQLSTATE=IM002…[Microsoft][ODBC Driver manager]…..Data source name not found and no default driver specified. If there is any response please sent to :


  2. Matthew Stephen says:


    I’m sorry with this amount of information its impossible to say what’s wrong. My guess is you might beneift from reinstalling MDAC.

    More information is needed – eg what version of SQL, why are you reinstalling it, the contents of sqlstp.log (in the windows directory). Do any of your other odbc applications work?

    WIth this sort of information I suggest you telephone product support who will be able to take you through a diagnostic – other than that flatten the box and start again may be the easiest thing

Skip to main content