Hello Scott, can you elaborate on the sp_tableoption, please?

Hello Eveyone.  Here is the latest. I decided to try the insert of all the records WITHOUT the incredibly large field [varbinary(max) column...aka the blob of the actual pdf document]....

Hello, thanks you all for providing input.  I am going through all the suggestions.  I'm attempting homebrew01 suggestion now.  A quick note to ScottPletcher, yes look pretty straight forward...I started...

Here is the query....provided by the vendor.

SELECT tblCon.fk_SysId,

CONCAT (tblPasswd.FName, ' ', tblPasswd.LName) AS UpdatedBy,

tblDoc.DocumentName,

tblDoc.Keyword,

tblDoc.FileName,

tblDoc.FileData,

tblDoc.DateCreated,

tblDoc.DocumentId

FROM tblCon

INNER JOIN tblConDoc ON tblCon.ContextId = tblConDoc.fk_ContextId

INNER JOIN tblDoc ON tblConDoc.fk_DocumentId = tblDoc.DocumentId

INNER JOIN tblPasswd ON...

• This reply was modified 2 years, 10 months ago by  rmahon.

Hello Jeff, well this is actually a migration project of a vendor database we are porting the data to a new software product.  They want this data in the table...

Thanks Frederico for your response.  I did try "Select Into" and "Insert Into" earlier but never finished within a 5 hr. window so I finally killed the query.  I haven't...

Thank you. It was actually the line break/carriage return in the field.

I used...

REPLACE(col, CHAR(13) + CHAR(10), '')

I verified the user that is used to start the SQL Server Agent under the SQL Server Configuration Manager. I then used that user to login to the server...

THANK YOU...THANK YOU...THANK YOU...and THANKS AGAIN!!

When I ran it from the command line as the agent account...it prompted for a trusted key. As soon as I said yes...the process...

Thanks for the reply Mukti -

Is it a must that you create a proxy account? The link below has two methods and states to use one of the...