SQL Server Management Studio crashing

Posted on 2009-04-28
Last Modified: 2012-05-06
Hi all,

My SQL Server Managemebnt Studio starting crashing yesterday when i had a lot of query windows open. I've attached the error i get - SQLWB SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience.

Today, i can't use MS at all. It crashes for all the actions below
- Running small queries
- Copying results sets
- Expanding the table/view tree

When i double click on the job activity monitor, nothing happens and i can't open the properties window of any jobs.

I'm using SQL Server 2005 and Windows XP and haven't installed any programs recently. Up to now i've been using this installation for a year now with no previous issues.

I've tried uninstalling SQL Sever 2005 and reinstalling the sql workstation software but the issue still persists.

Would any one know how i can fix this?


Question by:smythsit
    LVL 7

    Expert Comment

    Maybe install the latest Service packs.  

    For quick fix I would stop SQL server and restart SQL server to release the memory usage and try that again!  

    Just a thought!
    LVL 7

    Expert Comment


    Author Comment

    Afraid the link doesn't apply. Today when i just open management studio it crashes straight away.

    All the latest service packs are installed on the server. Don't think it has to do with the server because i'm not on it. I'm connecting to it through ms from my work station. When i RDP onto another machine, open up ms and connect to the same server it works fine. It's just something that is happening on my own pc.

    Thought the unistall and istall would work but it looks like it's not unistalling something.

    Any other suggestions would be great thanks.

    Accepted Solution

    Couldn't find a way to correct this issue so wiped computer and installed management studio again.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now