Rank: Member
Groups: Member
Joined: 6/11/2007
Posts: 12
Points: 9
Location: Kalamazoo,MI-USA
|
Hey,
We've myLittleAdmin for sql server 2000 version v.2.7 r.117
When I browse thru the database node->tables->content. I see all the rows on the table but i don't see edit row icon to the left of each rows such that i can edit the rows. This is only occuring to some of the tables not all. This is very urgent since our developers uses GUI to edit tables rows. I'm logged in as sa.
|
Rank: Administration
Groups: Administration
Joined: 9/11/2006
Posts: 605
Points: 649
Location: Enghien Les Bains, France
|
The table needs to have a primary key defined in order to have edit/drop icons available.
Create a primary key on these tables and you will then be able to edit rows.
|
Rank: Member
Groups: Member
Joined: 6/11/2007
Posts: 12
Points: 9
Location: Kalamazoo,MI-USA
|
That worked.
Thanks,
|