Link to home
Start Free TrialLog in
Avatar of smythsit
smythsit

asked on

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
Avatar of 60MXG
60MXG

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!
Avatar of smythsit

ASKER

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.
ASKER CERTIFIED SOLUTION
Avatar of smythsit
smythsit

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial