Modify Stored Procedure on read-only SQL Server 2008 database -

Can we only modify the process stored in the copy-copy? I think this will allow you to modify, but will there be any problem?

If your database has been marked read-only, you do not change data or objects Can do

If you need to make any changes, then you need to basically read, write, change, and mark again for reading only.

Use Your_database; Optional Databases Immediate with your DDABase set read_write rollback; Alternatively, see 'Bar' as Foo; Optional DataBab set your password to READ_ONLY with immediate readback;