Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2004
    Location
    Chester Springs, PA
    Posts
    16

    Unanswered: Can't Drop Table

    I have a table that is listed in sysobjects and appears when I execute an empty sp_help, but is reported as nonexistent when I attempt to use it in a query or execute 'sp_help [tablename]'

    I just need to drop the table. Anyone have any advice?

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Can you pls. post the exact error message?

  3. #3
    Join Date
    Feb 2004
    Location
    Chester Springs, PA
    Posts
    16
    Server Message: Number 208, Severity 16
    Server 'foo', Line 1:
    db.dbo.bar not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

    -Standard stuff really. We think someone might have killed a "select into". DBCC checktable also pukes and returns...

    Table named bar not found; check sysobjects
    DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.


    Originally posted by mkalsi
    Can you pls. post the exact error message?

  4. #4
    Join Date
    Jan 2003
    Posts
    62
    Could it be that you're not the owner of that object .. you're only granted select access permission that's all?

    Originally posted by dbslave
    Server Message: Number 208, Severity 16
    Server 'foo', Line 1:
    db.dbo.bar not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

    -Standard stuff really. We think someone might have killed a "select into". DBCC checktable also pukes and returns...

    Table named bar not found; check sysobjects
    DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.

  5. #5
    Join Date
    Feb 2004
    Location
    Chester Springs, PA
    Posts
    16
    I logged in as sa and fully qualified the table path.

    Originally posted by tezza_chen
    Could it be that you're not the owner of that object .. you're only granted select access permission that's all?

  6. #6
    Join Date
    Nov 2002
    Posts
    207
    Can you do a select * from that table?

  7. #7
    Join Date
    Feb 2004
    Location
    Chester Springs, PA
    Posts
    16
    No, you can't select from the table. Believe me, I've tried the obvious things.

    When the user attempted to drop the table, Sybase had an internal error 30935 'xact_beginupdate() API was invoked in the wrong context'.

    The database has left all of the table configuration entries as far as I can see.

  8. #8
    Join Date
    Jan 2003
    Posts
    62
    That shd be error 3935. Doesn't matter what the error is, you gonna get all kind of errors b'coz one of the system catalog is missing the entry! From your earlier mail, I guess this is sysobject. So, you have kind of orphan table. If sysindexes still contains the entry, maybe you can still wrestle around ... but not easy.

    Call Sybase.


    Originally posted by dbslave
    No, you can't select from the table. Believe me, I've tried the obvious things.

    When the user attempted to drop the table, Sybase had an internal error 30935 'xact_beginupdate() API was invoked in the wrong context'.

    The database has left all of the table configuration entries as far as I can see.

  9. #9
    Join Date
    Jun 2002
    Location
    Argentina
    Posts
    78
    Try to find corruption in the databases with this:

    USE database
    go

    dbcc traceon(3604)
    go
    dbcc traceflags
    go


    dbcc checkalloc (database)
    go
    dbcc checkcatalog (database)
    go
    dbcc checkdb (database)
    go

    dbcc checktable(<object_name>)
    go
    dbcc tablealloc(<object_name>, full, nofix)
    go
    dbcc indexalloc(<object_name>, 1, full, nofix)
    go

    -------------------------------------------------------------------------------
    -- INFO TABLE
    -------------------------------------------------------------------------------
    SELECT sysobjects.name tabla,
    sysobjects.id table_id,
    sysindexes.name indice,
    sysindexes.first,
    sysindexes.root,
    sysindexes.doampg,
    sysindexes.ioampg
    FROM sysobjects,
    sysindexes
    WHERE sysobjects.id = sysindexes.id
    AND sysobjects.name like "%<object_name>%"
    go

    Bye bye

    Sebastian

Posting Permissions

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