"MariaGuzman" <marisa@devdex.com> wrote in message
news:u5hqXxWZFHA.3572@TK2MSFTNGP12.phx.gbl...
> Hi, we have a database that has a merge publication and a transactional
> replication too.
>
> We need to restore one of its backups in another database, so we did it,
> and it reported a succesfull. After that when we tryed to execute and
> update, returns this error:
>
> "Server: Msg 208, Level 16, State 1, Procedure
> ctsv_5650B7828C9A4FDB8D43EB7691270707, Line 2
>
> Invalid object name 'dbo.MSmerge_contents'.
>
> Server: Msg 208, Level 16, State 1, Procedure
> ctsv_5650B7828C9A4FDB8D43EB7691270707, Line 2
>
> Invalid object name 'dbo.MSmerge_contents'.
>
> Server: Msg 208, Level 16, State 1, Procedure
> ctsv_5650B7828C9A4FDB8D43EB7691270707, Line 2
>
> Invalid object name 'dbo.MSmerge_contents'.
>
> Server: Msg 208, Level 16, State 1, Procedure
> ctsv_5650B7828C9A4FDB8D43EB7691270707, Line 2
>
> Invalid object name 'dbo.MSmerge_contents'.
>
> Server: Msg 4413, Level 16, State 1, Procedure
> upd_5650B7828C9A4FDB8D43EB7691270707, Line 60
>
> Could not use view or function 'ctsv_5650B7828C9A4FDB8D43EB7691270707'
> because of binding errors.
>
> Server: Msg 4413, Level 16, State 1, Procedure
> upd_5650B7828C9A4FDB8D43EB7691270707, Line 60
>
> Could not use view or function 'ctsv_5650B7828C9A4FDB8D43EB7691270707'
> because of binding errors.
>
> Server: Msg 4413, Level 16, State 1, Procedure
> upd_5650B7828C9A4FDB8D43EB7691270707, Line 78
>
> Could not use view or function 'ctsv_5650B7828C9A4FDB8D43EB7691270707'
> because of binding errors.
>
> Server: Msg 4413, Level 16, State 1, Procedure
> upd_5650B7828C9A4FDB8D43EB7691270707, Line 78
>
> Could not use view or function 'ctsv_5650B7828C9A4FDB8D43EB7691270707'
> because of binding errors."
>
> We had to reconfigure the publications in the new database to use it.
> After that we eliminated the publications and tryed to execute the
> updates, and it was the same error. So we had to reconfire the
> publications.
>
> Do some body know why we couldn´t use the new database without the
> publications configured??
>
> thanks a lot for your help.
>
>
> *** Sent via Developersdex http://www.developersdex.com ***