Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    chinare
    Posts
    7

    Unanswered: error in process of dropping a proc

    when I want to drop a porc ,just like :

    1> drop proc gp_someproc
    2>go

    it gives me a error message:
    The transaction log in database xxx is almost full.Your transaction is being suspended until space is made available in the log

    how can I solve it ,thanks all

  2. #2
    Join Date
    Aug 2003
    Posts
    123
    report this to your DBA, else run the following command
    dump tran <database name> with no log
    go
    checkpoint
    go

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •