Hello,

I have a DTS package that has a connection defined for a certain database
so that I can run an execute sql task against the database. I then have
another sql task that runs a stored procedure to attempt to restore to the
same database. Due to the previous sql task my restore fails as the
database is still in use from the first sql task. I changed the catalog
for the connection to a separate database before my restore attempts but
DTS still leaves a connection open to the database. Anyway to kill this
connection or to do something so that my database will no longer have this
user executing a process on the database I'm trying to restore?

thanks.

--
Message posted via http://www.sqlmonster.com

use "Close Connection on Completion" in workflow properties.

--
Simon Worth


"Darren Dobier via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

I can't believe it was that simple. Thanks a lot.

--
Message posted via http://www.sqlmonster.com

no problem

--
Simon Worth


"Darren Dobier via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote