Post reply

overwriting Database with DTS

  • June 7, 2006 at 6:30 am

    #61781

    Have been able to copy the database by deselecting the Copy database owners option under the copy tab of Copy SQL Objects Tasks, however the following error has popped up.

    Invalid object Name 'dbo.NCI_ATTR_VALUE_NUM.'

    Please note the database owner is the same for the source and destination databases.

    Losing some hair here. Help!!

  • June 7, 2006 at 9:52 am

    #642322

    Is dbo.NCI_ATTR_VALUE_NUM a view or a user-defined function, by any chance?  It could be that dependent objects aren't being created in the destination database in the correct order.  I've had trouble with that in DTS in the past.

    Greg

    Greg

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply