MyLittleAdmin

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » MyLittleAdmin

MyLittleAdmin

Rate Topic

Display Mode

Topic Options

Author

Message

george-859478

Posted Wednesday, March 04, 2009 12:27 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 02, 2009 5:11 PM
Points: 22, Visits: 43

Newbie here.
I'm trying to remove some records from various table in my database, but have noticed that some tables will allow this, while others won't. This is a database (and app) that I've "inherited" from someone else and it was they who set up the database (honest! :P ). Would this be a setting somewhere in the SQL setup?
If so, is there any danger attached to making them all editable?

TIA.

Post #668592

Lynn Pettis

Posted Wednesday, March 04, 2009 12:30 PM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:31 PM
Points: 21,588, Visits: 27,381

What error messages are you getting when attempting to delete data?

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #668596

george-859478

Posted Wednesday, March 04, 2009 1:24 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 02, 2009 5:11 PM
Points: 22, Visits: 43

I'm not, Lynn.
I'm simply getting no facility to delete - i.e. there are no icons at the start of the row to do any kind of editing. Some of my other tables have though, but I've no idea how they were created.
Thanks.

Post #668634

dwierenga

Posted Wednesday, March 04, 2009 1:31 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, February 01, 2013 10:28 AM
Points: 12, Visits: 304

This sounds like it's better asked at the myLittleAdmin forums: http://forum.mylittleadmin.com/

I'm wholly unfamiliar with MyLittleAdmin, but I would (wildly) guess the lack of those icons means you lack delete rights on those tables.

Post #668640

george-859478

Posted Wednesday, March 04, 2009 1:35 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 02, 2009 5:11 PM
Points: 22, Visits: 43

Many thanks for that.

Post #668647

george-859478

Posted Wednesday, March 04, 2009 5:59 PM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, June 02, 2009 5:11 PM
Points: 22, Visits: 43

Discovered it was due to lack of an index on the Tables. The ones I could not edit had been created via an MS Access export.

Post #668837

« Prev Topic | Next Topic »

Permissions