[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL Server Management Studio crashing

Posted on 2009-04-28
4
Medium Priority
?
1,668 Views
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?

Thanks,

Alan.
SQL-Error.gif
0
Comment
Question by:smythsit
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:60MXG
ID: 24252230
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
 
LVL 7

Expert Comment

by:60MXG
ID: 24252278
0
 

Author Comment

by:smythsit
ID: 24258483
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
 

Accepted Solution

by:
smythsit earned 0 total points
ID: 24305575
Couldn't find a way to correct this issue so wiped computer and installed management studio again.
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

834 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