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.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Edit Doesn't work!

Author  Topic 

DinuSorin
Starting Member

2 Posts

Posted - 2011-06-09 : 05:21:57
Hello,i have a pro blem with SQL Server Management Studio Express:
When i open a table and want to edit it(ex: Ip adress at a table...i put my ip or other than the default i click on execute and everything goes back to defaul)
More detalied:
Go to table=> Edit Ip Adress Row
Original IP: 866.866.866-->i change it to ==>655.655.655
Execute SqL and after that everything goes to normal...everything i edited..The IP adress change automatically from 655.655.655 to the original one 866.866.866
Why ?How can i make it work...i really need to edit this db:(

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2011-06-09 : 07:17:06
Press enter after you make the change instead of clicking the execute icon. That should persist the change unless you don't have permission to update the table or the column is a computed/readonly/identity column.
Go to Top of Page

DinuSorin
Starting Member

2 Posts

Posted - 2011-06-10 : 05:22:29
ty for help it worked:)
Go to Top of Page
   

- Advertisement -