Sql server DTS Script probs

A

Anjali

I have scheduled DTS Scripts to run automatically for
every 2 hrs.
Sometime one Process is blocked by another, in that case
then Table is locked related to that DTS Script.
so It can not run the next scheduled script.

Could you please help me why processes are blocked and How
I get rid of that?

thanks in advance
Anjali
 
H

Herfried K. Wagner [MVP]

Hello,

Anjali said:
I have scheduled DTS Scripts to run automatically for
every 2 hrs.
Sometime one Process is blocked by another, in that case
then Table is locked related to that DTS Script.
so It can not run the next scheduled script.

Could you please help me why processes are blocked
and How I get rid of that?

Are you talking about VB.NET?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top