Drop table issues

Good morning,
I have posted a few messages regarding dropping a table
from a SQL 6.5 database. All the suggestions from you good
people have failed. Allow me to recap:
SAP SQL 6.5 DB, SP 5. Have 4 SAP tables and the
sysprocedures table with various 2543, 2541 and 2504
errors. Wanted to drop the 4 SAP tables and re-create
them. I have tried to drop, truncate (thanks Tom) and even
just re-create the index on one table with 18000 rows,
everything results in a long run time and eventually
overflowing my 4GB log file. I'm assuming that SQL is
getting in some kind of loop and eating up my log
segment...?
Does anyone have any other suggestions before I have to
abandon ship and see if I can swim?
Many thanks for your help!
ChetChet
Sounds like you will have to do it the hard way. Write a
script to delete all the rows in the table. Make it a do
it in transactions and delete something like 100,000 at a
time. (Or whatever your transaction log can cope with)
While it runs keep running this command:
dump tran 'dbname' with no_log
It will take a while but it should work.
Hope that cracks it.
John|||Takes a long time even "truncate table"?....
You may want to change the database recovery mode to simple and then trim
your tables. After you're done, put the flag from simple mode back to what
it was followed by a full db backup.
Richard
"Chet" <chet.hodgins@.verizon.net> wrote in message
news:0bf201c352af$a66a13b0$a101280a@.phx.gbl...
> Good morning,
> I have posted a few messages regarding dropping a table
> from a SQL 6.5 database. All the suggestions from you good
> people have failed. Allow me to recap:
> SAP SQL 6.5 DB, SP 5. Have 4 SAP tables and the
> sysprocedures table with various 2543, 2541 and 2504
> errors. Wanted to drop the 4 SAP tables and re-create
> them. I have tried to drop, truncate (thanks Tom) and even
> just re-create the index on one table with 18000 rows,
> everything results in a long run time and eventually
> overflowing my 4GB log file. I'm assuming that SQL is
> getting in some kind of loop and eating up my log
> segment...?
> Does anyone have any other suggestions before I have to
> abandon ship and see if I can swim?
> Many thanks for your help!
> Chet