SQL Server Management Studio crashing

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?

Thanks,

Alan.
SQL-Error.gif
smythsitAsked:
Who is Participating?
 
smythsitConnect With a Mentor Author Commented:
Couldn't find a way to correct this issue so wiped computer and installed management studio again.
0
 
60MXGCommented:
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!
0
 
smythsitAuthor Commented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.