I do appreciate the help and everyones concern for my job.  We employ 30 people, one of which is IT related.  Me.  We have no developers or programmers.  I am a Server/Nework/Security guy...

The application is being re-written in .net.  The module that uses the customer info has not yet been re-designed.  The application is not under inhouse development.

I have enterprise manager so it was a little different.  Is this correct (destination table only)?

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ClientExtraInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop...

Jason, thanx for the inital post.  It has me pointed in the right direction.

Now, if I knew what a DDL was I would post it.

The source database has not been...

Sorry, I thought this was the NEWBIE forum.