Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to attach a Database
Message
 
To
06/12/2006 00:19:28
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01175116
Message ID:
01175759
Views:
6
>I deleted a database using the Window explorer. Then I ran Management Studio there was an entry for the disconnected Database I right clicked on the database and deleted the database from there too. It did deleted without any problem. Now when I copy the database into the folder where I deleted the database before and I run the Management Studio, attached the database it was attached but the Icon of the database is gray and in brackets says(Read-Only).
>1-Why Read-Only.
>2-When I right click on the database the system gets hang and i am unable to do anything.
>3-What is the right way to attach the database?
>The extension of the files are .MDF & .LDF.
>I will be very thankful for you help:)

OTTOMH your database is in single user mode, and yo have to open it up for more then just the sa.

via code:
ALTER DATABASE [YourDB] SET READ_WRITE WITH NO_WAIT

or using the Manager.
in 2005 Manager rt click on the db click on Properties.

Go to the options page, and the Other Options listbox will be populated. Scroll down to Read Only and set it to False
Previous
Reply
Map
View

Click here to load this message in the networking platform