Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
baja_yu
Starting Member
24 Posts |
 Posted - 2010-05-30 : 16:47:09
|
| I'm not sure if I placed this in the right section, if not I ask the mods to move it where it should be.Here's the question/problem. I'm using Management Studio (like stated thread title, express edition) among other things to manually edit contents of tables (in an online DB). My problem is, for example I have to paste a value in several (maybe even a dozen) records. I click the first cell, it auto-selects the old data, Ctrl+V paste over it, click the next cell (#problem spot here#) and do the same thing again. Now, the problem there is that when I click on the next cell it commits the new data to the DB, status bar shows "Cell is Modified...", and for a moments (up to a couple of seconds) the GUI freezes. Click on the next cell is not processed completely (can't paste again) until the data in the previous is submitted.My question is, is there a way around this? Why couldn't this operation run in a separate thread so as not to disturb the editing (this should probably be asked of the developers at MS). I used EMS SQL Manager earlier which seems to work this way, and it's very quick (but expensive, used 30 day trial). Or, is there a way to delay the commitment of new data, maybe have it done manually, after I'm done, click Update and it would update all changes at once. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
baja_yu
Starting Member
24 Posts |
Posted - 2010-05-30 : 18:03:08
|
| That will take more time, as it is a fairly large table (several tens of thousands of records), I'm going through it manually examining the contents and based on it, for some, I have to copy data from field to another in one or several records. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
baja_yu
Starting Member
24 Posts |
Posted - 2010-05-31 : 20:12:04
|
| I suspected it might turn out that way. Still, I hoped there might be some hard to find option somewhere. In any case, thanks for taking the time to help. I guess I'll learn to live with it. |
|
|
|
|
|
|
|
|
SQL Management Studio 2008 R2, editing