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 |
|
sirmilt
Starting Member
49 Posts |
 Posted - 2010-10-30 : 11:05:35
|
| I'm very new to SQL Server and am using the SSMS to design a database in SQL Server 2008 express R2.I had no trouble creating a table. After later consideration I decided that I should change the size of one of the text data fields. I made the change and tried to save it but was greeted with a lengthy message "Saving Changes is not permitted." the message continues an refers to an option to prevent saving changes. The problem is that I can't find this option so that I can reverse it and permit saving changes.Can anyone point me in the right direction?Milt |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-10-30 : 11:13:08
|
| Look under tools, options, designers, table and database designers.Note that the change you are going to make will recreate the table.Might be better to script the change (so you can see what it is going to do) then run the script instead - it'll save you accidentally doing long running things.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sirmilt
Starting Member
49 Posts |
Posted - 2010-10-30 : 11:17:19
|
| Thank you for the quick (very quick) reply,IT WORKED PERFECTLYMiltMilt |
|
|
|
|
|
|
Change Field in table