>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:)
Did you copy the files from a CD or DVD? If so, they probably have the R/O attribute set at the OS level. Use the ATTRIB command or use Explorer - right click/Properties to see if the Read-only attribute is set and needs to be changed.