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 |
|
Kristen
Test
22859 Posts |
 Posted - 2010-10-27 : 06:03:43
|
| I go to a table and then choose DESIGN.I make some changes, I don't save them, and I change my mind and want to abandon them. How do I do that?I have tried closing the DESIGN window, using REFRESH on the Table, and on the DATABASE, and even closing the connection and reopening it ... but when I click DESIGN on that table the changes are still there (marked as "New" and waiting for me to save them).I don't want to close SSMS as I have other panes containing unfinished work.Any way to get SSMS to re-align the DESIGN window with the actual, underlying, table? |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-27 : 06:07:17
|
| Hmmm ... checked the version in Help : About and I get this:Microsoft SQL Server Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )I am running this on the server itself, which was a clean install about 6 months ago ... |
 |
|
|
psychotic_savage
Starting Member
25 Posts |
Posted - 2010-10-27 : 06:25:14
|
| I just tested on Microsoft SQL Server Management Studio 10.50.1600.1 And if I'm in design mode and close the design pane I get the option to to save or not. Once I specify no and design the table again the changes have been disregarded.Could be a version issue. |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-10-27 : 07:03:48
|
| Thanks. I'll ditch the other panes and upgrade it then. |
|
|
|
|
|
|
Abandon Changes in SSMS