Post reply

Read only?

  • February 26, 2009 at 7:24 am

    #200293

    I imported some data into a SQL Server table. But if I try to delete or add rows to the table, it is telling me that it is read-only. I didn't even know there was a read-only mode. Anybody know how to shut it off?

  • February 26, 2009 at 8:44 am

    #950642

    Does your account has the required rights? And is the import transaction committed?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • February 26, 2009 at 8:55 am

    #950648

    You can set a database to be read_only and you can set a file group to be read_only. I don't think you do that with a table. If it's the database, try the ALTER DATABASE SET READ_WRITE. Of course you have to have it in single user mode when you do it.

    Did something else occur in addition to the data load?

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • February 26, 2009 at 9:37 am

    #950685

    maybe the table was imported under a different schema/user, so you only have read rights to that schema?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply