I was hoping I could get a sample query with my data.

Picture perfect my friend. Thank you very much!

Thanks! Insert is failing Let me debug.

Insert Error: Column name or number of supplied values does not match table definition.

Excellent, anyway to put the DB names inside the output?

Jeff, members like you really make this site great!

Thank you very MUCH! You're a lifesaver!

Thank you for all your help!!

Anything else I can do for now?

I ran the DBCC's on the system DB's. Stupid question. Where do I find the output? In my query window I am getting the command completed successfully.

SELECT @@VERSION

--Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86) Feb 9 2007 22:47:07 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows NT 5.2...

Two things jump out at me. Any ideas?

Event Type:Error

Event Source:MSSQL$xxxxx

Event Category:(3)

Event ID:19019

Date:6/30/2010

Time:10:33:38 PM

User:N/A

Computer:xxxxx

Description:

[sqsrvres] CheckServiceAlive: Service is dead

Event Type:Error

Event Source:MSSQL$xxxxx

Event Category:(2)

Event ID:602

Date:6/30/2010

Time:10:33:16 PM

User:N/A

Computer:xxxxx

Description:

Could not find an entry for table...

I understand that. I scripted out the table structure above which shows the data lengths. I was showing the max length of the data did not exceed 8000...

What information do you need? The information I provided you was valid.

All the information you need should be there. I am running:

DECLARE @To int, @From int, @LogonID int

select @To=3000064, @From=500006, @LogonID=1

INSERT INTO ClientXAttributeText (clientid, attributeid, attributevalue, insertedby)

SELECT @To, AttributeID, AttributeValue,...

Nope, that is it. here is the table structure. It's truncating at AttributeValue column.

select max(len(AttributeValue)) from ClientXAttributeText

--3167

USE [Reference]

GO

/****** Object: Table [dbo].[ClientXAttributeText] ...