Sergey, you are indeed something special ! That is exactly what did it. AND IT WORKED!
For benefit of lurkers : Just right-clicked on the SSMS icon, chose Run as Administrator and when I attached the DB to the SQL 2008 server it behaved exactly as I wanted with the DB attaching normally and NOT read-only. (and now poking around in the docs for how to turn off the UAC which is at best annoying. While many people who have known me believe I need something to protect me from myself, I would rather not assign the job to Microsoft ... or the government )
There's always a steak waiting for you in Cleveland, Sergey. <s>
>I'm not using Vista and not planning to but I know that it's not enough to be an administrator because programs may still run under a user privilidges because of freaking UAC. I was suggesting to right click om SSMS exe (whatever it is) and choose Run As Admin.
>
>>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
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.