Post reply

How to change Property of SQL SERVER'S INSTANCE

  • March 22, 2011 at 11:15 pm

    #148621

    Dear Gethyn Ellis

    You have advices to change database compatibility level change to 90 or version change to 9.00

    When I changing the version that is read only. so how to change the property.

    Thanking You

    Debasis

  • March 24, 2011 at 6:57 am

    #1302913

    See the below attachment.

    You should be able to see this.

    If you want to change from T-sql, check BOL for exact syantx....

  • March 24, 2011 at 7:23 am

    #1302945

    And if the database is read only, you'll have to change it, change the collation, then change it back to read only again

    Right click Dtabase....Properties

    Select "Options" and scroll to the bottom to toggle "Database Read-Only" From True top False , Change the Compatibility level at the top, and then toggle "Database Read-Only" one more time.

    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 3 posts - 1 through 2 (of 2 total)

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