Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2008
    Posts
    26

    Unanswered: log_reuse_wait_desc for sql server 2000????

    Hi all,

    I was wondering what is the equivalent SQL Server 2000 query for the following SQL Server 2005 query "SELECT name, log_reuse_wait_desc FROM sys.databases"

    I tried using sysdatabases but there is no called column log_reuse_wait_desc. I want to know whether the transaction log reuse is set to nothing, active, reuse for SQL Server 2000.

    Thanks.

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    There is no equivalent in SQL 2000. It is a new feature in SQL 2005.

Posting Permissions

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