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 |
|
Anya
Starting Member
2 Posts |
 Posted - 2009-06-24 : 09:14:21
|
| I m using Microsoft Server and I realize that some of my tables can be edit , and others can t . How can I change the tables properties , so I can be able to edit all data that I need to ?Thanks in advanceP.S. Should I permit myself as a user in Enterprise Manager to edit data in concrete table ?.... |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-24 : 09:18:38
|
| Not sure what a concrete table is. There are certain tables that should NEVER be manually, anything the begins with "sys" for instance. What rights do you have within SQL? Are you the DBA? If not, there may be a valid business reason that you cannot edit certain tables.Terry-- Procrastinate now! |
 |
|
|
hemantkumar2380
Starting Member
5 Posts |
Posted - 2009-06-24 : 09:22:24
|
| if you want to edit data then use Update command.Like this:Update <table name> set <Column Name> = <Column Value> where conditionOr You Can Edit data Using EnterPrise Manager Like This:Open EnterPrise Manager --> Select Table --> Right Click On Table -->Chose Return All Row-->Then Edit The Datahemant kumar |
|
|
|
Anya
Starting Member
2 Posts |
Posted - 2009-06-24 : 09:38:32
|
Thank you for your quick answers..Actually , Trosscrosby I can t change data in the table I have created by my own  .I have permitions as database owner ... I can use the update command query , but it is just curiously why some of my tables are "changeable" and others are not...I guess I m doing something wrong  Best regards |
|
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2009-06-24 : 10:21:43
|
| Who is the owner of the table? Double-click on the table in enterprise manager and the owner is the second line of info, after table name.Terry-- Procrastinate now! |
|
|
|
|
|
|
Edit data in Microsoft SQL Server 2000