>oops the delimiters i used removed the code in between them on the last message
>
>If you are trying to keep the identity column in the new table in tact then you can't bulk copy but you can do an insert select. ex.
>
>INSERT INTO [newdatabase]..[newtable] ([AllColumnsExceptIdentity]) FROM (SELECT [AllColumnsExceptIdentity] FROM [olddatabase]..[oldtable])

Thanks, here is the script I'm running now and it just finished successfully.
-------------------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[CreditInfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[CreditInfo]
GO

CREATE TABLE [dbo].[CreditInfo] (
[CredID] [int] IDENTITY (1, 1) NOT NULL ,
[OriginalID] [int] NOT NULL ,
[State] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[CreditCategory] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreditCat] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[CreditType] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[MiscType] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ccode] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[town] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[county] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[registry] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[city] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[street] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[address] [char] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[searchdate] [datetime] NULL ,
[price] [int] NULL ,
[def1fname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[def1lname] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[def2fname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[def2lname] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[alias1] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[alias1type] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[pl1fname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[pl1lname] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[pl2fname] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[pl2lname] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[sheratty] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[phone] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[deposit] [int] NULL ,
[saledatetm] [datetime] NULL ,
[saleloc] [char] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[origmortg] [datetime] NULL ,
[taxtype1] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[taxtype2] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[initdate] [datetime] NULL ,
[pubdate] [datetime] NULL ,
[pub] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[respdate] [datetime] NULL ,
[book] [int] NULL ,
[page] [int] NULL ,
[docketref] [char] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[extryear] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[extrweek] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[newspname] [char] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[lientype1] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[lientype2] [char] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL

) ON [PRIMARY]
GO
INSERT INTO [CreditInfo]([OriginalID], [State], [creditcat], [credittype], [misctype], [ccode], [town], [county], [registry], [city], [street], [address], [searchdate], [price], [def1fname], [def1lname], [def2fname], [def2lname], [alias1], [alias1type], [pl1fname], [pl1lname], [pl2fname], [pl2lname], [sheratty], [phone], [deposit], [saledatetm], [saleloc], [origmortg], [taxtype1], [taxtype2], [initdate], [pubdate], [pub], [respdate], [book], [page], [docketref], [extryear], [extrweek], [newspname], [lientype1], [lientype2], [CreditCategory])
select [OriginalID], [State], [creditcat], [credittype], [misctype], [ccode], [town], [county], [registry], [city], [street], [address], [searchdate], [price], [def1fname], [def1lname], [def2fname], [def2lname], [alias1], [alias1type], [pl1fname], [pl1lname], [pl2fname], [pl2lname], [sheratty], [phone], [deposit], [saledatetm], [saleloc], [origmortg], [taxtype1], [taxtype2], [initdate], [pubdate], [pub], [respdate], [book], [page], [docketref], [extryear], [extrweek], [newspname], [lientype1], [lientype2], [CreditCategory] from Credit.dbo.CreditInfo