Well, it sounds like the logfile actually does fill up when you delete all
the records in the table, since each deleted row gets logged. You could try
to issue a "truncate table" statement instead. AFAIK, that will not log the
deleted rows to the transaction log.
If you really need to issue the delete statement, you can adjust the size
(restrictions) of the Transaction Log file, by selecting the db in EM
("MMC") and selecting Properties. Go to the Transaction Log tab and see
whether there are any restrictions on the file growth. You may also need to
determine whether there is space available on the appropriate HD. You can
also add another logfile by simply typing in the blank row.
This requires that you have appropriate privilege on that (your) database,
of course.
HTH,
Tore.
PS: Drop the ";" at the end of the statement also.
-----Original Message-----
From: Tim Fletcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 12:05 PM
To: ActiveServerPages
Subject: RE: i can't "delete from 'tablename';"
Sorry, i actualy added them in when writing the mail.
so it ooks like this:
DELETE FROM copies;
any ideas?
Thanks
Tim
-----Message d'origine-----
De : Bostrup, Tore [mailto:[EMAIL PROTECTED]]
Envoy� : lundi 9 septembre 2002 17:33
� : ActiveServerPages
Objet : RE: i can't "delete from 'tablename';"
drop the single quotes from around the table name:
delete from tablename
HTH,
Tore.
-----Original Message-----
From: Tim Fletcher [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 09, 2002 11:35 AM
To: ActiveServerPages
Subject: i can't "delete from 'tablename';"
when i execute the following sql query "delete from 'tablename';" i get the
following error
Serveur�: Msg 9002, Niveau 17, �tat 2, Ligne 1
The log file for database 'adpfas' is full. Back up the transaction log for
the database to free up some log space.
the problem being that i have not got access to the server exept through th
SQLServer MMC, and i have no rights on the master DB or
any admin tasks.
Thanks for your time
Tim
ps: i've just started receiving mails again, whats happening? Cheers
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to %%email.unsub%%
---
You are currently subscribed to activeserverpages as: [EMAIL PROTECTED]
To unsubscribe send a blank email to
%%email.unsub%%
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
