Hello. We rename some objects from a db using sp_rename.
We then try to use DTS to copy the db to another database.
It is not the first transfer that we do between those 2
db.

The objects that we renames lets say from 'objectname'
to 'spobjectname', are recreated in the new db as
'objectname'. 'objectname' does not exists in the source
db under sysobjects. We ran dbcc checkdb with a
repair_all option to repair everything. It helped a bit
but those phantom objects, here 'objectname' were still
being transfered to our destination database and would
sometime result in error when repeated transfer occured!
Help please

Please see the response to your question in the programming
group. It's best if you don't post multiple independent
messages to different groups - it's hard for everyone to
track who answered what to which message.

-Sue

On Mon, 10 Nov 2003 11:08:04 -0800, "Laurent Lemire"
<anonymous (AT) discussions (DOT) microsoft.com> wrote: