Thank you Anthony.

I ran SqlService under a domain privileged account and everything start working

I have reset local folder permissions and it worked for local rename. But to copy file from network path e.g. \\server\location , it is throwing access denied error.

Thank you Gail

Thank you Gail and Eirikur Eiriksson. I have enabled the trace on serve to capture execution plans and related details. So that I may able to compare slow and fast...

Thank you Chris. You are correct and initially I had same understanding, but I de-tracked 🙁

Thanks again

Yes, I have confirmed. Overall data set size in temp table is ~100k rows.

When I set offset it terminate on EndRows , but always start from 0. e.g. if I...

Sure, here is code. I have removed some business rules, as I can't post entire code here.

ALTER procedure [dbo].[spPayment]

@CustomerNo int,

@StartDate datetime,

@EndDate datetime,

@InvoiceNo varchar(20),

@pageSize int =null,

@PageNum int...

it is setting correct ,as i have confirmed it via print

Thank you Chris. I agree that your code is working.

My code is working too, but problem is offset always start with 0. everything seems ok. so I asked if I...

Ronkyle,

As you have 2 days of log backups. If you restore latest full backup, do you apply log by looking at create date time or is there some auto way...

Sorry for typo error LSN (Log Sequence Number).

sure jeff , i will

thank you Eirikur Eiriksson

Thank you Shaw. But sp_MS_foreachDB will return...

production has 16 cores but dev has 8.