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 |
|
Joe S
Starting Member
2 Posts |
 Posted - 2008-11-19 : 11:55:30
|
| Hello all: I've just strarted using 2008 from using 2000, and find its a lot different. Has anyone found how to be able to do a "return all rows" then be able to edit the data in a cell from the resultset? I found a work-around, but its clumsy.Also, has anyone had problems with SSMS crashing?I'm to the point of going back to 2000 until they get all of this worked out.Thanks,Joe |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-19 : 12:02:36
|
quote:
Originally posted by Joe S
Hello all: I've just strarted using 2008 from using 2000, and find its a lot different. Has anyone found how to be able to do a "return all rows" then be able to edit the data in a cell from the resultset? I found a work-around, but its clumsy.why cant you do it from query editor rather than opening up table?Also, has anyone had problems with SSMS crashing?does the system running ssms have sufficient RAMI'm to the point of going back to 2000 until they get all of this worked out.Thanks,Joe
|
 |
|
|
Joe S
Starting Member
2 Posts |
Posted - 2008-11-19 : 12:26:40
|
| I've just strarted using 2008 from using 2000, and find its a lot different. Has anyone found how to be able to do a "return all rows" then be able to edit the data in a cell from the resultset? I found a work-around, but its clumsy.why cant you do it from query editor rather than opening up table?If you mean using new query, then writing some select statement, then editing from there, it does not allow me to edit cells from there. The only way I have been able to do this is to select "edit top 200 rows", then after the results come up, show the sql, then change to the 200 to some other number to get more rows.Also, has anyone had problems with SSMS crashing?does the system running ssms have sufficient RAMShould have sufficent ram. Have 2 gb. Next time it happens, I will write down the exact error. Happens often enough. Its just that I'm in the middle of a project, and am deciding if I want to go with 2008, or stick with 2000 and did not take the time to look up the error - I wasd focused on what I was doing. This is the first break I've had to check out these issues. The copy of 2008 I am using is not a live copy, my 2000 server is still the live one. |
|
|
|
|
|
|
|
|
Questions on SSMS use