Thanks Jason!...will try your suggestion and see if it addresses my issue.

Thanks for the reply Jack!

We used to store the document images in a table with a column of image dataType and later when we decided to move these images from...

Bhuvnesh, It has inserts and update statements in it.

Thanks

Shashi

Ramesh, when you said open the files and check encoding , do you mean opening it in notepad and check the encoding( I checked and it is ANSI).

Thanks

Shashi

my scripts are on the filesystem and it opens in notepad but I don't see any code in it ,they are all empty. strange is that the filesizes is 256kb...

I have tried openning the file in notepad and it didnt work...any help how to address this issue is greatly appreciated.

I have SQL Server Browser services running

I am connecting from the Management studio

Delay restoring backup setting is set to 0 minutes, should I set some delay there?

I have checked the Job history , jobs are running fine with no errors and how do we check data transfer latency, do you mean delay restoring backup setting in...

Thanks everyone for your inputs on this issue, On secondary server by making SQL Server Agent to run on local Admin Account I could now setup the log shipping with...

Thanks everyone for their inputs onmy issue, I got my Log shipping setup by making SQL server Agent of secondary server to run on my Local Admin account and...

Hi Nicholas, this is what I got to know Local System Account and this has got full access of allresources on the srever and network resources.

Local System Account: This...

Hi , As you said I logged on to secondary server and checked the account SQL server Agent is running on ( I mean I went into SQL server Configuration...

Hi , here is the script for those tables and I need an efficient way of copying 10 million image records from frDocument to frDocument_Copy table

Like...