Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    25

    Unanswered: Unable to drop a table

    Hi,

    We have a problem to drop a table.
    We receive, "Cannot drop the table xxx currently in use".
    When we look, there is nobody using this table or locking this table.

    What can we do to drop this table without recycle the server ?

    Regards,

    Xavier

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Pls. provide more info. like Sybase version and error number.

  3. #3
    Join Date
    Nov 2003
    Location
    Belgium
    Posts
    25
    Quote Originally Posted by mkalsi
    Pls. provide more info. like Sybase version and error number.
    ASE version 12.5.1
    Msg 7743

    we detect that it is a problem with some phantom processes (dbt_keep value in the dbtable)

Posting Permissions

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