By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,161 Members | 1,476 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,161 IT Pros & Developers. It's quick & easy.

Sql server DTS Script probs

P: n/a
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

Nov 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hello,

"Anjali" <an*********@yahoo.com> schrieb:
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?

--
Herfried K. Wagner
MVP VB Classic, VB.NET
http://www.mvps.org/dotnet
Nov 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.