P.S. Here is the table in the target database (where the records will eventually be copied to...The only difference between this table, and the table in the main database is that the ConnectionID column is a PKey with a Clustered Index where this table is just a heap).

USE [yQueue_Archive]

GO

/****** Object: Table [dbo].[yConnections] Script Date: 08/14/2012 11:18:19 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[yConnections](

[ConnectionID] [varchar](30) NOT NULL,

[GUID] [uniqueidentifier] NULL,

127.0.0.1 [varchar](50) NULL,

[Interface] [varchar](20) NULL,

[Carrier] [varchar](20) NULL,

[Connects] [int] NULL,

[Disconnects] [int] NULL,

[KeepAlives] [int] NULL,

[TrxIn] [int] NULL,

[TrxOut] [int] NULL,

[TrxOutSMS] [int] NULL,

[TrxErrors] [int] NULL,

[TrxExceptions] [int] NULL,

[BytesIn] [bigint] NULL,

[BytesOut] [bigint] NULL,

[StampStart] [smalldatetime] NULL,

[StampLast] [smalldatetime] NULL,

[Serial] [varchar](20) NULL,

[LastStatus] [varchar](20) NULL,

[MaxQueueTime] [smallint] NULL,

[AvgQueueTime] [smallint] NULL,

[HealthIndex] [smallint] NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF