exec sp_changedbowner 'PRSDEV' did the trick

Thanks

Thanks for the info.

One last question , once I grant the SELECT permission to userB

How does userB access userA tables without specifying the owner of the table ?

.

Right now when...

Any feedback on this last question would be appreciated

Thanks in advance

John,

Thanks for the info

Last question on this subject, when we restore the .mdf and .ldf from the FULL monthly backup, should we only restore the master .mdf and .ldf or...

Actually one more thing to add, if we restore the master data and log from the monthly backup, would this allow us to restart SQL Server ?

Or will we need to...

Just to clarify , we are planning to do monthly server backups which would include the O/S, SQL binaries and SQL datafiles. We are also planning to do nigthly backups...

We are planning to do a FULL server backup every month or so.

At the same time we will backup the binaries and the data while the services will be down....