Hi all,

B.T.W. Sorry for my poor english.

I have database in SQL server 2000 wich user can access with ASP
page. They connect to the database it and return some info.

I got, in SQL Server, a job that run 1 DTS and some stored procedur. It is
running each hour in a day.

I dont know why but when they are web connection to my databse the job
just hang to Step 1 and never end. I have to Stop the Job and restart it.
Again,
if user are connected to my database, the Job just hang. The weird part is
that I can
run the DTS included in the job manually everytime whitout error, even if
user are connected to it ?!

Someone got the same problem
Should I disconnect all user before runnung the job ?
If yes, how can I do that ?


Thanks

Richard