Results 1 to 3 of 3

Thread: sybase log

  1. #1
    Join Date
    May 2002
    Posts
    95

    Unanswered: sybase log

    i have an out of sync problem between a table i want to get rid of and the log file. how can i initialize the log or clear it so i can get rid of the table??

  2. #2
    Join Date
    May 2002
    Posts
    95
    never mind

    the command is DBCC REBUILD_LOG

    thanks

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Originally posted by ricka49
    never mind

    the command is DBCC REBUILD_LOG

    thanks
    That command is quite drastic if you just wanted to get rid of a table.

    truncate table <tablename> and then
    drop table <tablename>

    would have done the trick...

Posting Permissions

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