Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL2008 RC won't attach 2005 mdf - sees it as read only
Message
From
23/06/2008 23:31:08
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01326060
Message ID:
01326251
Views:
16
I believe I am running the MS as administrator. i am logged in with the Vista admin account. Is there something I could check to confirm?

Are you saying that you do not get the behavior I describe if you run MS as admin?

>Try to run the Management Studio exe as Administrator
>
>>
>>My problem is not in changing the read-only once the DB is attached. In the SQL Express 2005 server, MS 2008 will attach the DB and then in the properties I can just flip the property to Read Only = False.
>>
>>The problem is that on the 2008 server the MS 2008 will not attach the DB at all so I don't think I can use ALTER on it, but rather must attach it programmatically with some clause that indicates it should be attached even though it is seen as read only.
>>
>>I wonder if anyone who is running SQL 2008 RC can reproduce this.
>>


Charles Hankey

Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy

Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.

-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin

Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform