Thursday, February 9, 2012

Attach onto different Server - Database Read Only

Hiya,
I have just detached and reattached a database from one server to another
but its read only, can anyone tell me why ?
ThanksHello,
Have you checked the read only flag in the database settings ?
Also check the access rights of the files themselves to see if there is
update permission on the server.
Peter
"A politician needs the ability to foretell what is going to happen
tomorrow, next week, next month, and next year. And to have the ability
afterwards to explain why it didn't happen."
Winston Churchill
"Patricia" wrote:
> Hiya,
> I have just detached and reattached a database from one server to another
> but its read only, can anyone tell me why ?
> Thanks|||Perhaps you need to re-assign user names to SQL Server logins.
Have a look at the description of the following functions in Books Online:
sp_change_users_login
sp_changedbowner
Regards,
Axel
--
"Patricia" <Patricia@.discussions.microsoft.com> schrieb im Newsbeitrag
news:145F306A-FB47-4E7A-9263-FB905631E01F@.microsoft.com...
> Hiya,
> I have just detached and reattached a database from one server to another
> but its read only, can anyone tell me why ?
> Thanks

No comments:

Post a Comment