Viewing 10 posts - 1 through 10 (of 10 total)
Hello Scott, can you elaborate on the sp_tableoption, please?
January 25, 2022 at 8:51 pm
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]....
January 25, 2022 at 6:57 pm
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...
January 24, 2022 at 8:58 pm
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...
January 24, 2022 at 4:03 pm
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...
January 23, 2022 at 2:01 am
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...
January 23, 2022 at 1:09 am
Thank you. It was actually the line break/carriage return in the field.
I used...
REPLACE(col, CHAR(13) + CHAR(10), '')
November 13, 2009 at 12:49 pm
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...
January 22, 2009 at 6:06 am
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...
January 21, 2009 at 12:25 pm
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...
January 21, 2009 at 11:32 am
Viewing 10 posts - 1 through 10 (of 10 total)