This last factor was actually the kicker:
[quoted text, click to view] > Also, what really odd is that in my source database, I previously dropped
> some obsolete Views, however if I go into the Select Objects listing, I
see
> those Views in the list! Selecting one of these Views results in a
> 'successful' transfer from the source to the target, yet afterwards the
View
> does not exist in either of these databases! What the heck is going on
> here?!!??
There was something weird about the database. I had deleted (dropped) the
views via Enterprise Manager and these views no longer showed up in the
Enterprise Manager, however when I scripted the DB they showed up! Odd. But
this could explain the error. If these 'shadow' views were being scripted
out of order on the target side, and VMSGRECIPIENTS had not yet been
created, then the attempt to create the 'shadow' view would fail and the
error message would make sense.
Anyway, I copied the drop statements from the generated script and executed
them via Query Analyzer. These views no longer show up anywhere, and I no
longer have trouble transferring the DB.
Strange but true stories from the DB Admin trenches.
- Joe Geretz -
[quoted text, click to view] "Joseph Geretz" <jgeretz@nospam.com> wrote in message
news:uMKTvRUDEHA.2576@TK2MSFTNGP11.phx.gbl...
> I'm getting an error when transferring an entire database (all objects,
all
> data, drop all objects before creating, etc.) from one server to another.
>
> the process runs for 99% and then in the final stage 'Creating extended
> properties' I get an error. Double-Clicking brings up the following dialog
> box:
>
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> 'VMSGRECIPIENTS'
>
> A few questions:
>
> First of all, what are extended properties? Perhaps I've been overzealous;
> by default this is not selected, but in my desire to transfer the entire
> database, lock-stock-and-barrel, I checked this on. Perhaps I should leave
> this well enough alone?
>
> Second, VMSGRECIPIENTS is one of my Views. It's in the source database and
> in the target database as well. So what, if anything actually went wrong?
>
> Hmm, I just tried the transfer again without extended properties but no
> good. Same error.
>
> Also, what really odd is that in my source database, I previously dropped
> some obsolete Views, however if I go into the Select Objects listing, I
see
> those Views in the list! Selecting one of these Views results in a
> 'successful' transfer from the source to the target, yet afterwards the
View
> does not exist in either of these databases! What the heck is going on
> here?!!??
>
> Thanks for any help which you can provide.
>
> - Joe Geretz -
>
>
