.MDF and .LDF files that are Read Only

I have a pair of .MDF and .LDF files that I attached to my SQL 2000 server
from the Enterprise Manager. But when the Attach Process was complete, the
icon for that new database was grayed out and it has a (Read-Only) next to
it. After I gave myself every single permission on the SQL server, the
system still won't let me change the configuration properties.
What do I do next?
A couple of guesses here. Was the db in a non-recovered state when you
detached it or was it even properly detached? Are the files them selves set
to Read Only or is the Archive bit set?
Andrew J. Kelly SQL MVP
"racky" <racky@.discussions.microsoft.com> wrote in message
news:8E7FB560-5343-40DD-BEAA-D93C2EB1F265@.microsoft.com...
>I have a pair of .MDF and .LDF files that I attached to my SQL 2000 server
> from the Enterprise Manager. But when the Attach Process was complete,
> the
> icon for that new database was grayed out and it has a (Read-Only) next to
> it. After I gave myself every single permission on the SQL server, the
> system still won't let me change the configuration properties.
> What do I do next?
|||Try the following command:
ALTER DATABASE databasename SET READ_WRITE
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:OG9213wsEHA.2556@.tk2msftngp13.phx.gbl...
> A couple of guesses here. Was the db in a non-recovered state when you
> detached it or was it even properly detached? Are the files them selves
set[vbcol=seagreen]
> to Read Only or is the Archive bit set?
> --
> Andrew J. Kelly SQL MVP
>
> "racky" <racky@.discussions.microsoft.com> wrote in message
> news:8E7FB560-5343-40DD-BEAA-D93C2EB1F265@.microsoft.com...
server[vbcol=seagreen]
to
>
|||I hope he already tried that but your right<g>.
Andrew J. Kelly SQL MVP
"Derrick Leggett" <derrickleggett@.yahoo.com> wrote in message
news:ecGC278sEHA.3460@.TK2MSFTNGP15.phx.gbl...
> Try the following command:
> ALTER DATABASE databasename SET READ_WRITE
>
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:OG9213wsEHA.2556@.tk2msftngp13.phx.gbl...
> set
> server
> to
>