Re: [Emerald] HELP ASAP!!!!!

Josh Hillman ( (no email) )
Thu, 30 Sep 1999 10:49:27 -0400

From: PowerNet <psc5@powersupply.net>
Msg 1105, Level 17, State 2
Can't allocate space for object 'Syslogs' in database 'Emerald' because the
'logsegment' segment is full. If you ran out of space in Syslogs, dump the
transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to
increase the size of the segment.
Msg 1105, Level 17, State 2
Can't allocate space for object 'Syslogs' in database 'Emerald' because the
'logsegment' segment is full. If you ran out of space in Syslogs, dump the
transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to
increase the size of the segment.

Go into SQL enterprise manager
find the Emerald database and double-click on it.
Click on Truncate Log.

I'll send other suggestions for what to do after this in a few minutes.

Josh

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart