Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    2

    Unanswered: how to set a database to readwrite mode

    Database was copied to another location in read only mode using enterprise manager. how can you reverse this using query analyzer in the new location?

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    master.dbo.sp_dboption N'<DB Name>', N'read only', N'false'
    Paul Young
    (Knowledge is power! Get some!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •