none
sql express 2005 RRS feed

  • Question

  • I have placed a tadabase on sql express data, created on visual studio express, database.mdf
    am trying to manage it from server management studio by insert, update, delet date, but every
    time I try to insert data in it says that I cannot because the database is---for ready-olny.

    my question is, how can I change the database to have the full access on itP

    Please thanks

    And Can I have on my computer sql serve express 2005 and 2008?


    DeepF1
    Thursday, February 26, 2009 8:31 PM

Answers

  • Yes you can have both 2005 and 2008 installed on the same machine.

    The syntax to change a database to read/write mode. You can run through management studio express connected to that express instance is below:

    alter database DatabaseName
    SET READ_WRITE

    Thanks! Mike Walsh www.straightpathsql.com/blog
    • Marked as answer by Levi Domingos Friday, March 27, 2009 8:08 PM
    Thursday, February 26, 2009 8:57 PM
  •  HELLO TAHNKS VERY MUCH

    BUT I TRYED AND I GOT THIS:

    Msg 5011, Level 14, State 5, Line 1

    User does not have permission to alter database 'FINALTESTE', the database does not exist, or the database is not in a state that allows access checks.

    Msg 5069, Level 16, State 1, Line 1

    ALTER DATABASE statement failed.


    DeepF1
    • Marked as answer by Levi Domingos Friday, March 27, 2009 8:08 PM
    Thursday, February 26, 2009 9:57 PM
  • Hi,


    It seems that you don’t have enough permission to alter a database on the server you are connecting. To work around the issue, grant yourself the db_datawrite role on the database.

    If you have any more questions, please let me know.

    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Monday, March 2, 2009 8:40 AM
    Moderator

All replies

  • Yes you can have both 2005 and 2008 installed on the same machine.

    The syntax to change a database to read/write mode. You can run through management studio express connected to that express instance is below:

    alter database DatabaseName
    SET READ_WRITE

    Thanks! Mike Walsh www.straightpathsql.com/blog
    • Marked as answer by Levi Domingos Friday, March 27, 2009 8:08 PM
    Thursday, February 26, 2009 8:57 PM
  •  HELLO TAHNKS VERY MUCH

    BUT I TRYED AND I GOT THIS:

    Msg 5011, Level 14, State 5, Line 1

    User does not have permission to alter database 'FINALTESTE', the database does not exist, or the database is not in a state that allows access checks.

    Msg 5069, Level 16, State 1, Line 1

    ALTER DATABASE statement failed.


    DeepF1
    • Marked as answer by Levi Domingos Friday, March 27, 2009 8:08 PM
    Thursday, February 26, 2009 9:57 PM
  • Hi,


    It seems that you don’t have enough permission to alter a database on the server you are connecting. To work around the issue, grant yourself the db_datawrite role on the database.

    If you have any more questions, please let me know.

    Thanks.


    ***Xiao Min Tan***Microsoft Online Community***
    Monday, March 2, 2009 8:40 AM
    Moderator