Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tim
Starting Member
392 Posts |
 Posted - 2003-04-14 : 02:25:01
|
| I have a dts package that calls another. The second one calles a stored procedure to delete some data and then insert some.None of the packages use transactions, the delete/insert statements are not in transactions and the database (sql2k) is set to auto shrink.Any ideas why the transaction log allocated during the package is not released at the end of it? |
|
|
dshelton
Yak Posting Veteran
73 Posts |
Posted - 2003-04-17 : 02:22:08
|
| If you have a full or bulk logged recovery model for your database you will need to backup the log after you call the procedure to free up some space in your log. |
 |
|
|
Tim
Starting Member
392 Posts |
Posted - 2003-04-21 : 09:57:31
|
 oopssimple recovery (of course)thanks for that. |
|
|
|
|
|
|
DTS killing my transaction log