What is it that I'm not aware of?
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
Yeah I've noticed it too, so you're not crazy :) Really irritating when it happens!
-
Yeah I've noticed it too, so you're not crazy :) Really irritating when it happens!
For me it happens all the time. At first I thought it was because there was a large database attached(60 GB). But I've detached it, and it still freezes. Aren't there some tweaks: disable that feature, kill that process kind of things?
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
It occurred to me a few times. Actually, it's been a long time ago. I don't know the reason. Have you tried to re-install Management Studio or even the whole SQL Server?
________________________________________________ Tozzi is right: Gaia is getting rid of us. Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 1.0 RC, now with AJAX Preview.
-
It occurred to me a few times. Actually, it's been a long time ago. I don't know the reason. Have you tried to re-install Management Studio or even the whole SQL Server?
________________________________________________ Tozzi is right: Gaia is getting rid of us. Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 1.0 RC, now with AJAX Preview.
Dario Solera wrote:
Have you tried to re-install Management Studio or even the whole SQL Server?
I was kinda hoping to avoid that. I'm on a tight schedule so, no reinstall is possible for the moment. I'm using a way around it. I create my tables independent of the Diagram view and then add them to the diagram. At least this doesn't cause freezing.
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
-
Dario Solera wrote:
Have you tried to re-install Management Studio or even the whole SQL Server?
I was kinda hoping to avoid that. I'm on a tight schedule so, no reinstall is possible for the moment. I'm using a way around it. I create my tables independent of the Diagram view and then add them to the diagram. At least this doesn't cause freezing.
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
Mircea Grelus wrote:
I'm on a tight schedule
I know what you mean. BTW, usually I create tables and other database objects using T-SQL, so I can save the scripts for usage in the future and/or include a database generation feature in the app or DAL.
________________________________________________ Tozzi is right: Gaia is getting rid of us. Personal Blog [ITA] - Tech Blog [ENG] Developing ScrewTurn Wiki 1.0 RC, now with AJAX Preview.
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
Make sure you don't have an blocking triggers on your database. I had a trigger that took forever to run and it blocked saving table changes. Normally it timed out though.
regards, Paul Watson Ireland FeedHenry needs you
eh, stop bugging me about it, give it a couple of days, see what happens.
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
SQL Server has had an SP. Might that help?
Kevin
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
It is a common occurence when you are using the diagramming tool. Just go and get a coffee or chat with a co-worker or surf CP while that is happening.;)
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan
-
It is a common occurence when you are using the diagramming tool. Just go and get a coffee or chat with a co-worker or surf CP while that is happening.;)
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan
I smoked two cigarettes the first time that happend, and it was still "Busy". I'm gonna get cancer before that freaking command finishes.
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
-
I smoked two cigarettes the first time that happend, and it was still "Busy". I'm gonna get cancer before that freaking command finishes.
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
I can now think of a Microsoft KB article titled: "KB: 1878787: Using the SQL Server Management Studio diagramming can cause Cancer" SYMPTOMS When you use the Micrsoft SQL Server diagramming, and smoke while you wait for the process to finish, you may get cancer. CAUSE This issue may occur if both of the following conditions is true: • You use the SQL digramming tools to save changes to tables. • While the Management Studio is doing its work, you decide to smoke. RESOLUTION Microsoft advises you not to smoke while waiting for SQL management studio to save changes to tables. One resolution is to enagage in other activities such as talking to co-workers or surfing code project.
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
Install Sevice Pack 1. SQL2005 was rushed so it won't ship in 2006.
Look where you want to go not where you don't want to crash. Bikers Bible
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
There is most likely a database lock that is causing the crash. SSMS freezes until the query is returned from the database.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06
-
I can now think of a Microsoft KB article titled: "KB: 1878787: Using the SQL Server Management Studio diagramming can cause Cancer" SYMPTOMS When you use the Micrsoft SQL Server diagramming, and smoke while you wait for the process to finish, you may get cancer. CAUSE This issue may occur if both of the following conditions is true: • You use the SQL digramming tools to save changes to tables. • While the Management Studio is doing its work, you decide to smoke. RESOLUTION Microsoft advises you not to smoke while waiting for SQL management studio to save changes to tables. One resolution is to enagage in other activities such as talking to co-workers or surfing code project.
Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it. -Brian Kernighan
Brilliant, Rama. :) Vikram.
-
I'm going nuts here. My SQL Server 2005 Management Studio is always freezing when I'm trying to save a new table I've created in database diagram view. The baloon tooltip come up saying the it's busy performing operations. It remains busy like that "forever". I kill the process fire it up again and there it is: the table created. :confused::mad:
regards, Mircea Many people spend their life going to sleep when they’re not sleepy and waking up while they still are.
-
There is most likely a database lock that is causing the crash. SSMS freezes until the query is returned from the database.
how vital enterprise application are for proactive organizations leveraging collective synergy to think outside the box and formulate their key objectives into a win-win game plan with a quality-driven approach that focuses on empowering key players to drive-up their core competencies and increase expectations with an all-around initiative to drive up the bottom-line. But of course, that's all a "high level" overview of things --thedailywtf 3/21/06
Actually that's a good point. Long-running queries will take Schema Stability locks (shown in SQL 2000 Enterprise Manager as Sch-S) which prevent schema updates from being made until the locks are released.
Stability. What an interesting concept. -- Chris Maunder