Suneel, I tried the command you suggested. The response was as follows:
Transaction information for database 'ModusDB'.
Oldest active transaction:
SPID (server process ID) : 61
UID (user ID) : -1
Name : implicit_transaction
LSN : (16936:112486:1)
Start time : Jan 19 2004 1:14:43:717PM
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
This looks fine to me, given that the query was run at 1:14 pm. Is that correct?
Thanks for your help.
Lapo
On Jan 18, 2004, at 6:54 PM, Suneel Jhangiani wrote:
* This is the modus mailing list *
Lapo,
Try issuing the following command to see if you have any open
transactions. If so we need to investigate what is causing this as it
will mean that all subsequent commands get logged and hence the log gets
full quickly.
--- DBCC OPENTRAN ---
--- Analysing humour is like analysing a frog: you can do it, but the frog tends to die in the process.
(--------------------------------) {(((((( ( Suneel Jhangiani ) /_ _ ) ( Technical Director ) ( . . ) ( Inter-Computer Technology Ltd. ) ( / ) (----------------------------------oOOo------------oOOo----) ( 40 James Street Tel: +44 (0) 20 7486 9601 ) ( London W1U 1EU Fax: +44 (0) 7050 678 978 ) ( United Kingdom Email: [EMAIL PROTECTED] ) ( Website: http://www.inctech.com ) (----------------------------------------------------------)
-----Original Message----- From: Lapo Nustrini [mailto:[EMAIL PROTECTED] Sent: 16 January 2004 22:25 To: [EMAIL PROTECTED] Subject: [Modus] MS SQL problem
* This is the modus mailing list *
Unfortunately, we already did this. It seemed to resolve the problem (yesterday) but started failing again after a few hours.
Also, even after shrinking the tempdb (as suggested by a previous poster), the problem continues to reoccur with "The log file for database 'tempdb' is full. Back up the transaction log for the database to free up some log space.." errors showing up in the SQL log every 10 - 15 minutes.
Thanks, Lapo
** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
